User Tools

Site Tools


mysql_ramdisk

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

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