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> | ||
+ |