Course Code:
bskmysql
Duration:
14 hours
Course Outline:
Queries
- analysis: how to analyze a slow query?
- improve query response times
- how to read slow logs
Indexes
- Do's and don'ts
- How do they work internally
- How to read query execution plan
Locking
- Understanding transaction isolation levels
- Dead locks
- How to read show engine innodb status
- Other locks like schema locks and table locks
Process list
- What's the query state? (statistics, writing to net, sending data, init, create sort index)
Troubleshooting
Summary and Next Steps