PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/events-overview.html
A recurrent event repeats its action at a regular interval, and the schedule for a recurring event can be assigned a specific start day and time, end day and time, both, or neither. MySQL Events are tasks that run according to a schedule. When you ...
https://dev.mysql.com/doc/refman/9.7/en/locale-support.html
The locale indicated by the lc_time_names system variable controls the language used to display day and month names and abbreviations. This variable affects the output from the DATE_FORMAT(), DAYNAME(), and MONTHNAME() functions. The lc_time_names ...
https://dev.mysql.com/doc/refman/9.7/en/replication-options-binary-log.html
The default binary log expiration period is 2592000 seconds, which equals 30 days (30*24*60*60 seconds). Startup Options Used with Binary Logging System Variables Used with Binary Logging You can use the mysqld options and system variables that are ...
https://dev.mysql.com/doc/refman/9.7/en/charset.html
MySQL includes character set support that enables you to store data using a variety of character sets and perform comparisons according to a variety of collations. The default MySQL server character set and collation are utf8mb4 and ...
https://dev.mysql.com/doc/refman/9.7/en/window-functions-frames.html
Examples of valid expr PRECEDING and expr FOLLOWING indicators: 10 PRECEDING INTERVAL 5 DAY PRECEDING 5 FOLLOWING INTERVAL '2:30' MINUTE_SECOND FOLLOWING expr FOLLOWING: For ROWS, the bound is expr rows after the current row. The definition of a ...
https://dev.mysql.com/doc/refman/9.7/en/date-and-time-type-conversion.html
The TIME is interpreted as elapsed time (not time of day) and added to the date. To some extent, you can convert a value from one temporal type to another. However, there may be some alteration of the value or loss of information. In all cases, ...
https://dev.mysql.com/doc/refman/9.7/en/thread-pool-tuning.html
In the worst case, this could take hours or even days. This section provides guidelines on determining the best configuration for thread pool performance, as measured using a metric such as transactions per second. Of chief importance is the number ...
https://dev.mysql.com/doc/refman/9.7/en/testing-server.html
After the data directory is initialized and you have started the server, perform some simple tests to make sure that it works satisfactorily. This section assumes that your current location is the MySQL installation directory and that it has a bin ...
https://dev.mysql.com/doc/refman/9.7/en/sys-format-time.html
Depending on the size of the value, the units part is ps (picoseconds), ns (nanoseconds), us (microseconds), ms (milliseconds), s (seconds), m (minutes), h (hours), d (days), or w (weeks). Note format_time() is deprecated, and subject to removal in ...
https://dev.mysql.com/doc/refman/9.7/en/show-events.html
row *************************** Db: myschema Name: e_daily Definer: jon@ghidora Time zone: SYSTEM Type: RECURRING Execute at: NULL Interval value: 1 Interval field: DAY Starts: 2018-08-08 11:06:34 Ends: NULL Status: ENABLED Originator: 1 ... SHOW ...