Even though you can tune quite a lot of variables in MySQL Servers only few of them are really important for most common workload. After you get these settings right other changes will most commonly offer only incremental performance improvements. key_buffer_size – Very important if you use MyISAM tables. Set up to 30-40% of available … Continue Reading