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/rename-table.html
To execute RENAME TABLE, there must be no active transactions or tables locked with LOCK TABLES. If any errors occur during a RENAME TABLE, the statement fails and no changes are made. If a table has triggers, attempts to rename the table into a ...
https://dev.mysql.com/doc/refman/5.7/en/index-page-merge-threshold.html
The minimum MERGE_THRESHOLD value is 1 and the maximum value is 50. If the “page-full” percentage for an index page falls below the MERGE_THRESHOLD value when a row is deleted or when a row is shortened by an UPDATE operation, InnoDB attempts to ...
https://dev.mysql.com/doc/refman/5.7/en/show-binlog-events.html
Note Issuing a SHOW BINLOG EVENTS with no LIMIT clause could start a very time- and resource-consuming process because the server returns to the client the complete contents of the binary log (which includes all statements executed by the server ...
https://dev.mysql.com/doc/refman/5.7/en/channels-startup-options.html
--slave_net-timeout=N This value is set per channel, so that each channel waits for N seconds to check for a broken connection. --max-relay-log-size=size Maximum size of the individual relay log file for each channel; after reaching this limit, the ... This section describes startup options which are impacted by the addition of replication ...
https://dev.mysql.com/doc/refman/5.7/en/encryption-functions.html
For example: INSERT INTO t VALUES (1,AES_ENCRYPT('text', UNHEX(SHA2('My secret passphrase',512)))); If you exceed the maximum key length of 128 bits, a warning is returned. The size penalty for storing the hex string in a CHAR column is at least two ...If you want to store these results, use a column with a VARBINARY or BLOB binary string data ...
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/performance-schema-rwlock-instances-table.html
The rwlock_instances table lists all the rwlock (read write lock) instances seen by the Performance Schema while the server executes. An rwlock is a synchronization mechanism used in the code to enforce that threads at a given time can have access ...Shared-exclusive access is otherwise known as an sxlock and optimizes concurrency and improves scalability for read-write ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb-queries.html
Follow these guidelines for InnoDB indexes: Because each InnoDB table has a primary key (whether you request one or not), specify a set of primary key columns for each table, columns that are used in the most important and time-critical queries. Do ... To tune queries for InnoDB tables, create an appropriate set of indexes on each ...
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 ...