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/clone.html
The MySQL server must have the necessary write access to create the directory. CLONE clone_action clone_action: { LOCAL DATA DIRECTORY [=] 'clone_dir'; | INSTANCE FROM 'user'@'host':port IDENTIFIED BY 'password' [DATA DIRECTORY [=] 'clone_dir'] ...
https://dev.mysql.com/doc/refman/8.0/en/column-indexes.html
The most common type of index involves a single column, storing copies of the values from that column in a data structure, allowing fast lookups for the rows with the corresponding column values. The B-tree data structure lets the index quickly ...
https://dev.mysql.com/doc/refman/8.0/en/commands-out-of-sync.html
This can happen, for example, if you are using mysql_use_result() and try to execute a new query before you have called mysql_free_result(). If you get Commands out of sync; you can't run this command now in your client code, you are calling client ...
https://dev.mysql.com/doc/refman/8.0/en/commit.html
SET autocommit disables or enables the default autocommit mode for the current session. This means that, when not otherwise inside a transaction, each statement is atomic, as if it were surrounded by START TRANSACTION and COMMIT. You cannot use ...
https://dev.mysql.com/doc/refman/8.0/en/components.html
System and status variables implemented by a component are exposed when the component is installed and have names that begin with a component-specific prefix. MySQL Server includes a component-based infrastructure for extending server capabilities.
https://dev.mysql.com/doc/refman/8.0/en/concurrent-inserts.html
If the variable is set to ALWAYS (or 2), concurrent inserts at the end of the table are permitted even for tables that have deleted rows. If there are multiple INSERT statements, they are queued and performed in sequence, concurrently with the ...
https://dev.mysql.com/doc/refman/8.0/en/condition-filtering.html
In join processing, prefix rows are those rows passed from one table in a join to the next. In general, the optimizer attempts to put tables with low prefix counts early in the join order to keep the number of row combinations from increasing ...
https://dev.mysql.com/doc/refman/8.0/en/connecting-disconnecting.html
To connect to the server, you usually need to provide a MySQL user name when you invoke mysql and, most likely, a password. If the server runs on a machine other than the one where you log in, you must also specify a host name. Contact your ...
https://dev.mysql.com/doc/refman/8.0/en/connecting.html
Internally, MySQL does not have any limit for the length of the password. This section describes use of command-line options to specify how to establish connections to the MySQL server, for clients such as mysql or mysqldump. For information on ...
https://dev.mysql.com/doc/refman/8.0/en/connection-compression-control.html
Connections to the server can use compression on the traffic between client and server to reduce the number of bytes sent over the connection. By default, connections are uncompressed, but can be compressed if the server and the client agree on a ...