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/create-database.html
An error occurs if the database exists and you did not specify IF NOT EXISTS. For information about character set and collation names, see Chapter 12, Character Sets, Collations, Unicode. To see the available character sets and collations, use the ... CREATE {DATABASE | SCHEMA} [IF NOT EXISTS] db_name [create_option] ...
https://dev.mysql.com/doc/refman/8.0/en/example-foreign-keys.html
When an operation affects a key value in the parent table that has matching rows in the child table, the result depends on the referential action specified by ON UPDATE and ON DELETE subclauses of the FOREIGN KEY clause. Omitting ON DELETE and ON ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-innodb-change-buffer.html
What types of operations modify secondary indexes and result in change buffering? INSERT, UPDATE, and DELETE operations can modify secondary indexes. What types of operations modify secondary indexes and result in change buffering? A.16.2. What is ...How much space does InnoDB use for the change buffer? ...
https://dev.mysql.com/doc/refman/8.0/en/forcing-innodb-recovery.html
Warning Only set innodb_force_recovery to a value greater than 0 in an emergency situation, so that you can start InnoDB and dump your tables. When forcing InnoDB recovery, you should always start with innodb_force_recovery=1 and only increase the ... To investigate database page corruption, you might dump your tables from the database with SELECT ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-deploying-locally.html
Therefore this information should be used for testing purposes and it should not be used in a production environments. This means that three data directories are needed, one per server instance, and that you need to configure each instance ... The ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-columns-table.html
on update CURRENT_TIMESTAMP for TIMESTAMP or DATETIME columns that have the ON UPDATE CURRENT_TIMESTAMP attribute. The COLUMN_TYPE value contains the type name and possibly other information such as the precision or length. The COLUMN_TYPE value ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-tablespaces-table.html
The INNODB_TABLESPACES table provides metadata about InnoDB file-per-table, general, and undo tablespaces. For related usage information and examples, see Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”. Note The ...ROW_FORMAT ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-security.html
Because memcached does not use an authentication mechanism by default, and the optional SASL authentication is not as strong as traditional DBMS security measures, only keep non-sensitive data in the MySQL instance that uses the daemon_memcached ...
https://dev.mysql.com/doc/refman/8.0/en/lock-order-tool.html
As of MySQL 8.0.17, to enable detection of lock-acquisition deadlocks and enforcement that runtime execution is free of them, MySQL supports LOCK_ORDER tooling. This enables a lock-order dependency graph to be defined as part of server design, and ... The MySQL server is a multithreaded application that uses numerous internal locking and lock-related primitives, such as mutexes, rwlocks (including prlocks and sxlocks), conditions, and ...
https://dev.mysql.com/doc/refman/8.0/en/merge-table-problems.html
If the parent is a temporary table, it is not locked, and thus the child tables are also not locked; this means that parallel use of the underlying MyISAM tables corrupts them. If you do so, the MERGE table may still refer to the original table and ... The following are known problems with MERGE tables: MERGE child tables are locked through the parent ...