Take the 2-minute tour ×  Specifically dual-CPU 32 core - 128RAM
- RAID 10 SSD . Ubuntu 64 server.  Heavy Innodb load at times -
~ 2000+ queries per sec. Heavy read and write.  Currently we are
running on the default write_io_threads of 4.  Are we "nerfing"
the power of our server? Is it safe to run it on max
write_io_threads=64 and read_io_threads = 64 ?  How is this
number determined?  share|improve this question add comment  1
Answer  Back on March 15, 2012, I answered this question : MySql
recommended hardware.  In my answer, I mentioned a client who is
still in my employer's web hosting company to this very day.
They are currently running 3 DB Servers in Circular Replication.
Each DB Server has:    • MySQL 5.5.9   • 192 GB RAM   • 162 GB
InnoDB Buffer Pool   • Dual hexacore (that's right, 12 CPUs)   •
1.8TB Disk Volume   • 528 multitenant databases   • 500 GB of
InnoDB Data   • innodb_file_per_table enabled  I have them set
with  innodb_read_io_threads = 64 innodb_write_io_threads = 64
innodb_thread_conc