vi /etc/my.cnf
innodb_buffer_pool_size = 2G
innodb_file_per_table
innodb_log_buffer_size=8M
innodb_log_file_size=512M
//dump all dbases
mysqldump -u root --all-databases > /mnt/share/dump/alldb.sql
//backup mysql content
cd /var/lib/mysql
cp -ax * /mnt/share
service mysqld stop
//remove /var/lib/mysql except mysql db
rm -rf *
cp -a /mnt/share/mysql.sock .
cp -aR /mnt/share/mysql/ .
service mysqld start
//import all dbases and restart
mysql -u root < /mnt/share/dumb/alldb.sql
service mysqld restart
http://mysqldatabaseadministration.blogspot.com/2005/11/mysql-5-optimization-and-tuning-guide.html
http://serverfault.com/questions/42789/how-to-increase-memory-usage-in-mysql-server-to-improve-speed
No comments:
Post a Comment