Database Performance Analyzer Overview for MySQL® Databases

SolarWinds^® Database Performance Analyzer for MySQL^® uses response time analysis to focus on the time between a query request and a query response. This time can be broken into discrete steps called waits. DPA monitors these waits and identifies those that have the biggest impact on database and application performance.

Let's have a look at the performance of our MySQL database. The bars in this graph represent the total time application users wait over the course of a month. Information is collected every second and automatically condensed over time. Let’s drill into a specific day.

Each query is represented by a unique color. Hovering over the bar provides a detailed view of the query including query statement and total wait time.

The hour view pinpoints the query, total response time, and the specific wait event or type giving you actionable information to resolve issues fast. You'll notice a big change in performance happened between 7 and 8 am. Let's see if we can determine what happened.

This particular SQL is causing the most wait time so let's click to investigate further. On this screen, you can see statistics about this SQL statement and run a Live Explain plan.

Click on 'View Historical Reports' to learn how this SQL has performed in the past.

Click on the 'Run Query Analysis' link to get actionable advice. "Blocking" seems to be causing most of the wait time.

These tabs provide additional performance information about the selected SQL statement such as top waits, programs, files and blockers. Let's click on 'blockers' since it was the top advice given in the analysis. Here we can see in detail what was blocking this query.

Database Performance Analyzer can also help you to keep track of how your physical infrastructure is performing. Click on the 'Resources' link to get a complete system level overview such as storage, CPU, host, etc.

Select the 'Show Baselines' tab and change the view to 'last 24 hours' to identify if any resource is performing outside the norm.

DPA can easily be adapted to meet your specific requirements by using custom reports and alerts.

Unlike other monitoring techniques that force you to choose between detailed monitoring and load on the monitored servers, DPA's agentless architecture monitors 24/7 with less than 1% load.

Learn how Database Performance Analyzer for MySQL can help you become a better DBA. Download a free fully functional trial today at SolarWinds.com.