The health report feature can routinely perform health checks on database instances and output the corresponding health reports for the specified time period, which helps you gain in-depth insights into the database instance health, failures, and potential risks and provides professional optimization suggestions for your reference.

Note：

• Currently, health report is supported only for TencentDB for MySQL (excluding Basic single-node instances), TencentDB for Redis, TDSQL-C for MySQL and self-built MySQL databases.
• Health report email push is not supported for self-built databases currently.

Creating Health Report

Log in to the DBbrain console and select Performance Optimization on the left sidebar. On the displayed page, select a database at the top and select the Health Report tab. You can view the health score trends and the problem overview for the specified time period.

• Click Create Health Report to create a task. After the task is completed, you can view or download the health report for the specified time period. For more information on how to send health reports to a recipient via email, please see Sending Health Report Generated by Manual Trigger via Email.

  Note：

  The time period of the health report is the same as that selected on the left.

• Click Regular Generation Settings to configure the time period for automatically generating health reports. For more information on how to send health reports to a recipient via email, please see Sending Health Report Generated by Scheduled Tasks via Email.
  

Score details

In the Score Details section, you can view instance score details for database availability, maintainability, performance, and reliability. For more information, please see Exception Alarms.

Viewing/Downloading Health Report

• In the task list, the type, health level, creation time, starting and ending time, progress, and operations of each health report task are displayed.
  • The Type column displays how the report is generated, including being generated manually, as scheduled, or in an database inspection.
  • The Health Level column displays the health level obtained through diagnoses, including healthy, suboptimal, risky, and critical.
• You can click View Report in the Operation column to view the health report details and download the report as a PDF file.
• You can click Email in the Operation column or click Batch Send after selecting multiple health report records to send the health reports to the mailbox of the specified contact. For more information, please see Sending Historical Health Report via Email.
• You can click More > Deduction Details in the Operation column to view the reason for the deduction of health report task scores.
• You can select More > Delete in the Operation column to delete the health report task.
  

Reading Health Report

A health report displays DBbrain's evaluation of the overall operation conditions of the selected database instance in the specified time period. Items in the report includes the database's existing problems, an analysis of existing problems, and corresponding suggestions, helping you gain a comprehensive understanding of the overall operation status of the selected instance and coordinate relevant personnel to troubleshoot issues.

A report mainly contains the following sections: overview, basic information, health, instance status, exception diagnosis, slow SQL analysis, big table analysis, and performance curve.

Appendix

Reported exception level definitions

Reported health level definitions