PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/charset-collation-coercibility.html
A “system constant” (the string returned by functions such as USER() or VERSION()) has a coercibility of 3. For example, the following statement does not return an error: SELECT CONCAT(utf8_column, latin1_column) FROM t1; It returns a result ...
https://dev.mysql.com/doc/refman/5.7/en/tuning-trace-purging.html
A user who wants to see the trace of a different substatement can enable or disable tracing for the desired substatement, but this requires editing the routine code, which may not always be possible. Negative values for offset can thus prove useful ...Thus, if a statement contains substatements (such as invoking stored procedures, stored functions, or triggers), the topmost statement and substatements each generate one trace, but at the end of execution, the trace for only the last substatement is ...
https://dev.mysql.com/doc/refman/5.7/en/case-sensitivity.html
For nonbinary strings (CHAR, VARCHAR, TEXT), string searches use the collation of the comparison operands. For binary strings (BINARY, VARBINARY, BLOB), comparisons use the numeric values of the bytes in the operands; this means that for alphabetic ...A comparison between a nonbinary string and binary string is treated as a comparison of binary ...
https://dev.mysql.com/doc/refman/5.7/en/cursor-restrictions.html
A server-side cursor enables a result set to be generated on the server side, but not transferred to the client except for those rows that the client requests. The same restrictions apply to internal temporary tables created to hold the result set ... Server-side cursors are implemented in the C API using the mysql_stmt_attr_set() ...
https://dev.mysql.com/doc/refman/5.7/en/kill.html
When you use KILL, a thread-specific kill flag is set for the thread. Thread processlist identifiers can be determined from the ID column of the INFORMATION_SCHEMA PROCESSLIST table, the Id column of SHOW PROCESSLIST output, and the PROCESSLIST_ID ... KILL [CONNECTION | QUERY] processlist_id Each connection to mysqld runs in a separate ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb-logging.html
If you specify a value for innodb_log_write_ahead_size that is larger than the innodb_page_size value, the innodb_log_write_ahead_size setting is truncated to the innodb_page_size value. Setting the value too high may have a slight impact on fsync ... Consider the following guidelines for optimizing redo logging: Make your redo log files big, even as big as the buffer ...
https://dev.mysql.com/doc/refman/5.7/en/replication-gtids-restrictions.html
CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE statements are not supported inside transactions, procedures, functions, and triggers when using GTIDs (that is, when the enforce_gtid_consistency system variable is set to ON). For information about ...This section provides information about restrictions on and limitations of replication with ... Because GTID-based replication is ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-buffer-pool-resize.html
For example: mysql> SET GLOBAL innodb_buffer_pool_size=402653184; Note The buffer pool size must be equal to or a multiple of innodb_buffer_pool_chunk_size * innodb_buffer_pool_instances. For additional information about configuring buffer pool size ... You can configure InnoDB buffer pool size offline or while the server is ...
https://dev.mysql.com/doc/refman/5.7/en/drop-table.html
Be careful with this statement! For each table, it removes the table definition and all table data. Important When a table is dropped, privileges granted specifically for the table are not automatically dropped. The statement drops all named tables ...If the table is partitioned, the statement removes the table definition, all its partitions, all data stored in those partitions, and all partition definitions associated with the dropped ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-handling-nulls.html
Partitioning in MySQL does nothing to disallow NULL as the value of a partitioning expression, whether it is a column value or the value of a user-supplied expression. This means that treatment of NULL varies between partitioning of different ...