Often, the Info column in the basic view is too short to see the full query. To see the complete query text without truncation, use:
: Use KILL QUERY first, then wait for thread to disappear. mysql kill process
| Limitation | Explanation | |------------|-------------| | Cannot kill KILL itself | Executing KILL <your_own_id> is ignored. | | Some system threads cannot be killed | event_scheduler , innodb_ddl_recovery threads. | | Stored procedures may ignore kill | If no check between procedure statements. | | Windows (non-signal safe) | Slightly higher latency to notice kill. | Often, the Info column in the basic view