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
- All existing applications work without any changes
- Extreme performance:
+ 400x faster than MySQL, scales to thousands of cores …