Thursday, August 30, 2012

Mysql: Setting ibdata log files

//edit my.cnf and add innodb parameters
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://www.epigroove.com/blog/optimize-mysql-the-thread-cache
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