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

2 thoughts on “Improve MySQL Performance

  1. Need top-notch roof installation in Lancaster? Roof Installation Pros delivers professional services with a skilled team ready to handle all roof types. Their work is reliable, durable, and adds value to your home—trusted by many for timely and budget-friendly roofing solutions.

  2. Get reliable roof installation services in Lancaster with Roof Installation Pros. Whether it’s a new roof or a replacement, their experienced crew delivers quality craftsmanship that lasts. Known for fair pricing and dependable results that boost home value—your roof is in safe hands.

Leave a Reply

Your email address will not be published.