{"id":22,"date":"2007-04-19T17:41:29","date_gmt":"2007-04-20T01:41:29","guid":{"rendered":"http:\/\/www.codebelay.com\/blog\/?p=22"},"modified":"2007-04-19T17:41:29","modified_gmt":"2007-04-20T01:41:29","slug":"more-mysql-51-benchmarks-my-code-is-faster-and-slower-wtf","status":"publish","type":"post","link":"https:\/\/www.codebelay.com\/blog\/2007\/04\/19\/more-mysql-51-benchmarks-my-code-is-faster-and-slower-wtf\/","title":{"rendered":"More MySQL 5.1 Benchmarks: My Code is Faster? And Slower? WTF?"},"content":{"rendered":"<p>I decided to <a href=\"\/Partition_benchmarks.tar.gz\">benchmark the code<\/a> that builds out the partitioned and non-partitioned tables.<br \/>\nThe results are very perplexing.<\/p>\n<table>\n<tr>\n<th>table-type<\/th>\n<th>insert<\/th>\n<th>select<\/th>\n<\/tr>\n<tr>\n<td>non-partitioned<\/td>\n<td>34%<\/td>\n<td>1.02%<\/td>\n<\/tr>\n<tr>\n<td>code-partitioned<\/td>\n<td>26.98%<\/td>\n<td>96.87%<\/td>\n<\/tr>\n<tr>\n<td>mysql-partitioned<\/td>\n<td>38.89%<\/td>\n<td>2.03%<\/td>\n<\/tr>\n<\/table>\n<p>Code-partitions are fast on the inserts.<\/p>\n<p>MySQL Partitions are fast on the reads.<\/p>\n<p>This seems to suggest a complicated MySQL master-slave set up where you just have code partitions on the Master and MySQL partitions on the slave. It&#8217;s probably not worth the effort setting up, so I&#8217;ll just go with the MySQL partitions and work on finding ways to make the MySQL code work faster.<\/p>\n<p>What do you folks think?<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I decided to benchmark the code that builds out the partitioned and non-partitioned tables. The results are very perplexing. table-type insert select non-partitioned 34% 1.02% code-partitioned 26.98% 96.87% mysql-partitioned 38.89% 2.03% Code-partitions are fast on the inserts. MySQL Partitions are fast on the reads. This seems to suggest a complicated MySQL master-slave set up where [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4,5],"tags":[],"class_list":["post-22","post","type-post","status-publish","format-standard","hentry","category-how-to","category-techbiz"],"_links":{"self":[{"href":"https:\/\/www.codebelay.com\/blog\/wp-json\/wp\/v2\/posts\/22","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.codebelay.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.codebelay.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.codebelay.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.codebelay.com\/blog\/wp-json\/wp\/v2\/comments?post=22"}],"version-history":[{"count":0,"href":"https:\/\/www.codebelay.com\/blog\/wp-json\/wp\/v2\/posts\/22\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.codebelay.com\/blog\/wp-json\/wp\/v2\/media?parent=22"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.codebelay.com\/blog\/wp-json\/wp\/v2\/categories?post=22"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.codebelay.com\/blog\/wp-json\/wp\/v2\/tags?post=22"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}