MySQL Forums
Forum List  »  Performance

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

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

Written By
How to log slow DMLs
January 10, 2017 04:01PM
January 10, 2017 04:45PM
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.