PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-restrictions.html
If a source used STATEMENT format and a replica used ROW format, the replica would be unable to handle the transaction correctly, therefore the CREATE TABLE ... When binlog_format is set to STATEMENT, CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE ...When using GTIDs, updates to tables using nontransactional storage engines such as MyISAM cannot be made in the same statement or transaction as updates to tables using transactional storage engines such as ...
https://dev.mysql.com/doc/refman/8.0/en/data-directory-initialization.html
Data directory initialization creates time zone tables in the mysql schema but does not populate them. Within the data directory, the server creates the mysql system schema and its tables, including the data dictionary tables, grant tables, time ...
https://dev.mysql.com/doc/refman/8.0/en/mysqldump-definition-data-dumps.html
The --no-data option tells mysqldump not to dump table data, resulting in the dump file containing only statements to create the tables. Conversely, the --no-create-info option tells mysqldump to suppress CREATE statements from the output, so that ...
https://dev.mysql.com/doc/refman/8.0/en/optimizer-statistics.html
The table is persistent so that column statistics need not be created each time the server starts. This histogram type is created when the number of distinct values in the column is less than or equal to the number of buckets specified in the ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options-gtids.html
Only statements that can be logged using GTID safe statements can be logged when enforce_gtid_consistency is set to ON, so the operations listed here cannot be used with this option: CREATE TEMPORARY TABLE or DROP TEMPORARY TABLE statements inside ...There is an exception that nontransactional DML is allowed in the same transaction or in the same statement as transactional DML, if all nontransactional tables are ...
https://dev.mysql.com/doc/refman/8.0/en/string-type-syntax.html
In some cases, MySQL may change a string column to a type different from that given in a CREATE TABLE or ALTER TABLE statement. Specifying the CHARACTER SET binary attribute for a character string data type causes the column to be created as the ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-backup-id.html
This table provides a way to find the ID of the backup started most recently for this cluster. The backup_id table contains a single column id, which corresponds to a backup ID taken using the ndb_mgm client START BACKUP command.
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-config-values.html
The config_values table provides information about the current state of node configuration parameter values. Each row in the table corresponds to the current value of a parameter on a given node. The config_values table contains the following ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-foreign-keys.html
The foreign_keys table provides information about foreign keys on NDB tables.
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-logbuffers.html
The logbuffer table provides information on NDB Cluster log buffer usage. The logbuffers table contains the following columns: node_id The ID of this data node. One each of these log_type rows is shown in the logbuffers table for each data node in ...One of these rows has the log type BACKUP-DATA, which shows the amount of data buffer used during backup to copy fragments to backup ...