Scaling MySQL on a 256-way T5440 server using Solaris ZFS and Java 1.7
Sunday, December 14, 2008 at 11:40PM
geekr in Diagonal Scaling, Java, MySQL, Scalability, benchmark, multithreading
How to scale MySQL on a 32 core system with 256 threads? Diagonal scalability in a box.
An impressive benchmark that achieved more than 79,000 SQL queries per second on a single 4 RU server! Is this real? If so what is the role of good old horizontal scalability?

The goals of the benchmark:
  1. Reach a high throughput of SQL queries on a 256-way Sun SPARC Enterprise T5440

  2. Do it 21st century style i.e. with MySQL and ZFS , not 20th century style i.e with OraSybInf... and VxFS

  3. Do it with minimal tuning i.e as close as possible as out-of-the-box

Article originally appeared on (
See website for complete article licensing information.