Search Results
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-config-metric-ndb-category.html
Table 7.23 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.44 Table Activity Metrics ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-metric-replicationsource-activity-category.html
For optimal performance, transactions that move through the binary log should be contained within the binary log cache. Lists the Replication Source Activity metrics and provides a brief description of each. Table 6.26 Replication Source Activity ...
https://dev.mysql.com/doc/mysql-em-plugin/en/prereqs-myoem-reference.html
This section describes the prerequisites for a successful Oracle Enterprise Manager for MySQL Database installation. Ensure the agent can successfully communicate with your Oracle Management Service and can upload data. Note The plugin is installed ...
https://dev.mysql.com/doc/x-devapi-userguide/en/collection-indexing.html
If index type is set to SPATIAL then the created index is the same as it would be created by issuing CREATE INDEX with the SPATIAL keyword, see SPATIAL Index Optimization and Creating Spatial Indexes. To make large collections of documents more ...