Search Results
https://dev.mysql.com/doc/refman/8.4/en/creating-spatial-indexes.html
For InnoDB and MyISAM tables, MySQL can create spatial indexes using syntax similar to that for creating regular indexes, but using the SPATIAL keyword. For storage engines that support nonspatial indexing of spatial columns, the engine creates a ...
https://dev.mysql.com/doc/refman/8.4/en/creating-tables.html
You want a table that contains a record for each of your pets. This can be called the pet table, and it should contain, as a bare minimum, each animal's name. Because the name by itself is not very interesting, the table should contain other ...
https://dev.mysql.com/doc/refman/8.4/en/data-masking-component-usage.html
Before using MySQL Enterprise Data Masking and De-Identification, install it according to the instructions provided at Section 8.5.2.1, “MySQL Enterprise Data Masking and De-Identification Component Installation”. To use MySQL Enterprise Data ...
https://dev.mysql.com/doc/refman/8.4/en/data-masking-plugin-usage.html
Before using MySQL Enterprise Data Masking and De-Identification, install it according to the instructions provided at Section 8.5.3.1, “MySQL Enterprise Data Masking and De-Identification Plugin Installation”. To use MySQL Enterprise Data ...
https://dev.mysql.com/doc/refman/8.4/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/8.4/en/docker-mysql-more-topics.html
The JSON output from the docker inspect command on the container includes 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/8.4/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/8.4/en/drop-tablespace.html
The UNDO keyword must be specified to drop an undo tablespace. mysql> CREATE TABLESPACE `ts1` ADD DATAFILE 'ts1.ibd' Engine=InnoDB; mysql> CREATE TABLE t1 (c1 INT PRIMARY KEY) TABLESPACE ts1 Engine=InnoDB; mysql> DROP TABLE t1; mysql> DROP ... DROP ...
https://dev.mysql.com/doc/refman/8.4/en/enterprise-encryption-installation.html
Also, if you want to change the maximum length allowed for the RSA keys generated by the component functions, use the enterprise_encryption.maximum_rsa_key_size system variable to set an appropriate maximum. The functions are provided by a MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/error-log-event-fields.html
Error events intended for the error log contain a set of fields, each of which consists of a key/value pair. err_symbol The event error symbol, as a string (for example, 'ER_DUP_KEY'). An event field may be classified as core, optional, or ...