When enable slave slow log, I set the long_query_time = 0 but in the slow log file, I can’t get the actually query statement, all I find are things like below:
User@Host: [SQL_SLAVE] @ Id: 26
Schema: mundotrack Last_errno: 0 Killed: 0
Query_time: 0.000009 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 Rows_affected: 0
Any configuration missing?
Are you using it? if not then can you try with that option? thanks.
James, this will work only if you are using STATEMENT based replication. For ROW, there are no actual queries, hence nothing will get logged from the replication stream.
It supposed to work this way or is a bug because with row based replication we can still get the query from slave binary log file if enable log_slave_update
Can you provide which exact MySQL/PS version you are using on Master/Slave? Need to test it before come on any conclusion. I have also found one bug related to this but don’t know if it’s same.