Re: Mysql slow query logging ( commit takes time )
as far as i know, it puts table name and query. probably it is 'magic' update of field by mysql, but table name must be there.
i think, your script updated many rows in the loop by cursor or something.
try to update as a bulk, if possible. databases are very bad on updating
Subject
Written By
Posted
November 06, 2012 10:40PM
November 07, 2012 10:51AM
Re: Mysql slow query logging ( commit takes time )
November 27, 2012 04:25AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.