3 ms·
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/co
by 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 agoIt'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 agomore reasons to hate zabbix? as if I needed them ;)