Hello
We have some issues with our MySQL server
There is process that stuck on following: [INDENT] Id User Host db Command Time State Info Rows_sent Rows_examined [/INDENT]
[INDENT]5065231 cyang1 %:28510 servicing Killed 42631 closing tables delete from servicing.tmp_overlapping_scan_agent_hourly 6 12113955[/INDENT]
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