The Future of MySQL by Monty Widenius and Jay Pipes.
- Why this talk
- MySQL and Sun should become more transparent
- Easier to discuss and act when you have facts
- when user know the limitations, they know how to go around
- Threads
- one connection/thread doesn’t work well
- no priority threads
- no way to ensure we have X threads
- Symptoms
- Too many context switches
- we are not using multi-core efficiently
- does not scale that well after 4-8 cores
- Solution
- –thread-handling=pool-of-threads (6.0) …