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/myisamchk-table-info.html
By default this is 1024, but the value may be changed at compile time when MySQL is built from source. If you start the MySQL server with external locking disabled, myisamchk may report an error for a table that is updated while it runs. Most tables ... To obtain a description of a MyISAM table or statistics about it, use the commands shown ...
https://dev.mysql.com/doc/refman/8.0/en/backup-methods.html
Therefore, to allow a server to be restored to a point-in-time, binary logging must be enabled on it, which is the default setting for MySQL 8.0 ; see Section 7.4.4, “The Binary Log”. The next time you do a full backup, you should also rotate ...
https://dev.mysql.com/doc/refman/8.0/en/binary-log-setting.html
You can select the binary logging format explicitly by starting the MySQL server with --binlog-format=type. From MySQL 8.0, binary logging is enabled by default, and is only disabled if you specify the --skip-log-bin or --disable-log-bin option at ...The supported values for type are: STATEMENT causes logging to be statement ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-change-primary.html
As of MySQL 8.0.29, you can specify a timeout from 1 to 3600 seconds (60 minutes) for transactions that are running when you use the function. For the timeout to work, all members of the group must be at MySQL 8.0.29 or higher. If all members are ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-transaction-isolation-levels.html
If the row matches (must be updated), MySQL reads the row again and this time InnoDB either locks it or waits for a lock on it. Isolation is the I in the acronym ACID; the isolation level is the setting that fine-tunes the balance between ...
https://dev.mysql.com/doc/refman/8.0/en/semijoins.html
A semijoin is a preparation-time transformation that enables multiple execution strategies such as table pullout, duplicate weedout, first match, loose scan, and materialization. For an inner join between two tables, the join returns a row from one ...The optimizer uses semijoin strategies to improve subquery execution, as described in this ...
https://dev.mysql.com/doc/refman/8.0/en/show-profile.html
Note The SHOW PROFILE and SHOW PROFILES statements are deprecated; expect them to be removed in a future MySQL release. Enable profiling by setting profiling to 1 or ON: mysql> SET profiling = 1; SHOW PROFILES displays a list of the most recent ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-check-constraints.html
Prior to MySQL 8.0.16, CREATE TABLE permits only the following limited version of table CHECK constraint syntax, which is parsed and ignored: CHECK (expr) As of MySQL 8.0.16, CREATE TABLE permits the core features of table and column CHECK ...
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 ...