{"id":4174,"date":"2016-09-22T19:22:23","date_gmt":"2016-09-22T09:22:23","guid":{"rendered":"https:\/\/www.flamingspork.com\/blog\/?p=4174"},"modified":"2016-09-22T19:22:23","modified_gmt":"2016-09-22T09:22:23","slug":"lesson-124-in-why-scales-on-a-graph-matter","status":"publish","type":"post","link":"https:\/\/www.flamingspork.com\/blog\/2016\/09\/22\/lesson-124-in-why-scales-on-a-graph-matter\/","title":{"rendered":"Lesson 124 in why scales on a graph matter&#8230;"},"content":{"rendered":"<p>The original article presented two graphs: one of MariaDB searches (which are increasing) and the other showing MySQL searches (decreasing or leveling out). It turns out that the y axis <strong>REALLY<\/strong> matters.<\/p>\n<p>I honestly expected better&#8230;.<\/p>\n<blockquote class=\"twitter-tweet\" data-lang=\"en\">\n<p dir=\"ltr\" lang=\"en\"><a href=\"https:\/\/twitter.com\/mariadb\">@mariadb<\/a> that Trends graph is misleading. Steady over 12months, flattening from peak 12+y ago, well before MariaDB. <a href=\"https:\/\/t.co\/sP6H65FEvR\">pic.twitter.com\/sP6H65FEvR<\/a><\/p>\n<p>\u00e2\u20ac\u201d Stewart Smith (@stewartsmith) <a href=\"https:\/\/twitter.com\/stewartsmith\/status\/778760543851147266\">September 22, 2016<\/a><\/p><\/blockquote>\n<p><script async src=\"\/\/platform.twitter.com\/widgets.js\" charset=\"utf-8\"><\/script><\/p>\n<blockquote class=\"twitter-tweet\" data-lang=\"en\">\n<p dir=\"ltr\" lang=\"en\">Try &#8220;Will <a href=\"https:\/\/twitter.com\/mariadb\">@mariadb<\/a> ever replace <a href=\"https:\/\/twitter.com\/postgresql\">@postgresql<\/a> &#8220;. At current rate, equal on Google Trends in 12-20 years if no pg growth. <a href=\"https:\/\/t.co\/6BP9FuU1RU\">pic.twitter.com\/6BP9FuU1RU<\/a><\/p>\n<p>\u00e2\u20ac\u201d Stewart Smith (@stewartsmith) <a href=\"https:\/\/twitter.com\/stewartsmith\/status\/778762579439194112\">September 22, 2016<\/a><\/p><\/blockquote>\n<p><script async src=\"\/\/platform.twitter.com\/widgets.js\" charset=\"utf-8\"><\/script><\/p>\n","protected":false},"excerpt":{"rendered":"<p>The original article presented two graphs: one of MariaDB searches (which are increasing) and the other showing MySQL searches (decreasing or leveling out). It turns out that the y axis REALLY matters. I honestly expected better&#8230;. @mariadb that Trends graph &hellip; <a href=\"https:\/\/www.flamingspork.com\/blog\/2016\/09\/22\/lesson-124-in-why-scales-on-a-graph-matter\/\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_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}},"categories":[14],"tags":[340,628,693],"class_list":["post-4174","post","type-post","status-publish","format-standard","hentry","category-mysql","tag-mariadb","tag-mysql","tag-trends"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p5a6n8-15k","jetpack-related-posts":[{"id":3238,"url":"https:\/\/www.flamingspork.com\/blog\/2013\/03\/06\/mariadb-code-size\/","url_meta":{"origin":4174,"position":0},"title":"MariaDB code size","author":"Stewart Smith","date":"2013-03-06","format":false,"excerpt":"Continuing on from my previous post,\u00c2\u00a0MySQL code size over releases. I wanted to look at the different branches\/patch sets of MySQL out there and work out how far from upstream they deviated. I'm just going to compare against whatever upstream version the most easily accessible version is based on (be\u2026","rel":"","context":"In &quot;General&quot;","block_context":{"text":"General","link":"https:\/\/www.flamingspork.com\/blog\/category\/general\/"},"img":{"alt_text":"","src":"https:\/\/docs.google.com\/spreadsheet\/oimg?key=0Ar7e3-N2Y32IdHFGRWI2ODk4ZUY4TkhrclJSVC1mb3c&oid=4&zx=imt1yst694nh","width":350,"height":200},"classes":[]},{"id":3391,"url":"https:\/\/www.flamingspork.com\/blog\/2013\/08\/09\/are-mariadb-tests-adding-anything-extra-over-oracle-mysql-tests\/","url_meta":{"origin":4174,"position":1},"title":"Are MariaDB tests adding anything extra over Oracle MySQL tests?","author":"Stewart Smith","date":"2013-08-09","format":false,"excerpt":"I grabbed all the tests introduced in MariaDB 5.5.32 (i.e. \"bzr diff -rtag:mariadb-5.5.31..mariadb-5.5.32 mysql-test\/\" and some foo) and threw them in their own test file. I only kept tests for crashing bugs and ignored those that required plugins (there were two or three, but nothing major). So now I have\u2026","rel":"","context":"In &quot;mysql&quot;","block_context":{"text":"mysql","link":"https:\/\/www.flamingspork.com\/blog\/category\/work-et-al\/mysql\/"},"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":4174,"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 &quot;IBM&quot;","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":3263,"url":"https:\/\/www.flamingspork.com\/blog\/2013\/03\/15\/diffstat-of-mysql-5-6-versus-5-5\/","url_meta":{"origin":4174,"position":3},"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 &quot;code&quot;","block_context":{"text":"code","link":"https:\/\/www.flamingspork.com\/blog\/category\/code\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":4003,"url":"https:\/\/www.flamingspork.com\/blog\/2015\/10\/19\/1-million-sql-queries-per-second-ga-mariadb-10-1-on-power8\/","url_meta":{"origin":4174,"position":4},"title":"1 Million SQL Queries per second: GA MariaDB 10.1 on POWER8","author":"Stewart Smith","date":"2015-10-19","format":false,"excerpt":"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 unique in that we're on the higher end of CPUs,\u2026","rel":"","context":"In &quot;IBM&quot;","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":3398,"url":"https:\/\/www.flamingspork.com\/blog\/2013\/08\/14\/who-is-working-on-mariadb-10-0\/","url_meta":{"origin":4174,"position":5},"title":"Who is working on MariaDB 10.0?","author":"Stewart Smith","date":"2013-08-14","format":false,"excerpt":"There was some suggestion after my previous post (Who works on MariaDB and MySQL?) that I look at MariaDB 10.0 - so I have. My working was very simple, in a current MariaDB 10.0 BZR tree (somewhat beyond 10.0.3), I ran the following command: bzr log -n0 -rtag:mariadb-10.0.0..|egrep '(author|committer): '|\u2026","rel":"","context":"In &quot;code&quot;","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,"_links":{"self":[{"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/posts\/4174","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=4174"}],"version-history":[{"count":5,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/posts\/4174\/revisions"}],"predecessor-version":[{"id":4179,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/posts\/4174\/revisions\/4179"}],"wp:attachment":[{"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/media?parent=4174"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/categories?post=4174"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/tags?post=4174"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}