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/create-index.html
For more information, see Section 13.1.18.8, “Secondary Indexes and Generated Columns”. For a unique index, an error occurs regardless of SQL mode because reducing the index length might enable insertion of nonunique entries that do not meet the ... CREATE [UNIQUE | FULLTEXT | SPATIAL] INDEX index_name [index_type] ON tbl_name (key_part,...) [index_option] [algorithm_option | lock_option] ...
https://dev.mysql.com/doc/refman/5.7/en/create-temporary-table.html
Suppose that the current user does not have the CREATE TEMPORARY TABLES privilege but is able to execute a definer-context stored procedure that executes with the privileges of a user who does have CREATE TEMPORARY TABLES and that creates a ... You ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-performance-multiple_io_threads.html
InnoDB uses background threads to service various types of I/O requests. You can configure the number of background threads that service read and write I/O on data pages using the innodb_read_io_threads and innodb_write_io_threads configuration ...
https://dev.mysql.com/doc/refman/5.7/en/corrupted-myisam-tables.html
You are using an external program (such as myisamchk) to modify a table that is being modified by the server at the same time. Typical symptoms of a corrupt table are: You get the following error while selecting data from the table: Incorrect key ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-best-practices.html
Committing hundreds of times a second puts a cap on performance (limited by the write speed of your storage device). Specify a primary key for every table using the most frequently queried column or columns, or an auto-increment value if there is no ...
https://dev.mysql.com/doc/refman/5.7/en/declare-condition.html
DECLARE condition_name CONDITION FOR condition_value condition_value: { mysql_error_code | SQLSTATE [VALUE] sqlstate_value } The DECLARE ... CONDITION statement declares a named error condition, associating a name with a condition that needs ...The ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-security.html
memcp --servers=localhost:11211 --binary --username=testname --password=password myfile.txt memcat --servers=localhost:11211 --binary --username=testname --password=password myfile.txt If you specify an incorrect user name or password, the operation ... Caution Consult this section before deploying the daemon_memcached plugin on a production server, or even on a test server if the MySQL instance contains sensitive ...
https://dev.mysql.com/doc/refman/5.7/en/outer-join-optimization.html
MySQL implements an A LEFT JOIN B join_specification as follows: Table B is set to depend on table A and all tables on which A depends. Table A is set to depend on all tables (except B) that are used in the LEFT JOIN condition. The LEFT JOIN ...
https://dev.mysql.com/doc/refman/5.7/en/key-cache-block-size.html
It is possible to specify the size of the block buffers for an individual key cache using the key_cache_block_size variable. This permits tuning of the performance of I/O operations for index files. The best performance for I/O operations is ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-server-side-help.html
mysql> help search_string If you provide an argument to the help command, mysql uses it as a search string to access server-side help from the contents of the MySQL Reference Manual. The proper operation of this command requires that the help ...