Improve MySQL Performance

26 Nov

service mysql stop

/usr/share/doc/mysql-server-5.5/examples
cp /etc/mysql/my.cnf /etc/mysql/my.cnf.original
gunzip /usr/share/doc/mysql-server-5.5/examples/my-huge.cnf.gz
cp /usr/share/doc/mysql-server-5.5/examples/my-huge.cnf /etc/mysql/my.cnf

nano /etc/mysql/my.cnf

innodb_buffer_pool_size = 24G

service mysql restart
service /etc/init.d/mysql status

Leave a Reply

Your email address will not be published. Required fields are marked *