Not the answer you need?
Register and ask your own question!

Process stack on closing tables under Kielled command

hvardan71hvardan71 EntrantCurrent User Role Novice
Hello
We have some issues with our MySQL server
There is process that stuck on following:
Id User Host db Command Time State Info Rows_sent Rows_examined
5065231 cyang1 %:28510 servicing Killed 42631 closing tables delete from servicing.tmp_overlapping_scan_agent_hourly 6 12113955

The show processlist show that there is 12113955 row examined - but this table never had this amount of rows
Maximum it is 1 row per execution - it is temporary table to pass information between two different processes.

Any suggestion?

Thank you
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.