| Speakers | |
|---|---|
|
Ronald Bradford |
| Schedule | |
| Day | Sunday |
| Room | AW1.121 |
| Start time | 13:45 |
| End time | 14:15 |
| Duration | 00:30 |
| Info | |
| Event type | Podium |
| Track | MySQL |
| Language | English |
10x performance improvements - A case study
Taking a client from a 700ms (at times 1-2 seconds) page load time to a consistent 60ms is a great success story for improvement in database performance. In this presentation we will outline the steps taken and what can be applied to any website as one model to use in evaluation of your website.
While part of a longer talk, we will be reviewing the highlights including:
- Identify what is truly slow and high volume queries
- Choosing the right indexes including unique indexes, concatenated and partical indexes
- Choosing the right storage engines (MyISAM, InnoDB and Memory)
- Removing load including synchronous/real-time queries, master load, locking and sharding
- The best performance improvement for a SQL statement is to eliminate it
- Quantifying improvements made
- Monitor, Monitor, Monitor
- Identify problem SQL
- Analyze problem SQL
- Indexes
- Offloading master load
- Improving SQL
- Storage engines
- Caching
- Sharding
- Handling database maintenance