4 ms·

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 wer

by 0xmohit 10y ago

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/ http://www.thecompletelistoffeatures.com/

orware 10y ago
Thanks for sharing that link!
dijit 10y ago
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_performances_with_mysql_57/ https://m.reddit.com/r/zabbix/comments/3txgov/poor_performan...
- morgo 10y ago
  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.)
- liveoneggs 10y ago
  more reasons to hate zabbix? as if I needed them ;)
overcast 10y ago
What the heck. You have that domain JUST for MySQL 5.7?! The potential!
- morgo 10y ago
  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.)
  - overcast 10y ago
    I would expand it out to everything, this would actually be a helpful service. I hate digging through feature notes on everything.
  - i336_ 10y ago
    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!
gonzo41 10y ago
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
jwdunne 10y ago
This page gives a good visual: https://www.mysql.com/why-mysql/benchmarks/ https://www.mysql.com/why-mysql/benchmarks/

by 0xmohit 10y ago

orware 10y ago

Thanks for sharing that link!

dijit 10y ago

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_performances_with_mysql_57/ https://m.reddit.com/r/zabbix/comments/3txgov/poor_performan...

morgo 10y ago
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.)
liveoneggs 10y ago
more reasons to hate zabbix? as if I needed them ;)

overcast 10y ago

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

morgo 10y ago
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.)
- overcast 10y ago
  I would expand it out to everything, this would actually be a helpful service. I hate digging through feature notes on everything.
- i336_ 10y ago
  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!

gonzo41 10y ago

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

jwdunne 10y ago

This page gives a good visual: https://www.mysql.com/why-mysql/benchmarks/ https://www.mysql.com/why-mysql/benchmarks/