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/index-hints.html
Thus, you should expect USE INDEX, FORCE INDEX, and IGNORE INDEX to be deprecated in a future release of MySQL, and at some time thereafter to be removed altogether. The USE INDEX (index_list) hint tells MySQL to use only one of the named indexes to ... Index hints give the optimizer information about how to choose indexes during query ...
https://dev.mysql.com/doc/refman/8.0/en/no-login-pluggable-authentication.html
The mysql_no_login server-side authentication plugin prevents all client connections to any account that uses it. To be usable by the server, the plugin library file must be located in the MySQL plugin directory (the directory named by the ...Use ...
https://dev.mysql.com/doc/refman/8.0/en/replication-rbr-usage.html
However, in MySQL 8.0, you cannot switch from row-based or mixed format for binary logging to statement-based format at runtime, due to any CREATE TEMPORARY TABLE statements having been omitted from the binary log in the previous mode. MySQL uses ...The type of binary log used impacts the size and efficiency of ...
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-backups-mysqldump.html
Using mysqldump to create a copy of a database enables you to capture all of the data in the database in a format that enables the information to be imported into another instance of MySQL Server (see Section 6.5.4, “mysqldump — A Database ...
https://dev.mysql.com/doc/refman/8.0/en/using-system-variables.html
The MySQL server maintains many system variables that configure its operation. The client's session variables are initialized at connect time using the current values of the corresponding global variables. As of MySQL 8.0.14, a suffix can also be ...Section 7.1.8, “Server System Variables”, describes the meaning of these ...
https://dev.mysql.com/doc/refman/8.0/en/where-optimization.html
Note Because work on the MySQL optimizer is ongoing, not all of the optimizations that MySQL performs are documented here. Because MySQL does similar optimizations automatically, you can often avoid this work, and leave the query in a more ... This ...
https://dev.mysql.com/doc/refman/8.0/en/xa.html
The MySQL XA implementation is based on the X/Open CAE document Distributed Transaction Processing: The XA Specification. The XA interface to a MySQL server consists of SQL statements that begin with the XA keyword. MySQL client programs must be ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-compression-tuning.html
Whether to adjust the size of the buffer pool based on run-time performance characteristics, such as the amount of time the system spends compressing and uncompressing data. If the system performs DML operations on compressed tables, and the way the ... Most often, the internal optimizations described in InnoDB Data Storage and Compression ensure that the system runs well with compressed ...
https://dev.mysql.com/doc/refman/8.0/en/alter-table-examples.html
However, column c2 uses in-memory storage, as can be seen here in the output of SHOW CREATE TABLE: mysql> SHOW CREATE TABLE t3\G *************************** 1. For NDB tables, it is also possible to change the storage type used for a table or column. row *************************** Table: t1 Create Table: CREATE TABLE `t2` ( `c1` int(11) DEFAULT NULL ) /*!50100 TABLESPACE ts_1 STORAGE DISK */ ENGINE=ndbcluster DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 1 row in set (0.01 sec) To change the storage type of an individual column, you can use ALTER TABLE ...
https://dev.mysql.com/doc/refman/8.0/en/ansi-diff-foreign-keys.html
MySQL checks foreign key constraints immediately; the check is not deferred to transaction commit. MySQL essentially implements the semantics defined by MATCH SIMPLE, which permits a foreign key to be all or partially NULL. (It is possible to ...For ...