Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-analyzing-tables.html
As of MySQL 9.3.0, you can use the ANALYZE TABLE statement to analyze tables loaded into MySQL HeatWave and update table statistics. Check if you have the SELECT and INSERT privileges for the table that you want to analyze. Updating Table ...Before ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-setup-objects-table.html
The setup_objects table controls whether the Performance Schema monitors particular objects. This table has a maximum size of 100 rows by default. To change the table size, modify the performance_schema_setup_objects_size system variable at server ...The order in which matching occurs matters because different matching setup_objects rows can have different ENABLED and TIMED ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-transaction-tables.html
These tables store transaction events: events_transactions_current: The current transaction event for each thread. There are also summary tables that aggregate information about transaction events; see Section 29.12.20.5, “Transaction Summary ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-options-variables.html
(It is neither necessary nor desirable to use this option together with --initialize.) --ndb-allow-copying-alter-table=[ON|OFF] Command-Line Format --ndb-allow-copying-alter-table[={OFF|ON}] System Variable ndb_allow_copying_alter_table Scope ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-performance-page-per-table-stats.html
By default, rows are sorted by descending total wait time (tables with most contention first). Table 5.10 Per Table Statistics Dashboard NameDescription Table Name The table name. Delete Latency The total wait time of timed delete I/O events for the ...
https://dev.mysql.com/doc/refman/8.4/en/checksum-table.html
[QUICK | EXTENDED] CHECKSUM TABLE reports a checksum for the contents of a table. If you run CHECKSUM TABLE against a view, the Checksum value is always NULL, and a warning is returned. For a nonexistent table, CHECKSUM TABLE returns NULL and ...You ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-statistics-table.html
The information_schema_stats_expiry system variable defines the period of time before cached table statistics expire. If there are no cached statistics or statistics have expired, statistics are retrieved from storage engines when querying table ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-table-close.html
Each MyISAM index file (.MYI file) has a counter in the header that can be used to check whether a table has been closed properly. If you get the following warning from CHECK TABLE or myisamchk, it means that this counter has gone out of sync: ...
https://dev.mysql.com/doc/refman/8.4/en/symbolic-links-to-tables.html
For files used by tables for other storage engines, you may get strange problems if you try to use symbolic links. For InnoDB tables, use the alternative technique explained in Section 17.6.1.2, “Creating Tables Externally” instead. Do not ...
https://dev.mysql.com/doc/internals/en/optimizer-constants-constant-tables.html
unique_not_null_column INT NOT NULL UNIQUE then this expression FROM Table1 ... These rules mean that a constant table has at most one row value. MySQL will evaluate a constant table in advance, to find out what that value is. Here's an example: ...