The value of the max_connections parameter should correlate with the total number of PHP threads configured in the application server. For best efficiency, specify a combination of innodb_buffer_pool_instances and innodb_buffer_pool_size so that each buffer pool instance is at least 1 GB. The total size is divided among all the buffer pools. The default value is set to 8 to avoid issues with multiple threads attempting to access the same instance.Ĭombined with the multiple pool instances described above, this means a default memory allocation of 1024MB. The most critical settings are: Parameter There have been many improvements to MySQL 5.7.9 We are confident that MySQL is distributed with good default settings. This document does not provide in-depth MySQL tuning instructions because each store and environment is different, but we can make some general recommendations. You should also configure the number of threads for input request processing, as listed below: Web server
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |