The most recent content from our members.
Hi, We've started using DPA on one of our clients sites and it's helped us a lot by highlighting some issues with some problem queries, we've now hit a bit of a roadblock because the top SQL Statements is now being listed as "/* Commit */" and i have no idea what that means or where it's coming from. When this happens the…
DESCRIPTION This alert will review the Disk Write Time - Commits metric collected by Ignite and provide a warning when the metric goes above 15 ms and a critical alert when it goes above 20 ms. The metric is averaged over the timeframe for the alert, i.e. 5 minutes for this example. This raw Commit metric is calculated by…
Every day, DPA shows that the Top SQL in my MySQL (Community 5.6.27, Windows Server 2012) is a solo "COMMIT" statement. This is not very helpful in drilling down to find bottlenecks or poor-performing SQL code. Is this a factor of how MySQL is parsed, a side-effect of how the code is constructed in our environment, or just…
It looks like you're new here. Sign in or register to get started.