MySQL memory usage / settings

sources: 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: – mySQL memory calculator