Database Performance Analyzer Overview for MySQL Databases

This video serves as an introduction of the multi-dimensional performance features in SolarWinds Database Performance Analyzer for MySQL® including SQL Statements advise, baselines, alerting and wait based response time analysis.

Database Performance Analyzer is the perfect place to start in order to answer the question 'Why is my application slow?' With an easy to use graphic interface, you can find the cause of a slow query and isolate the root cause, including a correlation with server resources in just 4 clicks. Monitor MySQL, SQL Server, Oracle, DB2 and SAP ASE running on physical servers, along with VMware, and even virtual machines running in the cloud with less than a 1% load. Database Performance Analyzer is both a powerful, easy to use, facilitating collaborative problem solving throughout IT, including DBAs, developers, managers system and network admins.

Connect with SolarWinds:

TRANSCRIPT:
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.