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/change-replication-filter.html
If the same filtering rule is specified multiple times, only the last such rule is actually used. Filters set using this statement differ from those set using the server options in two key respects: The statement does not require restarting the ...
https://dev.mysql.com/doc/refman/5.7/en/sys-host-summary-by-statement-type.html
max_latency The maximum single wait time of timed occurrences of the statement event for the host. These views summarize informaion about statements executed, grouped by host and statement type. total_latency The total wait time of timed ...By ...
https://dev.mysql.com/doc/refman/5.7/en/sys-user-summary-by-statement-type.html
max_latency The maximum single wait time of timed occurrences of the statement event for the user. These views summarize informaion about statements executed, grouped by user and statement type. total_latency The total wait time of timed ...By ...
https://dev.mysql.com/doc/refman/5.7/en/charset-cp932.html
Why is cp932 needed? In MySQL, the sjis character set corresponds to the Shift_JIS character set defined by IANA, which supports JIS X0201 and JIS X0208 characters. (See http://www.iana.org/assignments/character-sets.) However, the meaning of ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-prepared-statements-instances-table.html
These columns can be used to find stored programs that leak prepared statements: SELECT OWNER_OBJECT_TYPE, OWNER_OBJECT_SCHEMA, OWNER_OBJECT_NAME, STATEMENT_NAME, SQL_TEXT FROM performance_schema.prepared_statements_instances WHERE OWNER_OBJECT_TYPE ...C API Function Corresponding Server Command mysql_stmt_prepare() COM_STMT_PREPARE mysql_stmt_execute() COM_STMT_EXECUTE mysql_stmt_close() COM_STMT_CLOSE The text ...
https://dev.mysql.com/doc/refman/5.7/en/index-btree-hash.html
In the second statement, only rows with 'Pat' <= key_col < 'Pau' are considered. In the second statement, the LIKE value is not a constant. WHERE index_part1=1 OR index_part2=10 Sometimes MySQL does not use an index, even if one is available.
https://dev.mysql.com/doc/refman/5.7/en/statement-caching.html
For certain statements that a client might execute multiple times during a session, the server converts the statement to an internal structure and caches that structure to be used during execution. If the server does not detect this change the next ...To avoid problems caused by metadata changes to tables or views referred to by the prepared statement, the server detects these changes and automatically reprepares the statement when it is next ...
https://dev.mysql.com/doc/refman/5.7/en/replication-rules-table-options.html
One or more database options were found, and were evaluated to arrive at an “execute” condition according to the rules described in the previous section (see Section 16.2.5.1, “Evaluation of Database-Level Replication and Binary Logging ...
https://dev.mysql.com/doc/refman/5.7/en/charset-binary-collations.html
This section describes how the binary collation for binary strings compares to _bin collations for nonbinary strings. Binary strings (as stored using the BINARY, VARBINARY, and BLOB data types) have a character set and collation named binary.
https://dev.mysql.com/doc/refman/5.7/en/mrr-optimization.html
Reading rows using a range scan on a secondary index can result in many random disk accesses to the base table when the table is large and not stored in the storage engine's cache. The MRR optimization is not supported with secondary indexes ...