Mine the Harvest

Hot on the heels of the last post on the Intel C Compiler for Linux, a colleague pointed out this MySQL developer post which talks about compiling MYSQL with different options and compilers to obtain performance improvements.

I Googled around, thinking that perhaps there may be some information from people who have specifically tried to compile the  MySQL daemon with the Intel Compiler (ICC). Indeed I found quite a bit. Here is an extremely interesting presentation giving MySQLd benchmarks from compiling with ICC. Although this is based on earlier versions of ICC and MySQL, it is quite likely similar performance benefits could be seen with current versions.

Further looking about I discovered that MySQL binaries compiled using ICC for a variety of platforms are available for download directly from the MySQL Developer site. Just look in the downloads section and you will see the ICC versions available.

This makes it extremely simple to expiriment with these versions and benchmark them to see if they may be useful in a production environment.