View contributor agreement Contribution to this translation requires you to agree with a contributor agreement.
 

Translate

The InnoDB buffer pool has a profound impact on performance for InnoDB tables. Assign all your remaining memory to this buffer. For database servers that use solely InnoDB as storage engine and have no other services (e.g. a web server) running, you may set this as high as 80%% of your available memory. If that is not the case, you need to carefully assess the memory consumption of your other services and non-InnoDB-Tables and set this variable accordingly. If it is set too high, your system will start swapping, which decreases performance significantly. See also <a href="https://www.percona.com/blog/2007/11/03/choosing-innodb_buffer_pool_size/">this article</a>
SourceTranslationState
3306
The InnoDB log file size is inadequately large.
3307
It is usually sufficient to set {innodb_log_file_size} to 25%% of the size of {innodb_buffer_pool_size}. A very big {innodb_log_file_size} slows down the recovery time after a database crash considerably. See also <a href="https://www.percona.com/blog/2006/07/03/choosing-proper-innodb_log_file_size/">this Article</a>. You need to shutdown the server, remove the InnoDB log files, set the new value in my.cnf, start the server, then check the error logs if everything went fine. See also <a href="https://mysqldatabaseadministration.blogspot.com/2007/01/increase-innodblogfilesize-proper-way.html">this blog entry</a>
3308
Your absolute InnoDB log size is %s MiB
3309
InnoDB buffer pool size
3310
Your InnoDB buffer pool is fairly small.
3311
The InnoDB buffer pool has a profound impact on performance for InnoDB tables. Assign all your remaining memory to this buffer. For database servers that use solely InnoDB as storage engine and have no other services (e.g. a web server) running, you may set this as high as 80%% of your available memory. If that is not the case, you need to carefully assess the memory consumption of your other services and non-InnoDB-Tables and set this variable accordingly. If it is set too high, your system will start swapping, which decreases performance significantly. See also <a href="https://www.percona.com/blog/2007/11/03/choosing-innodb_buffer_pool_size/">this article</a>
3312
You are currently using %s%% of your memory for the InnoDB buffer pool. This rule fires if you are assigning less than 60%%, however this might be perfectly adequate for your system if you don't have much InnoDB tables or other services running on the same machine.
3313
MyISAM concurrent inserts
MyISAM ادخالات متزامنة
3314
Enable {concurrent_insert} by setting it to 1
مكّن {concurrent_insert} من خلال تعيينه الى 1
3315
Setting {concurrent_insert} to 1 reduces contention between readers and writers for a given table. See also <a href="https://dev.mysql.com/doc/refman/5.5/en/concurrent-inserts.html">MySQL Documentation</a>
3316
concurrent_insert is set to 0
تم تعيين concurrent_insert الى 0
ComponentTranslation
This translation Not translated phpMyAdmin/Development
Following string has same context and same source.
Not translated phpMyAdmin/4.8

Loading…

Loading…

Glossary

Source Translation
No related strings found in the glossary.

Source information

Flags
php-format
Source string location
libraries/advisory_rules.txt:436
Source string age
2 years ago
Translation file
po/ar.po, string 3311
String priority
Medium