PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 255.8Kb
Man Pages (Zip)
- 360.7Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/alter-tablespace.html
ALTER TABLESPACE tablespace_name {ADD | DROP} DATAFILE 'file_name' [INITIAL_SIZE [=] size] [WAIT] ENGINE [=] engine_name This statement is used either to add a new data file, or to drop a data file from a tablespace. The ADD DATAFILE variant ...
https://dev.mysql.com/doc/refman/5.7/en/caching-sha2-pluggable-authentication.html
MySQL provides two authentication plugins that implement SHA-256 hashing for user account passwords: sha256_password: Implements basic SHA-256 authentication. caching_sha2_password: Implements SHA-256 authentication (like sha256_password), but uses ...
https://dev.mysql.com/doc/refman/5.7/en/charset-mysql.html
To display the available character sets, use the INFORMATION_SCHEMA CHARACTER_SETS table or the SHOW CHARACTER SET statement. For more complete information, see Section 10.10, “Supported Character Sets and Collations”. mysql> SHOW CHARACTER SET; ...
https://dev.mysql.com/doc/refman/5.7/en/compressed-format.html
Compressed storage format is a read-only format that is generated with the myisampack tool. Compressed tables have the following characteristics: Compressed tables take very little disk space. This minimizes disk usage, which is helpful when using ...
https://dev.mysql.com/doc/refman/5.7/en/connecting.html
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 additional information if you are unable to connect, see Section 6.2.17, “Troubleshooting ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-like.html
LIKE to create an empty table based on the definition of another table, including any column attributes and indexes defined in the original table: CREATE TABLE new_tbl LIKE orig_tbl; The copy is created using the same version of the table storage ...
https://dev.mysql.com/doc/refman/5.7/en/default-privileges.html
The MySQL installation process involves initializing the data directory, including the grant tables in the mysql system database that define MySQL accounts. This section describes how to assign a password to the initial root account created during ...
https://dev.mysql.com/doc/refman/5.7/en/drop-tablespace.html
DROP TABLESPACE tablespace_name [ENGINE [=] engine_name] This statement drops a tablespace that was previously created using CREATE TABLESPACE. It is supported with all MySQL NDB Cluster 7.5 releases, and with InnoDB in the standard MySQL Server as ...
https://dev.mysql.com/doc/refman/5.7/en/explain-for-connection.html
To obtain the execution plan for an explainable statement executing in a named connection, use this statement: EXPLAIN [options] FOR CONNECTION connection_id; EXPLAIN FOR CONNECTION returns the EXPLAIN information that is currently being used to ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-storage-engines.html
Where can I obtain complete documentation for MySQL storage engines? A.2.2. Can I prevent the use of a particular storage engine? A.2.5. Is there an advantage to using the InnoDB storage engine exclusively, as opposed to a combination of InnoDB and ...