Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question
The best FS is whatever's best supported by your OS. I suspect that's Ext4 – Tom O'Connor Oct 26 '11 at 20:34

A tmpfs partition will still perform better than a SSD if you need every last oomph of speed. As for filesystem, something newer and production-quality would be best; and these days that's pretty much EXT4 (assuming Linux) or ZFS (if BSD). Btrfs is still technically experimental, so I wouldn't recommend it.

share|improve this answer

Note that InnoDB can also run directly on block devices, no need for filesystem. It takes a little planning, but you get the best filesystem: none at all.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.