We're updating the issue view to help you get more done.Learn more

SLOW QUERY LOG - add affected rows (UPDATE / DELETE) in slow query log

hi guys i was running a update and it was logged in slow query

# Time: 130422 10:34:20
# User@Host: rspadim[rspadim] @  []
# Thread_id: 10019  Schema: 19_org  QC_hit: No
# Query_time: 17.094863  Lock_time: 0.000066  Rows_sent: 0  Rows_examined: 1301065
SET timestamp=1366637660;
UPDATE `nf_itens` SET `valor_produto_grandeza`='pl' WHERE  `id_item`=1;

the point is... how many rows it changed? could it be logged in slow query log? since my write speed is slow, since it's a raid1 (faster read than write)




Nirbhay Choubey


Roberto Spadim