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