Recently we experienced problems with our MySQL instance. One hour our db was running fine (CPU usage at about 20%), next hour CPU is at 100% and queries are stuck at "creating sort index" phase. After restarting DB everything was normal again.
We suspect that it was MySQL Bug #69721 (https://bugs.mysql.com/bug.php?id=69721). As suggested here (https://community.sugarcrm.com/thread/33079-queries-getting-stuck-on-creating-sort-index-slowing-sugar-down), one option to mitigate this bug is to set optimizer-switch=block_nested_loop=off.
-- We suspect that it was MySQL Bug #69721 (https://bugs.mysql.com/bug.php?id=69721). As suggested here (https://community.sugarcrm.com/thread/33079-queries-getting-stuck-on-creating-sort-index-slowing-sugar-down), one option to mitigate this bug is to set optimizer-switch=block_nested_loop=off.
However, as far as I can see, it is not possible to set this option in Cloud MySQL. Do you know any other way to work around this bug?
Thanks,
Krzysztof Dryś
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/59537d85-a229-49ae-86ba-ff017edee6f2%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
No comments:
Post a Comment