Skip to main content

54 docs tagged with "MySQL"

View All Tags

Agent Installation

The following guides you to the basic installation method for using the WhaTap database monitoring service.

Alert Settings

You can set event conditions and receive notifications in various forms.

Application

It guides you how to collect logs from the database and AWS RDS.

Application of the template

The following guides you to the preset templates that help you quickly build custom dashboards on Flex Board. You can easily perform initial configuration and change the settings. From selecting a template to naming it, adjusting its layout, and saving the settings, you can effectively create monitoring dashboards.

Configuration

Learn about additional options you can set through the whatap.conf file on the database agent server.

Creating the Flex board

The following explains how to create a dashboard from the Flex Board menu and place widgets to create a custom dashboard. You can select the fixed layout or responsive layout, add metric widgets, and use predefined widget templates. You can reposition and resize widgets to create your own dashboard layout.

Dashboard

The WhaTap monitoring dashboard provides functions to understand the overall status of a project at a glance.

Database alert

Alerts are sent through event condition settings per metric in the database.

Database size

It aggregates the sizes of tables for each database and provides trend data in a chart.

Event History

You can see the history of alerts that occurred through Event History.

Event Setting

Alerts are sent through event condition settings per metric in the database.

Flex Board

The following guides you to the custom integrated dashboard. You can create real-time dashboards with the data for applications, servers, databases, containers, and more. It provides pre-configured templates. Through the features such as adding various data widgets, data filtering, and setting time ranges, you can easily summarize desired monitoring targets and check important data.

Flex Board Management

The following explains how to edit and manage dashboards in Flex Board. It includes changing the dashboard name, selecting a project, and adjusting the layout for you to see how to add, move, resize, and delete widgets. It also provides the features to select data source for the widget and to export data to json format for the dashboard.

Instance List

You can see the list of database servers in which the agent has been installed.

Laboratory

The following introduces users about the Lab menu that provides new or experimental features.

Live Tail

It guides you to Live Tail of the log monitoring.

Lock tree

You can analyze the lock trend during the day and check deadlocked queries.

Log

It guides you to the main menus of the log monitoring.

Log Search

It guides you to the Log Search menu of Log Monitoring.

Log Trend

It guides you to the Log Trend menu of Log Monitoring.

Management

Let's learn how to update or remove the agent.

Managing the widgets

The following explains how to add, change, copy, and delete widgets placed on the Flex Board. You can customize the dashboard by adding widgets or adjusting the properties of existing widgets. You can configure a dashboard that suits your monitoring needs through detailed controls such as changing widget data search conditions, setting the time, and setting the data merge options.

Metrics

Let's learn about the metrics menus for Database Monitoring analysis.

Metrics alert

Use the metrics event settings to set specific and complex events.

Metrics widget

The following explains how to add metrics data that represents project performance metrics to the dashboard in the form of widget. Metrics are classified into categories, data can be explored using tags, and are available in two types: table widget and series widget.

Monitoring a Database Instance

In the instance monitoring menu, you can check the information details on key metrics of the database server in real time.

MySQL Monitoring

The WhaTap database monitoring service (DBX) provides the performance monitoring service by collecting data based on queries.

Mysql SQL Statistics

The events_statements_summary_by_digest data in the performance_schema is collected once an hour to provide statistical data. Use it for SQL analysis along with the existing `SQL statistics` menu based on active sessions.

Quick agent configuration

You can easily configure the agent by running the setup.sh file among the DBX agent configuration files.

Report

Let's learn about the documents that report the service usage and failure records for individual projects.

Slow Query

You can analyze slow queries after identifying active sessions at a specific time point.

Troubleshooting

You can check the problems that may occur during database agent installation.

XOS agent configuration

It provides a configuration method for additional monitoring of the database server resources.