I have a situation with MariaDB 10.0.0 where an
INSERT INTO ... SELECT query that takes 3 seconds to run ends up
stuck in the closing tables state for 15+ minutes while burning
100% of CPU.

I have seen bug reports dating back 5 years that sound very similar
but none of them are listed as resolved.

Is there a way to debug/troubleshoot this further? The problem is
quite intermittent. My data is in a state of constant flux so
finding an exact reproducible test case based on data lone isn't
likely to be viable. Is there a reasonable way to capture more detailed
debug information than what is available from "show full processlist"?

Gordan

_______________________________________________
Mailing list: https://launchpad.net/~maria-developers
Post to     : maria-developers@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-developers
More help   : https://help.launchpad.net/ListHelp

Reply via email to