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/events-overview.html
When you create an event, you are creating a named database object containing one or more SQL statements to be executed at one or more regular intervals, beginning and ending at a specific date and time. Whereas a trigger is a database object whose ...Scheduled tasks of this type are also sometimes known as “temporal triggers”, implying that these are objects that are triggered by the passage of ...
https://dev.mysql.com/doc/refman/5.7/en/ldml-rules.html
Rules that specify differences at secondary or higher sort levels are recognized (and thus can be included in collation definitions) but are treated as equality at the primary level. Either of the following rules resets subsequent shift rules to be ...This is a subset of the syntax described in the LDML specification available at http://www.unicode.org/reports/tr35/, which should be consulted for further ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-online-add-node-basics.html
Execute one or more CREATE NODEGROUP commands in the NDB Cluster management client to create the new node group or node groups to which the new data nodes belong. Note This needs to be done only for tables already existing at the time the new node ... In this section, we list the basic steps required to add new data nodes to an NDB ...
https://dev.mysql.com/doc/refman/5.7/en/sys-io-global-by-wait-by-latency.html
max_latency The maximum single wait time of timed occurrences of the I/O event. These views summarize global I/O consumers to display amount of I/O and time waiting for I/O, grouped by event. total_latency The total wait time of timed occurrences ...The io_global_by_wait_by_latency and x$io_global_by_wait_by_latency views have these columns: event_name The I/O event name, with the wait/io/file/ prefix ...
https://dev.mysql.com/doc/refman/5.7/en/monitor-alter-table-performance-schema.html
stage/innodb/alter table (end): Includes any remaining work that appeared after the flush phase, such as reapplying DML that was executed on the table while ALTER TABLE was running. You can monitor ALTER TABLE progress for InnoDB tables using ...
https://dev.mysql.com/doc/refman/5.7/en/binary-varbinary.html
If strict SQL mode is not enabled and you assign a value to a BINARY or VARBINARY column that exceeds the column's maximum length, the value is truncated to fit and a warning is generated. The permissible maximum length is the same for BINARY and ...
https://dev.mysql.com/doc/refman/5.7/en/archive-storage-engine.html
Attempting to create an index on any other column results in an error. ARCHIVE does not support inserting a value into an AUTO_INCREMENT column less than the current maximum column value. A bulk insert is visible only after it completes, unless ...
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/group-replication-summary.html
A replication group is formed by multiple servers and each server in the group may execute transactions independently at any time. However, there may be conflicts between transactions that execute concurrently on different servers. During ... Group ...
https://dev.mysql.com/doc/refman/5.7/en/sorted-index-builds.html
InnoDB performs a bulk load instead of inserting one index record at a time when creating or rebuilding indexes. In the second phase, with one or more runs written to the temporary intermediate file, a merge sort is performed on all entries in the ...This method of index creation is also known as a sorted index ...