I'm not a developer but a system administrator,
I found this query
SELECT * FROM bogus_table LIMIT 0\G in the MySQL-slow-query.log in the production server.
I asked the developer about this query and he has no idea where this query coming from.
Thank to this post i assume that
SELECT * FROM bogus_table LIMIT 0\G is to clear the kill flag which mean this query will be trigger afterward if the previous query return an error.- correct me if i'm wrong.
So here my question: How do i find/trace what query that running is triggering this query to be executed afterward (Based on my above assumption)
SELECT * FROM bogus_table LIMIT 0\G ?