Search Results
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-metric-innodb-rowactivity-category.html
Table 6.15 InnoDB Row Activity Metrics NameDescriptionRow Queries Inside The number of queries executing inside InnoDB. Row Queries Queue The number of queries in the queue, waiting to enter InnoDB. Lists the InnoDB Row Activity metrics and ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-metric-mysqlserver-dmlstatementactivity-category.html
Lists the DML Statement Activity metrics and provides a brief description of each. Table 6.6 DML Statement Activity Metrics NameDescriptionCall Procedure (Delta) The total number of CALL statements executed. Dealloc SQL (Delta) The total number of ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-metric-mysqlserver-handleractivity-category.html
If this value is high, it is a good indication that your tables are properly indexed for your queries. This value is high if you are doing a lot of queries that require sorting of the result. Savepoint (Delta) The number of requests for a storage ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-metric-sysschema-tablemetadatalockwaiters-category.html
Lists the Sys Schema Table Metadata Lock Waits metrics and provides a brief description of each. Table 6.41 Sys Schema Table Metadata Lock Waits Metrics NameDescriptionBlocking Account The account of the session that is blocking the current ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-agent-rights.html
MySQL Enterprise Monitor Agent requires a user configured within each MySQL instance that is being monitored with suitable privileges to collect information about the server, including variable names, replication, and storage engine status ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-auto-indexing-execution.html
Autopilot Indexing provides recommendations for schemas with a representative workload that has at least five queries in the SQL statement digest history in the Performance Schema. Rather than drop the suggested indexes, make them invisible first, ...Autopilot Indexing only evaluates SQL statements in the SQL statement digest history that access existing ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-report-table.html
From MySQL version 8.0.32 onwards, the heatwave_advisor_report table, is deprecated and replaced with the heatwave_autopilot_report table in the sys schema. When MySQL runs Advisor, it sends detailed output to the heatwave_advisor_report table in ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-auto-unload.html
Queries on these tables will | | no longer be offloaded to HeatWave. You can use MySQL HeatWave Auto Unload to unload data automatically. This topic contains the following sections: Before You Begin Overview for Unloading Data Automatically Unload ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-autopilot-index-advisor-report-table.html
When Autopilot Indexing runs, it sends detailed output to the autopilot_index_advisor_report table in the sys schema. The autopilot_index_advisor_report table is a temporary table that contains data from the last execution of Autopilot Indexing.
https://dev.mysql.com/doc/heatwave/en/mys-hw-autopilot-report-table.html
It contains data from the last execution of Advisor or Auto Parallel Load. Data is only available for the current session and is lost when the session terminates or when the server shuts down. When Advisor or Auto Parallel Load run, they send ...