| Speakers | |
|---|---|
| Istvan Podor | |
| Schedule | |
| Day | Saturday |
| Room | H.2213 |
| Capacity | 100 |
| Start time | 14:30 |
| End time | 14:55 |
| Duration | 00:25 |
| Info | |
| Track | MySQL & friends devroom |
Over 20,000QPS, XtraDB performance show
In this short 20 minute talk I would like to give you a quick look into the process I've optimized read-slaves for a high traffic website (Alexa top500) using xtradb. When I started to work on this project the slaves were able to serve like 5-8k QPS with a basically default configuration. When I was done, in peak times we goes over 20,000QPS having a low load. I would like to use my 20 minutes to show how I optimized the mysql server and show what effects each optimization had and how we tuned a standard mysql replica slave to a beast. In this presentation I don't want to mention query tuning.
In this short 20 minute talk I would like to give you a quick look into the process I've optimized read-slaves for a high traffic website (Alexa top500) using xtradb. When I started to work on this project the slaves were able to serve like 5-8k QPS with a basically default configuration. When I was done, in peak times we goes over 20,000QPS having a low load. I would like to use my 20 minutes to show how I optimized the mysql server and show what effects each optimization had and how we tuned a standard mysql replica slave to a beast. In this presentation I don't want to mention query tuning.
Concurrent events:
Next (up to 3) talks in the same room (H.2213):
| When | Event | Track |
|---|---|---|
| 15:00-15:25 | Data Recovery for MySQL | MySQL & friends |
| 15:30-15:55 | Taking Backups With XtraBackup | MySQL & friends |
| 16:00-16:25 | New query optimizer features in MariaDB | MySQL & friends |