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/enterprise-encryption-installation.html
In releases before MySQL 8.0.30, the functions provided by MySQL Enterprise Encryption are installed by creating them individually, based on the openssl_udf shared library. If you are upgrading to MySQL 8.0.30 from an earlier release where you used ...From MySQL 8.0.30, the functions are provided by a MySQL component component_enterprise_encryption, and installing the component installs all of the ...
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/innodb-and-mysql-replication.html
For example, you can replicate modifications to an InnoDB table on the source to a MyISAM table on the replica. Cascading actions for InnoDB tables on the source are executed on the replica only if the tables sharing the foreign key relation use ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-directory.html
If a DATA DIRECTORY or INDEX DIRECTORY table option is used in a CREATE TABLE statement on the source server, the table option is also used on the replica. This can be overridden by using the NO_DIR_IN_CREATE server SQL mode on the replica, which ...This can cause problems if no corresponding directory exists in the replica host file system or if it exists but is not accessible to the replica MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-types.html
In the sections that follow, we do not necessarily provide all possible forms for the syntax that can be used for creating each partition type; for this information, see Section 15.1.20, “CREATE TABLE Statement”. With this type of partitioning, ... This section discusses the types of partitioning which are available in MySQL ...