{"id":157,"date":"2008-10-23T14:30:12","date_gmt":"2008-10-23T18:30:12","guid":{"rendered":"http:\/\/www.timelordz.com\/blog\/?p=157"},"modified":"2008-10-28T14:44:20","modified_gmt":"2008-10-28T18:44:20","slug":"mysql-server-and-intel-compiler","status":"publish","type":"post","link":"https:\/\/www.timelordz.com\/blog\/2008\/10\/mysql-server-and-intel-compiler\/","title":{"rendered":"MySQL Server and Intel Compiler"},"content":{"rendered":"<p>Hot on the heels of the last post on the Intel C Compiler for Linux, a colleague pointed out this MySQL <a title=\"MySQL Dev Compiling\" href=\"http:\/\/dev.mysql.com\/doc\/refman\/5.0\/en\/compile-and-link-options.html\" target=\"_blank\">developer post<\/a> which talks about compiling MYSQL with different options and compilers to obtain performance improvements.<\/p>\n<p>I Googled around, thinking that perhaps there may be some information from people who have specifically tried to compile the\u00a0 MySQL daemon with the Intel Compiler (ICC). Indeed I found quite a bit. Here is an extremely interesting <a title=\"MySQL ICC Presentation\" href=\"http:\/\/www.mysqlperformanceblog.com\/files\/presentations\/LinuxWorld2005-Intel.pdf\" target=\"_blank\">presentation <\/a>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.<\/p>\n<p>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 <a title=\"MySQL Downloads\" href=\"http:\/\/dev.mysql.com\/downloads\/mysql\/5.0.html#downloads\" target=\"_blank\">downloads<\/a> section and you will see the ICC versions available.<\/p>\n<p>This makes it extremely simple to expiriment with these versions and benchmark them to see if they may be useful in a production environment.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>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 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6,7],"tags":[],"class_list":["post-157","post","type-post","status-publish","format-standard","hentry","category-linux","category-sagolabs"],"_links":{"self":[{"href":"https:\/\/www.timelordz.com\/blog\/wp-json\/wp\/v2\/posts\/157","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.timelordz.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.timelordz.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.timelordz.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.timelordz.com\/blog\/wp-json\/wp\/v2\/comments?post=157"}],"version-history":[{"count":3,"href":"https:\/\/www.timelordz.com\/blog\/wp-json\/wp\/v2\/posts\/157\/revisions"}],"predecessor-version":[{"id":159,"href":"https:\/\/www.timelordz.com\/blog\/wp-json\/wp\/v2\/posts\/157\/revisions\/159"}],"wp:attachment":[{"href":"https:\/\/www.timelordz.com\/blog\/wp-json\/wp\/v2\/media?parent=157"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.timelordz.com\/blog\/wp-json\/wp\/v2\/categories?post=157"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.timelordz.com\/blog\/wp-json\/wp\/v2\/tags?post=157"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}