MySQL Forums :: Performance :: How to log slow DMLs


Advanced Search

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 205 Susan Lam 01/10/2017 04:01PM
Re: How to log slow DMLs 127 Peter Brawley 01/10/2017 04:45PM
Re: How to log slow DMLs 120 Susan Lam 01/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.