Warming/Loading tables into MySQL Cache
After restarting MySQL you’re left with a cold machine. No cache. Putting this directly back into use can leave it struggling to load data from disk again.
One way of helping out is to give it some time to load table data back into that vast amount of RAM it has.
One way I’ve found that’s helped me is to create a temporary table, alter it’s engine into a black hole then select everything from an existing table into it.
CREATE TEMPORARY TABLE blackholeMyTable ENGINE=BLACKHOLE SELECT * FROM MyTable;
This cause MySQL to go though the works of loading the data from disk to insert into a blackhole. Thus being put into RAM.
