Transition Technology: Ticket #591: Move MySQL temporary directory to tmpfs

type changed

ed — Wed, 11 Sep 2013 10:15:43 GMT

type changed from task to maintenance

hours, totalhours changed

chris — Wed, 11 Sep 2013 19:15:00 GMT

hours changed from 0.0 to 0.4
totalhours changed from 0.0 to 0.4

Debian Squeeze has a RAM disk already:

df -h
Filesystem            Size  Used Avail Use% Mounted on
tmpfs                 4.0G   12K  4.0G   1% /dev/shm

So I have added this to /etc/rc.local to create a directory for !MySQL on boot:

mkdir /dev/shm/mysql ; chown mysql:mysql /dev/shm/mysql ; chmod 700 /dev/shm/mysql

And I have edited /etc/mysql/my.cnf:

tmpdir                  = /dev/shm/mysql

One thing we will have to remember is that /dev/shm will become /run/shm when we upgrade to Wheezy on ticket:535

hours, status, totalhours changed; resolution set

chris — Wed, 11 Sep 2013 19:33:10 GMT

hours changed from 0.0 to 0.1
status changed from new to closed
resolution set to fixed
totalhours changed from 0.4 to 0.5

And check it's set:

MariaDB [(none)]> SHOW VARIABLES LIKE 'tmpdir';
+---------------+----------------+
| Variable_name | Value          |
+---------------+----------------+
| tmpdir        | /dev/shm/mysql |
+---------------+----------------+
1 row in set (0.01 sec)

chris — Thu, 03 Oct 2013 09:43:43 GMT

I have added a link to this ticket from wiki:PuffinServer#MariaDB.

chris — Tue, 14 Jan 2014 12:31:06 GMT

There is a crontab entry to create and chown the directory on the ram disk, see wiki:PuffinServer#Cron