News for hackers. Stuff that matters.
Re:PHP 7 at Tumblr by 0xmohit on Thursday November 10, 2016 @12:46PM (#12922515)
Complete list of new features in MySQL 5.7 [0] (in bullet form) would show scores of performance improvements. The performance improvements from 5.5 to 5.6 were significant and 5.7 is much much better.

[0] http://www.thecompletelistoffeatures.com/

Re:PHP 7 at Tumblr by overcast on Thursday November 10, 2016 @02:18PM (#12923327)
What the heck. You have that domain JUST for MySQL 5.7?! The potential!
Re:PHP 7 at Tumblr by morgo on Thursday November 10, 2016 @03:13PM (#12923848)
In future I intend to expand it for MySQL 8.0.

(I am the Product Manager for the MySQL Server, but yes - I personally own the domain.)

Re:PHP 7 at Tumblr by overcast on Thursday November 10, 2016 @03:38PM (#12924091)
I would expand it out to everything, this would actually be a helpful service. I hate digging through feature notes on everything.
Re:PHP 7 at Tumblr by i336_ on Friday November 11, 2016 @07:48AM (#12930114)
Idea: post the domain as a story to HN and say you're just managing MySQL but that you'll consider all reasonable pull requests. See what comes in!
Re:PHP 7 at Tumblr by dijit on Thursday November 10, 2016 @01:05PM (#12922670)
On the flip side there were severe performance degradations for certain types of queries. Notably Zabbix[0] was affected.

[0]: https://m.reddit.com/r/zabbix/comments/3txgov/poor_performan...

Re:PHP 7 at Tumblr by morgo on Thursday November 10, 2016 @01:59PM (#12923145)
It's important to distinguish between cases where it is slower, and cases where query plans change.

MySQL 5.7 changed the cost-model significantly, so while it will be better on most queries, there are cases where two-wrongs-made-a-right; and edge case queries may be slower. To mitigate this (as it was somewhat expected), MySQL 5.7 also introduced new query hints and server-side query rewrite.

(In the case of the link you provided, OP responded later saying 5.7.10 improved performance again.)

Re:PHP 7 at Tumblr by liveoneggs on Thursday November 10, 2016 @02:24PM (#12923377)
more reasons to hate zabbix? as if I needed them ;)
Re:PHP 7 at Tumblr by jwdunne on Friday November 11, 2016 @02:12PM (#12933403)
This page gives a good visual:

https://www.mysql.com/why-mysql/benchmarks/

Re:PHP 7 at Tumblr by gonzo41 on Thursday November 10, 2016 @06:51PM (#12925877)
The additions to the geospatial feature are a plus. from 5.6 to 5.7 there is a huge jump in potential. Hopefully more coming
Re:PHP 7 at Tumblr by orware on Thursday November 10, 2016 @12:51PM (#12922557)
Thanks for sharing that link!