You are viewing an old version of this page. Return to the latest version.
No categories assigned
Performance Optimization: MySQL (MariaDB)
-
- Last edited 4 years ago by MLR
-
< Setup:Installation Guide | Advanced | Performance Optimization
Revision as of 13:00, 29 November 2019 by Mlink-rodrigue (talk | contribs) (Text replacement - "[[en:{{PAGENAME}}]]" to "[[en:{{FULLPAGENAME}}]]")
Match MySQL or MariaDB directly to your memory and CPU cores. To do this, apply the following configuration in your my.ini:
[mysqld] ; with 16GB RAM innodb_buffer_pool_size=4096M tmp-table-size=1024M max-heap-table-size=1024M query_cache_size=1024M ; with 12 CPU cores innodb-buffer-pool-instances=12 max_connections=12000 ; Only use "127.0.0.1", not "localhost" when accessing MySQL ; Remember to also make these changes in the $wgDBserver variable in LocalSettings.php. skip-name-resolve </ pre>