MySQL memory usage / settings

sources: https://dev.mysql.com/doc/refman/5.7/en/memory-use.html https://bugs.mysql.com/bug.php?id=41440 https://dev.mysql.com/doc/refman/5.5/en/innodb-buffer-pool.html InnoDB buffer pool: usual recommendation is 50 – 75% of available RAM on dedicate database...

Useful settings

switch off foreign keys for operation with data: SET foreign_key_checks = 0; switch off save update mode for more complicated updates: SET SQL_SAFE_UPDATES = 0;

mySQL and more CPUs

there are misunderstatements about multicore usage per query or per server per server: multiple threaths can handle I/O operations InnoDB 5.7 should be able to scale up to 60 cores, in 5.1 it was max 8 cores parameters: innodb_concurrency_tickets...

Memory settings

On internet we can find some hins or pages which can help: http://www.mysqlcalculator.com/ – mySQL memory calculator