Oracle Enterprise Manager for MySQL Database
Lists the Instance Activity metrics and provides a brief description of each.
Table 6.20 Instance Activity Metrics
| Name | Description |
|---|---|
| Acl Cache Items Count | The number of cached privilege objects. Each object is the privilege combination of a user and its active roles. |
| Flush Commands (Delta) | The number of executed FLUSH statements. |
| Opened Files (Delta) | The number of files that have been opened with my_open() (a mysys library function). |
| Open Files | The number of files that are open. This count includes regular files opened by the server. It does not include other types of files such as sockets or pipes. |
| Open Streams (Delta) | The number of streams that are open (used mainly for logging). |
| Prepared Stmt Count | The current number of prepared statements. (The maximum number of statements is given by the max_prepared_stmt_count system variable.). |
| Queries (Delta) | The number of statements executed by the server. This variable includes statements executed within stored programs, unlike the Questions variable. |
| Queries (Per Second) | The average number of statements executed by the server per second. |
| Questions (Delta) | The number of statements executed by the server. This includes only statements sent to the server by clients and not statements executed within stored programs, unlike the Queries variable. |
| Uptime | The number of seconds that the server has been up. |
| Uptime Since Flush Status | The number of seconds since the most recent FLUSH STATUS statement. |
| MySQL Server Has Been Restarted | To perform useful work, a database server must be up-and-running continuously. It is normal for a production server to run continuously for weeks, months, or longer. If a server has been restarted recently, it may be the result of planned maintenance, but it may also be due to an unplanned event that should be investigated. |