I find that "explain query" doesn't work, because truncates the query, which leads to an error message. Here is a screenshot:
DELETE FROM file_server WHERE serverid = 44 AND timestamp_scanner <= (SELECT last_scan FROM server WHERE id = 44 limit 1)
The query could not be explained: DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DELETE FROM file_server WHERE serverid = 44 AND timestamp_scanner <= (SELECT las' at line 2 at /usr/bin/innotop line 4826, <FIN> line 1.
Press e to explain, f for full query, o for optimized query
I am using innotop 1.4.3, perl-DBD-mysql-3.0002, perl-5.8.8, MySQL-5.0.26.
Thanks for innotop. It is great.