Table of Contents

How to Tune Up and Optimize your MySQL Configuration

A default installation of MySQL is set up using all of the default settings. However for systems with larger or smaller amounts of resources, the MySQL configuration can be changed to speed up database queries.

These values will be different for your server. If you have any mistyped lines, MySQL will be unable to start. Do not assign more memory than your server has, and always be sure to only use as much memory as your system can spare.

Once you have update the options inside of /etc/my.cnf you will need to restart MySQL to have the new settings in place.

The tuner works best after your server has been online for a while, and should be run periodically to help keep your settings current with your system's needs.

Company

Help

WordPress Hosting Special Offer!

Promo Code: wp-intro

50% OFF WordPress Hosting!

$1.00 WordPress Hosting!

Sign up today and get your first month of WordPress hosting for only $1.00. Our WordPress hosting is a purpose built service designed specifically to increase the performance and security of your WordPress site!

* Offer only valid for 1-Month plans. You may upgrade or change your billing term at any time to receive additional discounts.