Apply Percona best practices to achieve better MySQL database performance and avoid the time, complexity, and risk of customizing a my.cnf configuration on your own. Simply copy and paste the results of the Percona Configuration Wizard for MySQL into your my.cnf file.
Tens of thousands of MySQL users have already used this tool to improve their MySQL performance. When you complete the wizard, your configuration files are saved for future use and you can easily share them with colleagues. Registration is required but your information will not be shared with third parties.
Step 1 of 7 - Tell Us About Your Workload
The suggested configuration will be influenced by the way you use your MySQL server.
Step 2 of 7 - Tell Us About Your Server
Your hardware, operating system, and database size will help determine the basic settings for a few of the configuration options.
We'll start with the simplest information, and the following pages will add more details.
Step 3 of 7 - Confirm Basic Settings
Let's continue with a few basic settings that we need to know in order to compute other options. Check the values we've suggested below, and change them if needed.
Step 4 of 7 - InnoDB Settings
InnoDB is the most powerful and reliable storage engine for MySQL, and correct configuration is important. The built-in defaults are not adequate for production servers.
Step 5 of 7 - Configuring Caches and Limits
Caches are often over-configured in MySQL. Most caches do not need to be changed.
On this page we'll choose settings for a few caches that can influence performance, and some limits that can help prevent overload. These settings are not critical, and will not cause problems if they are not exactly the right size.
Step 6 of 7 - Configure Safety Options
By default, MySQL is not very strict, and can suffer from problems such as permitting invalid data to be inserted. Some features, such as replication, are not always well-behaved in server crashes. Although there are settings to enable many safeguards that can avoid these problems, they are not enabled by default because they change the server's behavior in ways that might not be compatible with existing applications. If you are building a new application, it is a good idea to start with safeguards enabled, but it might not be a good idea for existing applications or off-the-shelf software.
Step 7 of 7 - Finalize Your Server Configuration
We're almost ready to generate your server's configuration file!