Help Center/
Application Performance Management/
User Guide (2.0) (Kuala Lumpur Region)/
User Guide/
Application Metric Monitoring/
Application Monitoring Configuration/
Configuring the MySQL Monitoring Item
Updated on 2024-07-04 GMT+08:00
Configuring the MySQL Monitoring Item
On the Modify MySQL Monitoring Configuration page, set the following parameters:
- Collection Interval: The default value is 60s and cannot be changed.
- Collect Original SQL: This function is disabled by default. In that case, only SQL statements without values are collected, for example, select name from user where id=?. When this function is enabled, SQL statements with values are collected, for example, select name from user where id=1.
- shardTableName: specified when you need to aggregate multiple tables into one table. For example, there are two tables: UserTable_1 and UserTable_2. By default, two SQL statements (select name from UserTable_1 and select name from UserTable_2) are displayed on the SQL monitoring page. If you set shardTableName to UserTable, tables starting with UserTable are aggregated into the same table. Only one SQL statement (select name from UserTable) is displayed on the SQL monitoring page.
Parent topic: Application Monitoring Configuration
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
The system is busy. Please try again later.
For any further questions, feel free to contact us through the chatbot.
Chatbot
