how to improve mysql performance?

There are various kind of improvement are available to tweek the mysql configuration to improve and measure how to improve but few of my favorites tips are noted here.

For string columns, MySQL indexes the left side of a string. That means an index can speed a like query that has a wildcard on the right side:

SELECT * FROM users WHERE email LIKE ""

This will be faster with an index column

Tags: performance, mysql, linux

Related posts