You are a DBA, enjoying a good read about the MySQL 8.0.1 development milestone release which contains CTEs. And, window functions are coming in 8.0.2. Perhaps, you think, the analytics team could make good use of window functions to perform rankings on the sales of products compared to the average sales for all the products.
Dreaming about the possibility of trying CTEs in 8.0.1, you get a phone from a user complaining that her ‘SELECT’ statement has been running for a long time.
Fortunately, you have the MySQL Enterprise Monitor (MEM) which is part of the MySQL Cloud Service (MySQLCS). You have recently set up your MySQL database in MySQLCS where you have installed MEM.
You login to your identity domain in MySQLCS and select you service and click the pull-down menu choice ‘Enterprise Monitor URL’:
After logging in, you notice on the MEM dashboard that there is a spike in database activity …[Read more]