Followup on Experiment: MySQL tmpdir on tmpfs, about tmpdir=/dev/shm in my.cnf (it’s not a dynamic variable that can be set at runtime). It’s working well, also confirmed by comments from others that they’ve been using it for a while. This particular setting is Linux specific. On Solaris, the default /tmp is already on a tmpfs so [...]
Filed under: Uncategorized by arjen on Tuesday, June 16, 2009 | Social tagging: /dev/shm > linux > mysql > shm > slave-load-tmpdir > slave_load_tmpdir > temp tables > temporary tables > tmp tables > tmpdir > tmpfs
6 Comments »
In MySQL, the tmpdir path is mainly used for disk-based sorts (if the sort_buffer_size is not enough) and disk-based temp tables. The latter cannot always be avoided even if you made tmp_table_size and max_heap_table_size quite large, since MEMORY tables don’t support TEXT/BLOB type columns, and also since you just really don’t want to run the [...]
Filed under: Uncategorized by arjen on Saturday, June 13, 2009 | Social tagging: /dev/shm > linux > mysql > shm > temp tables > temporary tables > tmp tables > tmpdir > tmpfs
9 Comments »