We have a three node cluster. I know we have a query that is much slower than others, I just don't know which one.
With other 8000 queries per second it is also difficult to see anything in real time.
So I want to use the log_slow_queries option. BUT, it keeps flipping between on and off every second...
And so on. Everytime this happens the log file on the disk get deleted and recreated too.
In the config files it is turned on. On each of the nodes in the cluster. I never seen anything like this and can only assume it has something to do with the clustercontrol.
Anybody has any ideas? I need to find out what the slow query is but cannot.
Please sign in to leave a comment.