PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/data-masking-usage.html
Before using MySQL Enterprise Data Masking and De-Identification, install it according to the instructions provided at Section 6.5.2, “Installing or Uninstalling MySQL Enterprise Data Masking and De-Identification”. To use MySQL Enterprise Data ...
https://dev.mysql.com/doc/refman/5.7/en/dba-dtrace-server.html
Global information, that is, the connection ID and user/host and where relevant the query string, is provided at key levels (connection-start, command-start, query-start, and query-exec-start). Support for DTrace is deprecated in MySQL 5.7 and is ...
https://dev.mysql.com/doc/refman/5.7/en/delete-optimization.html
To delete rows more quickly, you can increase the size of the key cache by increasing the key_buffer_size system variable. The time required to delete individual rows in a MyISAM table is exactly proportional to the number of indexes. To delete all ...
https://dev.mysql.com/doc/refman/5.7/en/docker-mysql-more-topics.html
The JSON output for running the docker inspect command on the container has a Mount key, whose value provides information on the data directory volume: $> docker inspect mysql1 ... A MySQL Docker installation is different from a common, non-Docker ...
https://dev.mysql.com/doc/refman/5.7/en/document-store.html
These sections cover the usage of MySQL as a document store: The Section 19.1, “Key Concepts” section covers concepts like Document, Collection, Session, and Schema to help you understand how to use MySQL as a document store. This chapter ...
https://dev.mysql.com/doc/refman/5.7/en/drop-index.html
To drop a primary key, the index name is always PRIMARY, which must be specified as a quoted identifier because PRIMARY is a reserved word: DROP INDEX `PRIMARY` ON t; Indexes on variable-width columns of NDB tables are dropped online; that is, ...
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/external-locking.html
Do not start the server with the delay_key_write system variable set to ALL or use the DELAY_KEY_WRITE=1 table option for any shared tables. The easiest way to satisfy these conditions is to always use --external-locking together with ... External ...
https://dev.mysql.com/doc/refman/5.7/en/federated-create-connection.html
For example: CREATE TABLE federated_table ( id INT(20) NOT NULL AUTO_INCREMENT, name VARCHAR(32) NOT NULL DEFAULT '', other INT(20) NOT NULL DEFAULT '0', PRIMARY KEY (id), INDEX name (name), INDEX other_key (other) ) ENGINE=FEDERATED DEFAULT ... To ...
https://dev.mysql.com/doc/refman/5.7/en/federated-create.html
To create a FEDERATED table you should follow these steps: Create the table on the remote server. Alternatively, make a note of the table definition of an existing table, perhaps using the SHOW CREATE TABLE statement. Create the table on the local ...