MySQL Performance tuning considerations

1. The leftmost principle notice encounters > < like between invalidation

2. Invalid left-most index encountered for like query

3.SQL Performance Optimization Goal: at least the range (range lookup to index) level is required to be a ref (normal index) level, preferably consts (up to one matching row in a single table = PRIMARY key or unique index)

4. Do not write a chatty data update interface. Do not update the non-modified fields when executing SQL, one is error-prone, the other is inefficient, and the third is to increase binlog storage.

5. Transactions will increase the database's QPS so don't misuse

MySQL Performance tuning considerations