Mysql performance optimization

three important notes in MYSQL performance optimization : -

- Covered indexes are a great MySQL feature and, in most cases, can increase MySQL performance significantly.

- Some queries may also be optimized with a separate index, which will enable the loose index scan algorithm.

- "Order by" optimizations can be done with a covered index and with the "order by+limit" index technique