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/rename-table.html
You must have ALTER and DROP privileges for the original table, and CREATE and INSERT privileges for the new table. If any errors occur during a RENAME TABLE, the statement fails and no changes are made. Regardless of the statement used, if the ...
https://dev.mysql.com/doc/refman/8.0/en/repair-table-optimization.html
However, changing the global key buffer size invalidates the buffer, causing increased disk I/O and slowdown for other sessions. REPAIR TABLE for MyISAM tables is similar to using myisamchk for repair operations, and some of the same performance ...
https://dev.mysql.com/doc/refman/8.0/en/replication-compatibility.html
For example, you can replicate from a source running MySQL 5.6 to a replica running MySQL 5.7, from a source running MySQL 5.7 to a replica running MySQL 8.0, and so on. For example, if you are using a chained or circular replication setup, you ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-errors.html
For nontransactional storage engines such as MyISAM, it is possible to have a statement that only partially updates a table and returns an error code. If a statement produces the same error (identical error code) on both the source and the replica, ...This includes the case that a statement produces an error on the source or the replica, but not ...
https://dev.mysql.com/doc/refman/8.0/en/source-installation-prerequisites.html
Some of these tools are needed no matter whether you use a standard source distribution or a development source tree. (MySQL binaries built on recent versions of Windows can generally be run on older versions.) You can determine the Windows version ...To install MySQL from source, the following system requirements must be satisfied, regardless of installation method: CMake, which is used as the build framework on all ...
https://dev.mysql.com/doc/refman/8.0/en/subqueries.html
All subquery forms and operations that the SQL standard requires are supported, as well as a few features that are MySQL-specific. is the outer query (or outer statement), and (SELECT column1 FROM t2) is the subquery. We say that the subquery is ...
https://dev.mysql.com/doc/refman/8.0/en/window-function-optimization.html
Semijoins are not applicable to window function optimization because semijoins apply to subqueries in WHERE and JOIN ... The workaround is to define the window in a WINDOW clause and refer to the window name in the OVER clauses. For faster ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-socket-instances-table.html
The socket_instances table provides a real-time snapshot of the active connections to the MySQL server. Information available in this table provides a real-time snapshot of the active connections to the server. (Additional information is available ...The table contains one row per TCP/IP or Unix socket file ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ps-tables.html
NDB 8.0 provides information in the MySQL Performance Schema about threads and transaction memory usage; NDB 8.0.29 adds ndbcluster plugin threads, and NDB 8.0.30 adds instrumenting for transaction batch memory. Thread names are shown in the name ...These features are described in greater detail in the sections which ...
https://dev.mysql.com/doc/refman/8.0/en/server-option-variable-reference.html
The following table lists all command-line options, system variables, and status variables applicable within mysqld. The table lists command-line options (Cmd-line), options valid in configuration files (Option file), server system variables ...