News for hackers. Stuff that matters.
Re:Sysbench for MySQL 5.0, 5.1, 5.5, 5.6, 5.7 and 8 by wcarron on Friday June 16, 2017 @07:39PM (#14573358)
Hmmm, consistently deteriorating performance over time is rather suspicious. A move by Oracle to kill off competition for their implementations? I can only speculate, though.

It seems odd, though. I guess it's all PostgreSQL all the time for me, from now on.

Re:Sysbench for MySQL 5.0, 5.1, 5.5, 5.6, 5.7 and 8 by emfree on Friday June 16, 2017 @08:32PM (#14573586)
I think the author is specifically evaluating low-concurrency in-memory workloads here. The previous post describes why regressions for those workloads might be "not a surprise": https://smalldatum.blogspot.com/2017/05/the-history-of-low-c...
Re:Sysbench for MySQL 5.0, 5.1, 5.5, 5.6, 5.7 and 8 by lathiat on Friday June 16, 2017 @08:44PM (#14573642)
This context is key here. High concurrency workloads have not suffered this badly and in most cases have increased performance and that's specifically part of why. For many (or possibly even a good majority) of users, that's more important than low-concurrency.

Those blindly suggesting MariaDB or Percona is all well and good but naive. Percona generally follows MySQL upstream but makes their own little tweaks which could be (but are not always) fixed in MySQL upstream based on differing specific priorities.

MariaDB is highly diverged at this point and likely has a whole different set of problems and benefits.

Author of these posts is well known for a long (10+ years) history of working with MySQL at a deep level rivalling that of many of the developers, generally writes good stuff (though is not infallible :)

Re:Sysbench for MySQL 5.0, 5.1, 5.5, 5.6, 5.7 and 8 by kijin on Friday June 16, 2017 @08:43PM (#14573637)
Yes, it seems that Oracle does care about performance in high-concurrency applications: https://www.mysql.com/why-mysql/benchmarks/

Even their own benchmarks show MySQL 5.7 dipping below previous versions at the low end of the concurrency scale.

Re:Sysbench for MySQL 5.0, 5.1, 5.5, 5.6, 5.7 and 8 by mdcallag on Saturday June 17, 2017 @11:07AM (#14576198)
Yes, context is everything when looking at benchmark results. I am showing the worst-case for this performance regression. Thanks for mentioning that. Note, that is my blog.

I also showed the impact for IO-bound workloads, and even there the regression is larger than I want. But not as bad as the in-memory workloads.

Re:Sysbench for MySQL 5.0, 5.1, 5.5, 5.6, 5.7 and 8 by lawpoop on Friday June 16, 2017 @08:12PM (#14573505)
MariaDB is a thing.
Re:Sysbench for MySQL 5.0, 5.1, 5.5, 5.6, 5.7 and 8 by wcarron on Wednesday June 21, 2017 @06:46PM (#14608631)
Yeah, but why would I use that over PostgreSQL? I already know postgreSQL and it's also THE gold standard for SQL implementations. AFAIAC PostgreSQL is the obvious choice.
Re:Sysbench for MySQL 5.0, 5.1, 5.5, 5.6, 5.7 and 8 by lawpoop on Wednesday June 21, 2017 @11:39PM (#14609968)
You would use it over PostgreSQL because it's a drop-in replacement for MySQL. PostgreSQL is not.

If you're not using MySQL in the first place, why would you care?

Re:Sysbench for MySQL 5.0, 5.1, 5.5, 5.6, 5.7 and 8 by wcarron on Thursday June 22, 2017 @04:07PM (#14614917)
Because sometimes I DO use MySQL because a client requested it. At this point, I'll probably just explain to clients why pg is a much better alternative.
Re:Sysbench for MySQL 5.0, 5.1, 5.5, 5.6, 5.7 and 8 by lawpoop on Saturday June 24, 2017 @11:44AM (#14625952)
From a fresh build, I agree with you.

However, for MySQL in an existing application, the migration costs might make it not worth it. There can be a number of pernicious gotchas that aren't obvious at first. MariaDB is more or less set-and-forget.