> 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 _______________________________________________ Toolserver-l mailing list ([email protected]) https://lists.wikimedia.org/mailman/listinfo/toolserver-l Posting guidelines for this list: https://wiki.toolserver.org/view/Mailing_list_etiquette
