Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-persistent-stats.html
Optimizer statistics are persisted to disk when innodb_stats_persistent=ON or when individual tables are defined with STATS_PERSISTENT=1. Formerly, optimizer statistics were cleared when restarting the server and after some other types of ... The ...
https://dev.mysql.com/doc/refman/8.4/en/merge-storage-engine.html
The MERGE storage engine, also known as the MRG_MyISAM engine, is a collection of identical MyISAM tables that can be used as one. “Identical” means that all tables have identical column data types and index information. You cannot merge MyISAM ...However, if the user's privileges on t are subsequently revoked, the user can continue to access t by doing so ...
https://dev.mysql.com/doc/refman/8.4/en/sys-sys-config.html
This table contains sys schema configuration options, one row per option. Configuration changes made by updating this table persist across client sessions and server restarts. The sys_config table has these columns: variable The configuration ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-tablestats-table.html
The INNODB_TABLESTATS table provides a view of low-level status information about InnoDB tables. This data is used by the MySQL optimizer to calculate which index to use when querying an InnoDB table. InnoDB tables are represented in this view if ...This information is derived from in-memory data structures rather than data stored on ...
https://dev.mysql.com/doc/refman/8.4/en/sys-schema-table-statistics-with-buffer.html
These views summarize table statistics, including InnoDB buffer pool statistics. By default, rows are sorted by descending total wait time (tables with most contention first). The schema_table_statistics_with_buffer and ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-partial-options.html
For an overview of partial backup and restore, as well as usage examples on the following options, see Section 4.3.5, “Making a Partial Backup” and Section 5.1.4, “Table-Level Recovery (TLR)”. --include-tables=REGEXP Command-Line Format ...
https://dev.mysql.com/doc/ndbapi/en/ndb-error-codes-single.html
Backup failed to insert table list (check configuration) 1347 MySQL error. Backup failed to allocate table memory (check configuration) 1348 MySQL error. Table fragment fixed data reference has reached maximum possible value (specify MAXROWS or ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-management-range-list.html
For information about working with tables that are partitioned by hash or key, see Section 26.3.2, “Management of HASH and KEY Partitions”. Dropping a partition from a table that is partitioned by either RANGE or by LIST can be accomplished ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-compression-tuning-monitoring.html
This section builds on the performance tuning advice from Section 17.9.1.3, “Tuning Compression for InnoDB Tables”, and shows how to find problems that might not turn up during initial testing. To dig deeper into performance considerations for ... Overall application performance, CPU and I/O utilization and the size of disk files are good indicators of how effective compression is for your ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-dict-obj-tree.html
The dict_obj_tree table provides a tree-based view of table information from the dict_obj_info table. This means that you must know the name of any tablespace or log file group associated with a given table, or obtain this information from SHOW ...