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..." Tag: 2017 source edit |
m (username removed) (log details removed) |
||
(No difference)
| |||
Latest revision as of 11:57, 5 June 2025
Archived!
This documentation is obsolete and no longer applies to the current BlueSpice version.
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
