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/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/sys-processlist.html
The MySQL process list indicates the operations currently being performed by the set of threads executing within the server. By default, rows are sorted by descending process time and descending wait time. time The time in seconds that the thread ...They provide more complete information than the SHOW PROCESSLIST statement and the INFORMATION_SCHEMA PROCESSLIST table, and are also ...
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 ...
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 ...