There are more than 10 concurrent users running queries on the DB system.

To determine whether a query is offloaded to the HeatWave cluster for execution,check the value of therapid_query_offload_countglobal status variable(Answer B).

rapid_query_offload_count: This variable indicates the number of queries that have been offloaded to the HeatWave cluster. By checking its value before and after running the query, you can determine if the query was offloaded.

Steps:

Connect to the MySQL DB system.

RunSHOW GLOBAL STATUS LIKE 'rapid_query_offload_count';before and after executing the query to see if the count increases, indicating offloading.

References:

MySQL HeatWave Documentation

Monitoring HeatWave Status Variables