I’ve been doing a little tuning with one of my MySQL database servers today, and it’s pretty amazing how fast it is. Just ran a benchmarking thing on it before I applied some optimizations (so this is with no tuning), and this is what it looks like:
Uptime: 747 Threads: 1 Questions: 1409737 Slow queries: 0 Opens: 41055 Flush tables: 1 Open tables: 197 Queries per second avg: 1887.198
Notice the queries per second. And even more impressive is this is for a single threaded benchmark app.