
ADMINISTRATOR SECTION CHAPTER 2: CONFIGURING THE ER SERVER
View Diagnostic Reports
1.Choose a report from the
2.Click the View button to view the selected diagnostic report in a
•Table Status - This report contains a list of Client table names, and columns of statistics on each table, such as type, size, number of rows, and time created and updated.
•Process List - This report shows a list of current SQL queries in the database, in an abbreviated format.
•Full Process List - This report shows a list of current SQL queries in the database, in the full format that includes all columns of data.
•Tables - This report contains a list of the names of tables currently in the database.
•Daily Summary - This report shows the date range of summary tables currently in the database.
3.Click the “X” in the upper right corner of the
View Database Status Logs
1.Choose a database status log from the
2.Click the View button to view the selected database status log in a
•db Active - This log indicates when client tables were last updated with hits_objects and hits_pages.
•db Backup - This log provides information about the MySQL backup/restore operation.
•db Control - This log shows a list of actions performed by the ER process when processing log files.
8E6 TECHNOLOGIES, ENTERPRISE REPORTER ADMINISTRATOR USER GUIDE | 87 |