https://dev.mysql.com/sys-format-time.html
Depending on the size of the value, the units part is ps (nanoseconds), ns (nanoseconds), us (microseconds), ms (milliseconds), s (seconds), m (minutes), h (hours), d (days), or w (weeks). Note As of MySQL 8.0.16, format_time() is deprecated and ...
https://dev.mysql.com/innodb-performance-thread_io_rate.html
The default value is 200, reflecting that the performance of typical modern I/O devices is higher than in the early days of MySQL. The master thread in InnoDB is a thread that performs various tasks in the background. Most of these tasks are I/O ...
https://dev.mysql.com/partitioning-limitations-functions.html
This section discusses limitations in MySQL Partitioning relating specifically to functions used in partitioning expressions. Each of these functions returns an integer only if it is passed an argument of an exact numeric type, such as one of the ...
https://dev.mysql.com/replication-solutions-backups-mysqldump.html
Using mysqldump to create a copy of a database enables you to capture all of the data in the database in a format that enables the information to be imported into another instance of MySQL Server (see Section 4.5.4, “mysqldump — A Database ...
https://dev.mysql.com/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/performance-schema-functions.html
As of MySQL 8.0.16, MySQL includes built-in SQL functions that format or retrieve Performance Schema data, and that may be used as equivalents for the corresponding sys schema stored functions. The built-in functions can be invoked in any schema ...
https://dev.mysql.com/thread-pool-tuning.html
In the worst case, this could take hours or even days. This section provides guidelines on setting thread pool system variables for best performance, measured using a metric such as transactions per second. Our experience in testing the thread pool ...
https://dev.mysql.com/performance-schema-timing.html
Using the cycle counter is much cheaper than getting the actual time of day. For example, the standard gettimeofday() function can take hundreds of cycles, which is an unacceptable overhead for data gathering that may occur thousands or millions of ... Events are collected by means of instrumentation added to the server source ...
https://dev.mysql.com/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/backup-policy.html
On Monday at 1 p.m., we can create an incremental backup by flushing the logs to begin a new binary log file. (For example, back it up on tape or DVD, or copy it to another machine.) On Tuesday at 1 p.m., execute another mysqladmin flush-logs ...A ...
