we have installed mysql cluster using the configurator (2 nodes with sql and mgt services and other two nodes with ndb sevice) and we have also installed cmon to monitor it.
After some months of production usage now even simple query are very slow and we don't now what's is going wrong.
We now that mysql cluster performs well on simple query and that it's not optimized for complex query (eg bi) but is it normal that we have a time of 8 seconds for a simple query like this "select DISTINCT cp.campaignID from CAMPAIGN_PLAY cp" when the tables contains 60000 rows ?
According to CMON we are not using disk ad every things is in RAM but query with distinct or group by are very slow and when performed sql node is 100 CPU.
Please sign in to leave a comment.