What is the recommended filesystem + mysqltmp location when dealing with a ssd based system that has some ram to spare?
Currently we run our mysqltmp folder on a 4gb tmpfs partition. Works great. But the box is getting an upgrade that will include a full ssd setup.
1) When dealing with a system that has BOTH ssd and a large amount of ram, where should we place our mysqltmp folder? There ARE some infrequent large sorts that end up hitting the mysqltmp.
2) How do we deal with the system swap file when running linux on a ssd setup?
3) What is the recommended file system for a mysqld box running on linux on ssds?