PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 255.8Kb
Man Pages (Zip)
- 360.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/create-event.html
This event executes once—one hour following its creation—by running an SQL statement that increments the value of the myschema.mytable table's mycol column by 1. (However, a warning is generated in such cases.) The ON SCHEDULE clause determines ... CREATE [DEFINER = user] EVENT [IF NOT EXISTS] event_name ON SCHEDULE schedule [ON COMPLETION [NOT] PRESERVE] [ENABLE | DISABLE | DISABLE ON SLAVE] [COMMENT 'string'] DO event_body; schedule: { AT timestamp [+ INTERVAL interval] ...
https://dev.mysql.com/doc/refman/5.7/en/derived-table-optimization.html
Consider the following query: SELECT * FROM t1 JOIN (SELECT DISTINCT f1 FROM t2) AS derived_t2 ON t1.f1=derived_t2.f1; The optimizer constructs an index over column f1 from derived_t2 if doing so would enable use of ref access for the lowest cost ...
https://dev.mysql.com/doc/refman/5.7/en/function-resolution.html
When the parser encounters a word that is the name of a built-in function, it must determine whether the name signifies a function call or is instead a nonexpression reference to an identifier such as a table or column name. The server generates a ... MySQL supports built-in (native) functions, loadable functions, and stored ...
https://dev.mysql.com/doc/refman/5.7/en/monitor-innodb-mutex-waits-performance-schema.html
The ENABLED and TIMED columns should be set to YES for the instruments that you enabled. $> ./mysqlslap --auto-generate-sql --concurrency=100 --iterations=10 --number-of-queries=1000 --number-char-cols=6 --number-int-cols=6; Query the wait event ...
https://dev.mysql.com/doc/refman/5.7/en/mysqlbinlog.html
--stop-never is commonly used with --raw to make a live binary log backup, but also can be used without --raw to maintain a continuous text display of log events as the server generates them. If this option is given twice (by passing in either "-vv" ... The server's binary log consists of files containing “events” that describe modifications to database ...
https://dev.mysql.com/doc/refman/5.7/en/outer-join-simplification.html
(That is, it converts the outer join to an inner join.) A condition is said to be null-rejected for an outer join operation if it evaluates to FALSE or UNKNOWN for any NULL-complemented row generated for the operation. Table expressions in the FROM ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-events-stages-history-long-table.html
When the table becomes full, the oldest row is discarded when a new row is added, regardless of which thread generated either row. The events_stages_history_long table contains the N most recent stage events that have ended globally, across all ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-events-statements-history-long-table.html
When the table becomes full, the oldest row is discarded when a new row is added, regardless of which thread generated either row. The events_statements_history_long table contains the N most recent statement events that have ended globally, across ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-events-transactions-history-long-table.html
When the table becomes full, the oldest row is discarded when a new row is added, regardless of which thread generated either row. The events_transactions_history_long table contains the N most recent transaction events that have ended globally, ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-events-waits-history-long-table.html
When the table becomes full, the oldest row is discarded when a new row is added, regardless of which thread generated either row. The events_waits_history_long table contains N the most recent wait events that have ended globally, across all ...