How did you send the query to the server? There might
be a comment stripper
I do that cat'ing a file on stdin of mysql command line client. SELECT
queries being killed always contain my SLOW_OK in query killer's
message body, and this INSERT does not.
One more interesting message from query killer I've received today, it's body:
---------------------------------------------------
Hello mashiah,
a MySQL-query of yours was killed because you didn't mark it as
SLOW_OK and it have run for 606 seconds which was longer than allowed.
You can find the query below. Please have also a look at [1] to find
information how you can avoid killings of your queries. Maybe you can
optimze the query too?
The replication lag at kill-time was 74s.
Sincerly,
Query-Killer.
This eMail was sent automaticaly, please don't reply.
DROP TABLE part_pl
---------------------------------------------------
part_pl is a memory table, which by default cannot be too huge due to
limited memory allowed for memory tables.
mashiah