Je te donne rendez-vous le 11 avril 2022, pour l’Oracle Summit France à Station F, c’est dans le 13ème à Paris.
je te parlerai des dernières innovations MySQL, plus spécifiquement de MySQL HeatWave qui est le seul service MySQL avec un accélérateur de requêtes en mémoire et qui en plus propose des capacité des Machine Learning intégrées.
If you have (too) long running select queries it is probably because of lack of relevant indexes, problematic schema that lead to poor queries or inadequate hardware.
That said, sometime even if you doing it right, the query execution time could be too long regarding of what the application or your users expect. It is often true for reporting, real time analytics or BI queries.
At Oracle we have developed Heatwave, that allow you to easily run high performance analytics against your MySQL database.
To be more precise, Heatwave is a massively-scalable integrated analytics engine for MySQL Database Service (MDS), the MySQL DBaaS in Oracle Cloud Infrastructure (OCI).
Some key points of Heatwave:
– Single MySQL database for OLTP & analytics applications
– All existing applications work without any changes
– Extreme performance:
+ 400x faster than MySQL, scales to thousands of cores
+ 1100x faster than Amazon
Aurora
+ 2.7x faster than Amazon Redshift