Hacker News Reader

Comment by 0xmohit | Hacker News Reader

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/

View on HN

What the heck. You have that domain JUST for MySQL 5.7?! The potential!

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.)

I would expand it out to everything, this would actually be a helpful service. I hate digging through feature notes on everything.

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!

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...

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.)

more reasons to hate zabbix? as if I needed them ;)

This page gives a good visual:

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

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

Thanks for sharing that link!

Reply on news.ycombinator.com