{"id":4003,"date":"2015-10-19T11:04:07","date_gmt":"2015-10-19T01:04:07","guid":{"rendered":"https:\/\/www.flamingspork.com\/blog\/?p=4003"},"modified":"2015-10-19T11:04:07","modified_gmt":"2015-10-19T01:04:07","slug":"1-million-sql-queries-per-second-ga-mariadb-10-1-on-power8","status":"publish","type":"post","link":"https:\/\/www.flamingspork.com\/blog\/2015\/10\/19\/1-million-sql-queries-per-second-ga-mariadb-10-1-on-power8\/","title":{"rendered":"1 Million SQL Queries per second: GA MariaDB 10.1 on POWER8"},"content":{"rendered":"

A couple of days ago, MariaDB<\/a> announced that MariaDB 10.1 is stable GA<\/a> – around 19 months since the GA of MariaDB 10.0<\/a>. With MariaDB 10.1 comes some important scalabiity improvements, <\/strong>especially for POWER8 systems. On POWER, we’re a bit unique in that we’re on the higher end of CPUs, have many cores, and up to 8 threads per core (selectable at runtime: 1, 2, 4 or 8\/core) – so a dual socket system can easily be a 160 thread machine.<\/p>\n

Recently, we (being IBM) announced availability of a couple of new POWER8 machines – machines designed for Linux and cloud environments. They are very much OpenPower machines, and more info is available here: http:\/\/www.ibm.com\/marketplace\/cloud\/commercial-computing\/us\/en-us<\/a><\/p>\n

Combine these two together, with Axel Schwenke running some benchmarks and you get 1 Million SQL Queries per second with MariaDB 10.1 on POWER8<\/a><\/strong>.<\/p>\n

Having worked a lot on both MySQL for POWER and the firmware that ships in the S882LC, I’m rather happy that 1 Million queries per second is beyond what it was in June 2014<\/a>, which was a neat hack on MySQL 5.7 that showed the potential<\/strong> of MySQL on POWER8 but wasn’t yet a product. Now, you can run a GA release of MariaDB on GA POWER8 hardware designed for scale-out cloud environments and get 1 Million SQL queries\/second (with fewer cores than my initial benchmark last year!)<\/p>\n

What’s even more impressive is that this million queries per second is in a KVM guest!<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"

A couple of days ago, MariaDB announced that MariaDB 10.1 is stable GA – around 19 months since the GA of MariaDB 10.0. With MariaDB 10.1 comes some important scalabiity improvements, especially for POWER8 systems. On POWER, we’re a bit … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[570,14,588,615],"tags":[340,628,587,562,568,637,109,55],"class_list":["post-4003","post","type-post","status-publish","format-standard","hentry","category-ibm-work-et-al","category-mysql","category-opal","category-powerpc","tag-mariadb","tag-mysql","tag-openpower","tag-power","tag-power8","tag-powerpc","tag-sql","tag-ubuntu"],"jetpack_publicize_connections":[],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p5a6n8-12z","jetpack-related-posts":[{"id":4019,"url":"https:\/\/www.flamingspork.com\/blog\/2015\/12\/18\/power8-accelerated-crc32-merged-in-mariadb-10-1\/","url_meta":{"origin":4003,"position":0},"title":"POWER8 Accelerated CRC32 merged in MariaDB 10.1","author":"Stewart Smith","date":"2015-12-18","format":false,"excerpt":"Earlier on in benchmarking MySQL and MariaDB on POWER8, we noticed that on write workloads (or read workloads involving a lot of IO) we were spending a bunch of time computing InnoDB page checksums. This is a relatively well known MySQL problem and has existed for many years and Percona\u2026","rel":"","context":"In "IBM"","block_context":{"text":"IBM","link":"https:\/\/www.flamingspork.com\/blog\/category\/work-et-al\/ibm-work-et-al\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":3959,"url":"https:\/\/www.flamingspork.com\/blog\/2015\/04\/28\/going-beyond-1-3-million-sql-queriessecond\/","url_meta":{"origin":4003,"position":1},"title":"Going beyond 1.3 MILLION SQL Queries\/second","author":"Stewart Smith","date":"2015-04-28","format":false,"excerpt":"So, on a large IBM POWER8 system I was recently running the newly coined \"yesmark\" benchmark, which is best translated as this: Benchmark (N for concurrency): for i in {1..N}; do yes \"DO 0;\" | mysql > \/dev\/null & done Live results: mysqladmin -ri 1 extended-status | grep Questions Which\u2026","rel":"","context":"In "IBM"","block_context":{"text":"IBM","link":"https:\/\/www.flamingspork.com\/blog\/category\/work-et-al\/ibm-work-et-al\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":3795,"url":"https:\/\/www.flamingspork.com\/blog\/2014\/10\/08\/mariadb-10-0-on-power\/","url_meta":{"origin":4003,"position":2},"title":"MariaDB 10.0 on POWER","author":"Stewart Smith","date":"2014-10-08","format":false,"excerpt":"Good news for those wanting to run MariaDB on POWER systems, the latest 10.0 bzr tree (as of a couple of weeks ago) builds and runs well! I recently pulled the latest MariaDB 10.0 from BZR and built it on a POWER8 system in the lab to run some quick\u2026","rel":"","context":"In "IBM"","block_context":{"text":"IBM","link":"https:\/\/www.flamingspork.com\/blog\/category\/work-et-al\/ibm-work-et-al\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":4052,"url":"https:\/\/www.flamingspork.com\/blog\/2016\/05\/06\/video-of-my-percona-live-talk-why-would-i-run-mysqlmariadb-on-power-anyway\/","url_meta":{"origin":4003,"position":3},"title":"Video of my Percona Live Talk: Why would I run MySQL\/MariaDB on POWER anyway?","author":"Stewart Smith","date":"2016-05-06","format":false,"excerpt":"Good news everyone! There's video up for the talk I gave at Percona Live in April 2016 up: Why would I run MySQL\/MariaDB on POWER anyway? The talk is a general overview of POWER and why MySQL\/MariaDB may be a good fit.","rel":"","context":"In "IBM"","block_context":{"text":"IBM","link":"https:\/\/www.flamingspork.com\/blog\/category\/work-et-al\/ibm-work-et-al\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/img.youtube.com\/vi\/UgwGHe46wqk\/0.jpg?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":3263,"url":"https:\/\/www.flamingspork.com\/blog\/2013\/03\/15\/diffstat-of-mysql-5-6-versus-5-5\/","url_meta":{"origin":4003,"position":4},"title":"diffstat of MySQL 5.6 versus 5.5","author":"Stewart Smith","date":"2013-03-15","format":false,"excerpt":"Yesterday I wrote about what the diffstat between MySQL 5.5 and MariaDB 5.5 was, and previously to that, about the MariaDB code size as reported by sloccount. Let's look at MySQL 5.6. A naive wc based \"lines of code\" for MySQL 5.6 sql\/ directory is ~490kLOC which contasts with MySQL\u2026","rel":"","context":"In "code"","block_context":{"text":"code","link":"https:\/\/www.flamingspork.com\/blog\/category\/code\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":3925,"url":"https:\/\/www.flamingspork.com\/blog\/2014\/12\/23\/more-openpower-firmware-code-released-occ\/","url_meta":{"origin":4003,"position":5},"title":"More OpenPower Firmware code released: OCC","author":"Stewart Smith","date":"2014-12-23","format":false,"excerpt":"Inside the IBM POWER8 chip there's another processor! That's right folks, you get another CPU for no extra cost (It's a lot funnier if you say these previous two sentences as if you were presenting an informercial for a special TV offer). It is, however, not what you'd consider a\u2026","rel":"","context":"In "code"","block_context":{"text":"code","link":"https:\/\/www.flamingspork.com\/blog\/category\/code\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"jetpack_likes_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/posts\/4003","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/comments?post=4003"}],"version-history":[{"count":1,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/posts\/4003\/revisions"}],"predecessor-version":[{"id":4004,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/posts\/4003\/revisions\/4004"}],"wp:attachment":[{"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/media?parent=4003"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/categories?post=4003"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/tags?post=4003"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}