Lists the Binary Logs Summary metrics and provides a brief description of each.
Table 4.2 Binary Logs Summary Metrics
Name | Description |
---|---|
Count (Total) | Number of binlog files. |
Size (Total) | Total space used by the binlog file. |
Binary Log File Count | The binary log captures DML, DDL, and security changes that occur and stores these changes in a binary format. The binary log enables replication as well as point-in-time recovery, preventing data loss during a disaster recovery situation. It also enables you to review all alterations made to your database. However, binary logs consume disk space and file system resources, and can be removed from a production server after they are no longer needed by the slaves connecting to this master server, and after they have been backed up. |
Binary Log Space | The binary log captures DML, DDL, and security changes that occur and stores these changes in a binary format. The binary log enables replication as well as point-in-time recovery, preventing data loss during a disaster recovery situation. It also enables you to review all alterations made to your database. However, binary logs consume disk space and can be removed from a production server after they are no longer needed by the slaves connecting to this master server, and after they have been backed up. |