Search Results
https://dev.mysql.com/doc/refman/8.4/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.4/en/mysql-cluster-ndbinfo-index-stats.html
The index_stats table provides basic information about NDB index statistics. The index_stats table contains the following columns: index_id Index ID index_version Index version sample_version Sample version Notes . More complete index statistics ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-membership.html
The membership table describes the view that each data node has of all the others in the cluster, including node group membership, president node, arbitrator, arbitrator successor, arbitrator connection states, and other information. We determine ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-memoryusage.html
Querying this table provides information similar to that provided by the ALL REPORT MemoryUsage command in the ndb_mgm client, or logged by ALL DUMP 1000. The memoryusage table contains the following columns: node_id The node ID of this data node.
https://dev.mysql.com/doc/refman/8.4/en/mysql-tzinfo-to-sql.html
The mysql_tzinfo_to_sql program loads the time zone tables in the mysql database. It is used on systems that have a zoneinfo database (the set of files describing time zones). One likely location for these files is the /usr/share/zoneinfo directory ...
https://dev.mysql.com/doc/refman/8.4/en/retrieving-data.html
The SELECT statement is used to pull information from a table. The general form of the statement is: SELECT what_to_select FROM which_table WHERE conditions_to_satisfy; what_to_select indicates what you want to see. This can be a list of columns, ...If it is present, conditions_to_satisfy specifies one or more conditions that rows must satisfy to qualify for ...
https://dev.mysql.com/doc/refman/8.4/en/sys-schema-table-lock-waits.html
For additional information, see the description of the Performance Schema metadata_locks table at Section 29.12.13.3, “The metadata_locks Table”. The schema_table_lock_waits and x$schema_table_lock_waits views have these columns: object_schema ... These views display which sessions are blocked waiting on metadata locks, and what is blocking ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema.html
INFORMATION_SCHEMA provides access to database metadata, information about the MySQL server such as the name of a database or table, the data type of a column, or access privileges. Other terms that are sometimes used for this information are data ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb.html
This section explains how to optimize database operations for InnoDB tables. InnoDB is the storage engine that MySQL customers typically use in production databases where reliability and concurrency are important.
https://dev.mysql.com/doc/refman/8.4/en/optimizing-myisam.html
The MyISAM storage engine performs best with read-mostly data or with low-concurrency operations, because table locks limit the ability to perform simultaneous updates. In MySQL, InnoDB is the default storage engine rather than MyISAM.