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/binary-log-mixed.html
A warning is added to the SHOW WARNINGS table each time such a statement is executed. Type binlog_format SLC RLC Error / Warning Logged as * * No No Error: Cannot execute statement: Binary logging is impossible since at least one engine is involved ...If a statement is logged by row and the session that executed the statement has any temporary tables, logging by row is used for all subsequent statements (except for those accessing temporary tables) until all temporary tables in use by that session are ...
https://dev.mysql.com/doc/refman/5.7/en/charset-collation-implementations.html
MySQL implements several types of collations: Simple collations for 8-bit character sets This kind of collation is implemented using an array of 256 weights that defines a one-to-one mapping from character codes to weights. It is a case-insensitive ...
https://dev.mysql.com/doc/refman/5.7/en/declare-handler.html
statement handler_action: { CONTINUE | EXIT | UNDO } condition_value: { mysql_error_code | SQLSTATE [VALUE] sqlstate_value | condition_name | SQLWARNING | NOT FOUND | SQLEXCEPTION } The DECLARE ... The handler_action value indicates what action the ...HANDLER statement specifies a handler that deals with one or more ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-statement-summary-tables.html
For example, the SUM_LOCK_TIME and SUM_ERRORS columns in statement summary tables are the aggregates of the LOCK_TIME and ERRORS columns in events_statements_current table. The prepared_statements_instances table has these additional summary ...(The ... The Performance Schema maintains tables for collecting current and recent statement events, and aggregates that information in summary ...
https://dev.mysql.com/doc/refman/5.7/en/sys-schema-table-statistics.html
By default, rows are sorted by descending total wait time (tables with most contention first). total_latency The total wait time of timed I/O events for the table. fetch_latency The total wait time of timed read I/O events for the table. The ...
https://dev.mysql.com/doc/refman/5.7/en/select-optimization.html
Tuning these statements is a top priority, whether to achieve sub-second response times for dynamic web pages, or to chop hours off the time to generate huge overnight reports. With efficient use of the InnoDB buffer pool, MyISAM key cache, and the ...NDB Cluster supports a join pushdown optimization whereby a qualifying join is sent in its entirety to NDB Cluster data nodes, where it can be distributed among them and executed in ...
https://dev.mysql.com/doc/refman/5.7/en/account-names.html
For additional detail about the properties of user names and host names as stored in the grant tables, such as maximum length, see Grant Table Scope Column Properties. MySQL account names consist of a user name and a host name, which enables ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-preload-buffer-pool.html
In addition to saving the buffer pool state at shutdown and restoring it at startup, you can save and restore the buffer pool state at any time, while the server is running. If the operation is complete, the completion time is printed (e.g. If the ... To reduce the warmup period after restarting the server, InnoDB saves a percentage of the most recently used pages for each buffer pool at server shutdown and restores these pages at server ...
https://dev.mysql.com/doc/refman/5.7/en/identifier-length.html
If the table name is close to the length limit for constraint names, the additional characters required for the constraint name may cause that name to exceed the limit, resulting in an error. The following table describes the maximum length for ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-buffer-page-lru-table.html
ACCESS_TIME An abstract number used to judge the first access time of the page. This can be the name of a clustered index or a secondary index. Querying this table can require MySQL to allocate a large block of contiguous memory, more than 64 bytes ... The INNODB_BUFFER_PAGE_LRU table provides information about the pages in the InnoDB buffer pool; in particular, how they are ordered in the LRU list that determines which pages to evict from the buffer pool when it becomes ...