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 greatest churn, specifically DELETE’s?
- How often do you optimize your tables?
- What is your archiving/purging strategy? Do you even have one?
- Review data types? I average 25% reduction in footprints, just by choosing optimal data types, generally with zero …