Search Results
https://dev.mysql.com/doc/refman/8.4/en/analyze-table.html
ANALYZE TABLE is supported for partitioned tables, and you can use ALTER TABLE ... ANALYZE PARTITION to analyze one or more partitions; for more information, see Section 15.1.9, “ALTER TABLE Statement”, and Section 26.3.4, “Maintenance of ...
https://dev.mysql.com/doc/refman/8.4/en/derived-tables.html
row *************************** id: 1 select_type: PRIMARY table: <derived2> partitions: NULL type: system possible_keys: NULL key: NULL key_len: NULL ref: NULL rows: 1 filtered: 100.00 Extra: NULL *************************** 2. row ...For ...
https://dev.mysql.com/doc/refman/8.4/en/drop-table.html
If the table is partitioned, the statement removes the table definition, all its partitions, all data stored in those partitions, and all partition definitions associated with the dropped table. Be careful with this statement! For each table, it ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-performance.html
For advice on dealing with that situation by adjusting the settings, see Section 20.7.7, “Responses to Failure Detection and Network Partitioning”. Some key issues that can require administrator intervention are when a member is in ERROR status ... Group Replication is designed to create fault-tolerant systems with built-in failure detection and automated ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-server-states.html
However, a member that has left the group or is part of a network partition cannot report accurate information on the other servers. For more information on possible reasons for error states, see Section 20.7.7, “Responses to Failure Detection and ... The state of a Group Replication group member shows its current role in the ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-init-startup-configuration.html
You can also use raw disk partitions (raw devices) for InnoDB data files, which may speed up I/O. The first decisions to make about InnoDB configuration involve the configuration of data files, log files, page size, and memory buffers, which should ...
https://dev.mysql.com/doc/refman/8.4/en/memory-storage-engine.html
Automatic data distribution across nodes; application developers need not craft custom sharding or partitioning solutions. The MEMORY storage engine (formerly known as HEAP) creates special-purpose tables with contents that are stored in memory.
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-table-fragments.html
The table_fragments table provides information about the fragmentation, partitioning, distribution, and (internal) replication of NDB tables.
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-online-add-node-basics.html
ALGORITHM=INPLACE, REORGANIZE PARTITION statement in the mysql client for each NDBCLUSTER table. You should also bear in mind that using MAX_ROWS to set the number of partitions in this fashion is deprecated, and you should use PARTITION_BALANCE ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/bugs.backup.html
Backup of a partitioned table using transportable tablespace (TTS) would fail when any (or all) of its partitions were created in a shared tablespace. Restoring a partitioned table backed up using transportable tablespace (TTS) would fail if any of ... Please refer to the MySQL Enterprise Backup 8.4 Release Notes for a list of fixed bugs for ...