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/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/innodb-information-schema.html
This section provides information and usage examples for InnoDB INFORMATION_SCHEMA tables. InnoDB INFORMATION_SCHEMA tables provide metadata, status information, and statistics about various aspects of the InnoDB storage engine. You can view a list ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-cluster-locks.html
The cluster_locks table provides information about current lock requests holding and waiting for locks on NDB tables in an NDB Cluster, and is intended as a companion table to cluster_operations. Information obtain from the cluster_locks table may ...The transaction ID (transid column) is the identifier generated by the NDB API for the transaction requesting or holding the current ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-dict-obj-info.html
The dict_obj_info table provides information about NDB data dictionary (DICT) objects such as tables and indexes. (The dict_obj_types table can be queried for a list of all the types.) This information includes the object's type, state, parent ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-dictionary-columns.html
The table provides NDB dictionary information about columns of NDB tables.
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-index-columns.html
This table provides information about indexes on NDB tables. The columns of the index_columns table are listed here, along with brief descriptions: table_id Unique ID of the NDB table for which the index is defined Name of the database containing ...
https://dev.mysql.com/doc/refman/8.0/en/sys-statements-with-full-table-scans.html
These views display normalized statements that have done full table scans. The statements_with_full_table_scans and x$statements_with_full_table_scans views have these columns: query The normalized statement string. no_index_used_count The total ...
https://dev.mysql.com/doc/refman/8.0/en/password-management.html
To establish policy for individual accounts, use the PASSWORD EXPIRE option of the CREATE USER and ALTER USER statements. To establish policy for individual accounts, use the PASSWORD HISTORY and PASSWORD REUSE INTERVAL options of the CREATE USER ...
https://dev.mysql.com/doc/refman/8.0/en/identifier-case-sensitivity.html
To avoid problems caused by such differences, it is best to adopt a consistent convention, such as always creating and referring to databases and tables using lowercase names. Value Meaning 0 Table and database names are stored on disk using the ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-upgrade-downgrade.html
In many cases, mysqld cannot open tables that were created or modified by a later version of MySQL. Do not use ALTER TABLE on any existing NDB tables; do not create any new NDB tables which cannot be safely dropped prior to downgrading. After ...In ... Versions Supported for Upgrade to NDB 8.0 Reverting an NDB Cluster 8.0 Upgrade Known Issues When Upgrading or Downgrading NDB Cluster This section provides information about NDB Cluster software and compatibility between different NDB Cluster 8.0 releases with regard to performing upgrades and ...