MySQL server optimization

Of course, it's important to keep in mind that there are different settings that work better for some servers with light and predictable loads, compared to servers running at almost full capacity all the time or those experiencing high activity variations.

In the following sections, we will discuss the the main optimization steps you can perform.

Control the types of data change operations

When operations such as INSERT, UPDATE, and DELETE are run on a table, the values of the indexed columns are often in unsorted order, and this will require input/output; updating the secondary indexes included will adversely affect performance.

However, InnoDB caches (in memory) the changes made to secondary...