mysql_ramdisk
Differences
This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
|
mysql_ramdisk [2014/12/07 19:36] kyxap created |
mysql_ramdisk [2014/12/07 20:24] (current) kyxap |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | {{tag>mysql bash backup}} | + | {{tag>mysql bash tmpfs linux freebsd}} |
| - | ====== mysqld с tmpdir в RAM ====== | + | ====== Использование RAM-диска в качестве tmpdir для MySQL ====== |
| - | + | ||
| - | ==== FreeBSD ==== | + | |
| - | + | ||
| - | <code - /etc/rc.local> | + | |
| - | if ! /bin/df /tmp/mysql | grep -q "^/dev/md[0-9]"; then | + | |
| - | mkdir -p /tmp/mysql | + | |
| - | mount_mfs -s 1024m -o noexec md5 /tmp/mysql | + | |
| - | chown mysql:mysql /tmp/mysql | + | |
| - | fi | + | |
| - | </code> | + | |
| <code - my.cnf> | <code - my.cnf> | ||
| Line 19: | Line 9: | ||
| tmpdir=/tmp | tmpdir=/tmp | ||
| + | [client] | ||
| + | tmpdir=/tmp | ||
| </code> | </code> | ||
| + | |||
| + | ==== Инициализация md в FreeBSD ==== | ||
| + | <code - /etc/rc.local> | ||
| + | MYSQL_TMPDIR=/tmp/mysql | ||
| + | if ! /bin/df $MYSQL_TMPDIR | grep -q "^/dev/md[0-9]"; then | ||
| + | mkdir -p $MYSQL_TMPDIR | ||
| + | mount_mfs -s 1024m -p 0700 -w mysql:mysql -o noexec md5 $MYSQL_TMPDIR | ||
| + | fi | ||
| + | </code> | ||
| + | |||
| + | ==== Инициализация tmpfs в Linux ==== | ||
| + | <code - /etc/rc.local> | ||
| + | MYSQL_TMPDIR=/tmp/mysql | ||
| + | mkdir -p $MYSQL_TMPDIR | ||
| + | chown mysql:mysql $MYSQL_TMPDIR | ||
| + | mount -t tmpfs -osize=1024m,uid=mysql,gid=mysql,mode=0700,relatime tmpfs $MYSQL_TMPDIR | ||
| + | </code> | ||
| + | |||
mysql_ramdisk.1417980997.txt.gz · Last modified: 2014/12/07 19:36 by kyxap
