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...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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



To submit feedback about this documentation, visit our community forum.

No categories assignedEdit

Discussions