Slide 26
Slide 26 text
EffectiveMySQL.com
#mysql #emea2014
Effective Web Site Operations
installation ideals
sudo su -
mkdir -p /mysql/{data,log,binlog,etc,tmp}
mkdir -p /var/run/mysqld
chown -R mysql:mysql /mysql /var/run/mysqld
chmod 700 /mysql/{data,binlog}
chmod 750 /mysql/log
chmod 755 /mysql/etc/ /var/run/mysqld
rm -rf /var/log/mysql /var/log/mysql*log* /etc/my.cnf
ln -s /mysql/log /var/log/mysql
ls -s /mysql/etc/my.cnf /etc/my.cnf
ls -s /mysql/etc/mysqld /etc/init.d/mysqld
26
Dedicated /mysql partition
ext4/xfs ++specific improvements