MySQL Forums
Forum List  »  Performance

How to log slow DMLs
Posted by: Susan Lam
Date: January 10, 2017 04:01PM

Hi,
I'm currently running MySQL 5.1. My application is periodically slow when running hundreds of DML statements but we could not pinpoint which DML statements were contributing to the slowness.

Is there a way to log slow DMLs? There is a log-slow-queries parameter but that only provides slow running queries. Is that a similar parameter for logging DMLs or how can I monitor the database in real time? We do not have MySQL Enterprise Monitor.

thanks in advance.

Options: ReplyQuote


Subject
Views
Written By
Posted
How to log slow DMLs
265
January 10, 2017 04:01PM
155
January 10, 2017 04:45PM
152
January 10, 2017 06:54PM


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.