MySQL : utilisation d'un RAM-disque pour les tables temporaires

Boris HUISGEN
Boris HUISGEN
|
root@sql:~# mkdir /tmp/mysqltmp
root@sql:~# chown mysql:mysql /tmp/mysql
root@sql:~# vim /etc/fstab

tmpfs /tmp/mysqltmp tmpfs noatime,nodev,nosuid,noexec,uid=mysql,gid=mysql,mode=0700,size=768m,nr_inodes=10k 0 0

root@sql:~# vim /etc/mysql/my.cnf

tmpdir = /tmp/mysqltmp
Boris HUISGEN
Boris HUISGEN
Blog owner
  • #linux
  • #mysql