PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.5Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/performance-schema.html
It is implemented using the PERFORMANCE_SCHEMA storage engine and the performance_schema database. Event collection provides access to information about synchronization calls (such as for mutexes) file and table I/O, table locks, and so forth for ...
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-backups-mysqldump.html
Because the format of the information is SQL statements, the file can easily be distributed and applied to running servers in the event that you need access to the data in an emergency. Using mysqldump to create a copy of a database enables you to ...Dumps can be easily imported into a MySQL Server instance or a MySQL HeatWave DB System using the MySQL Shell load dump ...
https://dev.mysql.com/doc/refman/8.0/en/adding-character-set.html
The arrays in your file must have names like ctype_MYSET, to_lower_MYSET, and so on. For each <collation> element listed in the <charset> element for the character set in Index.xml, the ctype-MYSET.c file must provide an implementation of the ...To ... This section discusses the procedure for adding a character set to ...For example, greek and swe7 are ...
https://dev.mysql.com/doc/refman/8.0/en/handler.html
This statement works for InnoDB tables as well, but there is no such concept because there is no separate data file. If you do not use an alias, but open the table using a table name qualified by the database name, further references must use the ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-dict-obj-tree.html
This means that you must know the name of any tablespace or log file group associated with a given table, or obtain this information from SHOW CREATE TABLE and then querying INFORMATION_SCHEMA.FILES, or similar means as shown here: mysql> SHOW ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-limitations-limits.html
(In NDB 7.6 and earlier, this was 48.) A data node must have a node ID in the range of 1 to 144, inclusive. Memory consumed when data is inserted into an NDB table is not automatically recovered when deleted, as it is with other storage engines. See ... In this section, we list limits found in NDB Cluster that either differ from limits found in, or that are not found in, standard ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-distributed-recovery.html
Whenever a member joins or rejoins a replication group, it must catch up with the transactions that were applied by the group members before it joined, or while it was away. To enable this method of state transfer, you must install the clone plugin ...The joining member begins by checking the relay log for its group_replication_applier channel for any transactions that it already received from the group but did not yet ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-install-first-start.html
Each cluster node process must be started separately, and on the host where it resides. Note The IP address shown for a given NDB Cluster SQL or other API node in the output of SHOW is the address used by the SQL or API node to connect to the ...
https://dev.mysql.com/doc/refman/8.0/en/alter-table-partition-operations.html
PARTITION BY statement must follow the same rules as one created using CREATE TABLE ... Any data that was stored in the dropped partitions named in the partition_names list is discarded. TABLESPACE options extend the Transportable Tablespace feature ...Simply using a partition_options clause with ALTER TABLE on a partitioned table repartitions the table according to the partitioning scheme defined by the ... Partitioning-related clauses for ALTER ...
https://dev.mysql.com/doc/refman/8.0/en/no-login-pluggable-authentication.html
The file must be located in the directory named by the plugin_dir system variable. To be usable by the server, the plugin library file must be located in the MySQL plugin directory (the directory named by the plugin_dir system variable). The file ...