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

1 2 3 4 5 6 # Time: 130422 10:34:20 # User@Host: rspadim[rspadim] @ [179.233.54.101] # 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)

tnkx!

Status

Assignee

Nirbhay Choubey

Reporter

Roberto Spadim

Time estimate

1h

Components

Fix versions

Priority

Major