Search Results
https://dev.mysql.com/doc/mysql-em-plugin/en/index.html
Abstract This manual documents Oracle Enterprise Manager for MySQL Database. For help with using MySQL, please visit the MySQL Forums, where you can discuss your issues with other MySQL users. Oracle Enterprise Manager for MySQL Database is ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-changelog-13-2-2-0-0.html
Bugs Fixed Bug #27523773 The values displayed for the metric InnoDB Buffer Cache Sub-Optimal Hit (Rate) were incorrect.
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-changelog-13-2-4-0-0.html
Important As of this release, 13.2.4.0.0, MySQL 8 is supported. It is not possible to monitor MySQL 8 with earlier versions of Oracle Enterprise Manager for MySQL Database. For more information on the variables added and removed in MySQL 8, see ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-config-metric-ndb-category.html
Table 7.22 NDB Configuration Metrics NameDescriptionEngine Condition Pushdown Enabled The engine condition pushdown optimization enables processing for certain comparisons to be 'pushed down' to the storage engine level for more efficient execution.
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-config-metric-slowquerylogging-category.html
Log Slow Admin Statements Enabled Log slow administrative statements such as OPTIMIZE TABLE, ANALYZE TABLE, and ALTER TABLE to the slow query log. Lists the Slow Query Logging configuration metrics and provides a brief description of each. Table ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-config-metric-statementprocessing-category.html
Big Selects Enabled If set to 0, MySQL aborts SELECT statements that are likely to take a very long time to execute (that is, statements for which the optimizer estimates that the number of examined rows exceeds the value of max_join_size). Lists ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-config-metric-threadpool-category.html
A value of 1 increases the concurrency and uses a more aggressive algorithm which at times has been known to perform 5-10% better on optimal thread counts, but has degrading performance as the number of connections increases. Lists the Thread Pool ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-metric-connection-activity-category.html
This includes statements that include a nonzero MAX_EXECUTION_TIME optimizer hint, and statements that include no such hint but execute while the timeout indicated by the max_execution_time system variable is nonzero. Lists the Connection Activity ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-metric-mysqlserver-handleractivity-category.html
This read method is mainly used to optimize ORDER BY ... Lists the Handler Activity metrics and provides a brief description of each. Table 6.8 Handler Activity Metrics NameDescriptionCommit (Delta) The number of internal COMMIT statements. Delete ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-metric-mysqlserver-tableactivity-category.html
Table Cache Not Optimal (Rate) MySQL is multi-threaded, so there may be many clients issuing queries for a given table simultaneously. Lists the Table Activity metrics and provides a brief description of each. Table 6.39 Table Activity Metrics ...