| [quality revision] | [quality revision] |
(translation EN) (Tag: 2017 source edit) |
(Tag: 2017 source edit) |
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-Kernen 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>
{{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 my.ini:
<pre>[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-Kernen
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>
</pre>
[[en:{{PAGENAMEFULLPAGENAME}}]][[de:Setup:Installationsanleitung/Kompendium/Performance-Optimierungen/MySQL]]| (2 intermediate revisions by one other user not shown) | |||
| Line 9: | Line 9: | ||
query_cache_size=1024M | query_cache_size=1024M | ||
| − | ; with 12 CPU | + | ; with 12 CPU cores |
innodb-buffer-pool-instances=12 | innodb-buffer-pool-instances=12 | ||
max_connections=12000 | max_connections=12000 | ||
| Line 15: | Line 15: | ||
; Only use "127.0.0.1", not "localhost" when accessing MySQL | ; Only use "127.0.0.1", not "localhost" when accessing MySQL | ||
; Remember to also make these changes in the $wgDBserver variable in LocalSettings.php. | ; Remember to also make these changes in the $wgDBserver variable in LocalSettings.php. | ||
| − | skip-name-resolve </ pre> | + | skip-name-resolve</pre> |
| − | [[en:{{ | + | [[en:{{FULLPAGENAME}}]][[de:Setup:Installationsanleitung/Kompendium/Performance-Optimierungen/MySQL]] |