Revision as of 15:57, 22 December 2021 by Margit Link-Rodrigue (talk | contribs) (Created page with "{{DISPLAYTITLE:Performance Optimization: MySQL (MariaDB)}} Match MySQL or MariaDB directly to your memory and CPU cores. To do this, apply the following configuration in your...")
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
