PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/partitioning-management.html
Note All partitions of a partitioned table must have the same number of subpartitions; it is not possible to change the subpartitioning once the table has been created. To change a table's partitioning scheme, it is necessary only to use the ALTER ... There are a number of ways using SQL statements to modify partitioned tables; it is possible to add, drop, redefine, merge, or split existing partitions using the partitioning extensions to the ALTER TABLE ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-compression.html
Using the compression features of InnoDB, you can create tables where the data is stored in compressed form. This section provides information about the InnoDB table compression and InnoDB page compression features. The benefits are amplified for ...The page compression feature is also referred to as transparent page ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-hash-maps.html
id The hash map's unique ID version Hash map version (integer) state Hash map state; see Object::State for values and descriptions.
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-resources.html
This table provides information about data node resource availability and usage. The resources table contains the following columns: node_id The unique node ID of this data node. Notes The resource_name can be any one of the names shown in the ...
https://dev.mysql.com/doc/refman/8.0/en/external-locking.html
External locking is the use of file system locking to manage contention for MyISAM database tables by multiple processes. External locking is used in situations where a single process such as the MySQL server cannot be assumed to be the only ...
https://dev.mysql.com/doc/refman/8.0/en/database-count-limit.html
The underlying file system may have a limit on the number of files that represent tables. The underlying file system may have a limit on the number of directories.
https://dev.mysql.com/doc/refman/8.0/en/group-replication-replication-group-member-stats.html
The performance_schema.replication_group_member_stats table provides group-level information related to the certification process, and also statistics for the transactions received and originated by each individual member of the replication group.
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-arbitrator-validity-detail.html
The arbitrator_validity_detail table shows the view that each data node in the cluster has of the arbitrator. All nodes should show the same arbitrator and arb_ticket values as well as the same arb_state value. Possible arb_state values are ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-arbitrator-validity-summary.html
The arbitrator_validity_summary table provides a composite view of the arbitrator with regard to the cluster's data nodes. If it has more than 1 row for longer than a few moments, then either not all nodes are connected to the arbitrator, or all ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-counters.html
The counters table provides running totals of events such as reads and writes for specific kernel blocks and data nodes. The counters table contains the following columns: node_id The data node ID block_name Name of the associated NDB kernel block ...Counts are kept from the most recent node start or restart; a node start or restart resets all counters on that ...