Revision as of 14:57, 22 December 2021 by Redaktion (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)
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