5. Are there other ongoing operational activities?
Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
On this page
The next step in troubleshooting your cluster is checking other ongoing operational activities that may be affecting your cluster performance.
-
Navigate to the Active Queries page in Studio from the master aggregator, or query MV_
PROCESSLIST SELECT * FROM information_schema.mv_processlist; -
Search (ctrl-F) in the Active Queries page, or look in the results of your query to
MV_
for any of the following:PROCESSLIST ALTER, CREATE, DROP, ADD|REMOVE LEAF/AGGREGATOR, BACKUP/RESTORE, REBALANCE, RESTORE REDUNDANCY
. -
For either the Active Queries page, or
MV_
, check thePROCESSLIST status
column to see if any of these activities are long running, or waiting on other operations.-
If an operation is
waiting on metadata lock
, the query is likely waiting on a cluster wide operation such as a backup.
-
Next Steps
-
If no other ongoing operational activities were identified: continue to Step 6.
Last modified: July 17, 2024