At the system level, you'll adjust hardware and software options to improve MySQL performance. Balance the Four Main Hardware Resources. ... Use InnoDB, Not MyISAM. ... Use the Latest Version of MySQL. ... Consider Using an Automatic Performance Improvement Tool. ... Optimize Queries. ... Use Indexes Where Appropriate. ... Functions in Predicates. More items... Jan 15, 2020