Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-cpustat-1sec.html
The cpustat-1sec table provides raw, per-thread CPU data obtained each second for each thread running in the NDB kernel. Like cpustat_50ms and cpustat_20sec, this table shows 20 measurement sets per thread, each referencing a period of the named ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-cpustat-20sec.html
The cpustat_20sec table provides raw, per-thread CPU data obtained each 20 seconds, for each thread running in the NDB kernel. Like cpustat_50ms and cpustat_1sec, this table shows 20 measurement sets per thread, each referencing a period of the ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-persistent-stats.html
In this case innodb_stats_persistent_sample_pages should be decreased until ANALYZE TABLE execution time is acceptable. If a balance cannot be achieved between accurate statistics and ANALYZE TABLE execution time, consider decreasing the number of ... The persistent optimizer statistics feature improves plan stability by storing statistics to disk and making them persistent across server restarts so that the optimizer is more likely to make consistent choices each time for a given ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-buffer-pool-flushing.html
This setting is recommended for non-rotational storage (SSD) devices where seek time is not a significant factor. When table data is stored on a traditional HDD storage device, flushing neighbor pages in one operation reduces I/O overhead (primarily ... InnoDB performs certain tasks in the background, including flushing of dirty pages from the buffer ...
MySQL Enterprise Monitor 8.0 Release Notes :: Changes in MySQL Enterprise Monitor 8.0.0 (2018-04-19)
https://dev.mysql.com/doc/relnotes/mysql-monitor/8.0/en/news-8-0-0.html
The emailed links were incorrect for events generated by the SQL Statement Generates Warnings or Errors and Average Statement Execution Time Advisor advisors. (Bug #27731494) The Time Span and Graph From: labels did not display multibyte characters ... Important It is not possible to upgrade to MySQL Enterprise Monitor 8.0 from versions preceding MySQL Enterprise Monitor ...
https://dev.mysql.com/doc/internals/en/transformation-scalar-in.html
Item_ref is used to point to <left_expression cache>, because at the time of transformation we know only the address of the variable where the cache pointer will be stored. To rewrite a scalar IN subquery, the ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-cpustat-50ms.html
The cpustat_50ms table provides raw, per-thread CPU data obtained each 50 milliseconds for each thread running in the NDB kernel. Like cpustat_1sec and cpustat_20sec, this table shows 20 measurement sets per thread, each referencing a period of the ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-cpustat.html
The cpustat table provides per-thread CPU statistics gathered each second, for each thread running in the NDB kernel.
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-events-stages-current-table.html
For discussion of picoseconds as the unit for event times and factors that affect time values, see Section 29.4.1, “Performance Schema Event Timing”. For example, the events_stages_history and events_stages_history_long tables are collections of ...The table stores one row per thread showing the current status of the thread's most recent monitored stage event, so there is no system variable for configuring the table ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-events-transactions-current-table.html
For discussion of picoseconds as the unit for event times and factors that affect time values, see Section 29.4.1, “Performance Schema Event Timing”. For example, the events_transactions_history and events_transactions_history_long tables are ...