There are many areas you need to review when addressing MySQL performance such as current database load, executed SQL statements, connections, configuration parameters, memory usage, disk to memory ratio, hardware performance & bottlenecks just to name a few.
If you were to just look at the data that is held in the
database, what would you consider?
Here are my tips, when looking just at the data.
- What is the current database size?
- What is the growth of data over time, say daily, weekly?
- Which are the 2 largest tables now?
- What 2 tables are growing the fastest?
- What tables have …