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/replication-gtids-restrictions.html
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 InnoDB. This restriction is due to the ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options-reference.html
gtid_executed_compression_period: Compress gtid_executed table each time this many transactions have occurred. master_info_repository: Whether to write connection metadata repository, containing source information and replication I/O thread location ... The following two sections provide basic information about the MySQL command-line options and system variables applicable to replication and the binary ...
https://dev.mysql.com/doc/refman/8.0/en/charset-unicode-sets.html
Beginning with MySQL 8.0.28, utf8mb3 is also displayed in place of utf8 in columns of Information Schema tables, and in the output of SQL SHOW statements. To determine the pad attribute for a collation, use the INFORMATION_SCHEMA COLLATIONS table, ... This section describes the collations available for Unicode character sets and their differentiating ...
https://dev.mysql.com/doc/refman/8.0/en/create-user.html
It enables authentication, role, SSL/TLS, resource-limit, password-management, comment, and attribute properties to be established for new accounts. Plugin names are stored in the plugin column of the mysql.user system table. Credentials that are ...
https://dev.mysql.com/doc/refman/8.0/en/forcing-innodb-recovery.html
If you encounter a runaway rollback caused by a failing mass import or ALTER TABLE, you can kill the mysqld process and set innodb_force_recovery to 3 to bring the database up without the rollback, and then DROP the table that is causing the runaway ... To investigate database page corruption, you might dump your tables from the database with SELECT ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-consistent-read.html
Consistent read does not work over ALTER TABLE operations that make a temporary copy of the original table and delete the original table when the temporary copy is built. This exception causes the following anomaly: If you update some rows in a ...
https://dev.mysql.com/doc/refman/8.0/en/myisam-start.html
myisam_max_sort_file_size The maximum size of the temporary file that MySQL is permitted to use while re-creating a MyISAM index (during REPAIR TABLE, ALTER TABLE, or LOAD DATA). The following options to mysqld can be used to change the behavior of ...bulk_insert_buffer_size The size of the tree cache used in bulk insert ...
https://dev.mysql.com/doc/refman/8.0/en/temporary-files.html
The optional EXTENDED modifier causes SHOW TABLES to list hidden tables created by failed ALTER TABLE statements. The maximum disk space required is determined by the following expression: (length of what is sorted + sizeof(row pointer)) * number of ... On Unix, MySQL uses the value of the TMPDIR environment variable as the path name of the directory in which to store temporary ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-troubleshooting-datadict.html
mysql> ALTER TABLE sakila.actor DISCARD TABLESPACE; Copy the orphan .ibd file from your backup directory to the new database directory. Information about table definitions is stored in the InnoDB data dictionary. Cannot Open Datafile With ...If you ...
https://dev.mysql.com/doc/refman/8.0/en/create-event.html
This is an example of a minimal CREATE EVENT statement: CREATE EVENT myevent ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 1 HOUR DO UPDATE myschema.mytable SET mycol = mycol + 1; The previous statement creates an event named myevent. This event ...