Slow query log.
Tuning my.cnf.
DESCRIBE query.
Scaling
When your database holds millions of records, or you have thousands of simultaneous connections, you need to think about scaling your system. This will often require changes across your network infrastructure not just your database.
Sharding means splitting the database into sections so different parts of the data can be stored on separate systems.
Mirroring copies the database to another location, like another region or server to reduce load or allow faster retrieval.
Level
Topics