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

Translate

Your InnoDB buffer pool is fairly small.
SourceTranslationState
3305
Max InnoDB log size
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
Паралельді_кірістірмелерді анықтау
3314
Enable {concurrent_insert} by setting it to 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>
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

Source string location
libraries/advisory_rules.txt:435
Source string age
4 years ago
Translation file
po/kk.po, string 3310
String priority
Medium