The most recent content from our members.
We had an incident recently where a specific statement executed a very unusually high number of times over a couple of days, and experienced a lot of waits. This has skewed the scale of the chart so badly as to make it useless until those days "age ouf" of the 30 day window. Being able to add those days to a list of…
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…
Assume I have the option set to the default of displaying the top 15 and I am looking at the chart for a day. Also assume that from 4am to 5am none of those top 15 were executing, but 16 - 25 (for the day) were executing. I would expect to see nothing for that hour, even though I could have significant waits. If we…
It looks like you're new here. Sign in or register to get started.