df -h
lvcreate -n mysql -L 5G vg00
mkfs.ext4 -T largefile -L mysql /dev/vg00/mysql
vi /etc/fstab
mkdir /var/lib/mysql
mount -a
df -h
dpkg-reconfigure -plow debconf
apt-get install mysql-server mysql-client
mysql mysql
mysql -p mysql
ls -lh /var/lib/mysql/
ls -lh /var/lib/mysql/mysql
ls -lh /var/lib/mysql/
service mysql stop
rmdir /var/lib/mysql/lost@002bfound
rm /var/lib/mysql/lost@002bfound/db.opt 
rmdir /var/lib/mysql/lost@002bfound
ls -lh /etc/mysql/
vi /etc/mysql/my.cnf
mysql mysql
vi .my.cnf
chmod 600 .my.cnf 
apt-get install sysstat mytop
vmstat 
iostat 
service mysql start
mysql mysql
mysqladmin extended-status
mytop
service mysql stop
vi 99-local.conf 
mv 99-local.conf /etc/sysctl.d/
service procps start
mv tuning.cnf /etc/mysql/conf.d/
vi /etc/mysql/conf.d/tuning.cnf 
mv innodb.cnf /etc/mysql/conf.d/
vi /etc/mysql/conf.d/innodb.cnf
ls -lh /var/lib/mysql/
fg
service mysql status
service mysql stop
cd /var/lib/mysql/
ls -lh
vi /etc/mysql/conf.d/innodb.cnf
fg
rm ibdata1 ib_logfile*
su - mysql -s /bin/bash
ls -lh
service mysql start
service mysql status
mysql mysql
cd
wget https://launchpadlibrarian.net/78745738/tuning-primer.sh
chmod +x tuning-primer.sh
./tuning-primer.sh 
mysql mysql
vi /etc/mysql/my.cnf 
mysqlcheck -A
mysqlcheck --help
mysqlcheck -A -c --auto-repair
mysqldump --help
mysqldump mysql | less
iotop
apt-get install iotop
iotop
iostat 
mysqldump mysql | less
mysqladmin create phpmyadmin
mysql mysql