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/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/hash-joins.html
row *************************** id: 1 select_type: SIMPLE table: t1 partitions: NULL type: ALL possible_keys: NULL key: NULL key_len: NULL ref: NULL rows: 1 filtered: 100.00 Extra: NULL *************************** 2. Prior to MySQL 8.0.20, a hash ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-statistics-estimation.html
Optimizer statistics are not persisted to disk when innodb_stats_persistent=OFF or when individual tables are created or altered with STATS_PERSISTENT=0. Optimizer Statistics Updates Non-persistent optimizer statistics are updated when: Running ...
https://dev.mysql.com/doc/refman/8.0/en/storage-engine-setting.html
When you create a new table, you can specify which storage engine to use by adding an ENGINE table option to the CREATE TABLE statement: -- ENGINE=INNODB not needed unless you have set a different -- default storage engine. CREATE TABLE t1 (i INT) ...For example, in a replication setup, perhaps your source server uses InnoDB tables for maximum safety, but the replica servers use other storage engines for speed at the expense of durability or ...
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 ...
https://dev.mysql.com/doc/refman/8.0/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 ...