Re: MySQL 5.5.8 - Configuration Settings Suggestions

[Rick James]

Memory: http://mysql.rjweb.org/doc.php/memory

"Load" = CPU = Poor queries / poor indexes / etc.

To assist in analyzing slow SELECTs, please provide
* SHOW CREATE TABLE tbl\G -- engine, indexes
* SHOW TABLE STATUS LIKE 'tbl'\G -- sizes
* EXPLAIN SELECT ...\G -- clues of inefficiencies
* SHOW VARIABLES LIKE '%buffer%'; -- cache size
and surround them with [ code ] and [ / code ]

Swapping -- really bad for MySQL.