PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.6Kb
Man Pages (Zip)
- 402.0Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/built-in-function-reference.html
The following table lists each built-in (native) function and operator and provides a short description of each one. For a table listing functions that are loadable at runtime, see Section 14.2, “Loadable Function Reference”. ->> Return value ...
https://dev.mysql.com/doc/refman/8.0/en/date-and-time-literals.html
A DATETIME or TIMESTAMP value can include a trailing fractional seconds part in up to microseconds (6 digits) precision. A trailing fractional seconds part is recognized in the 'D hh:mm:ss.fraction', 'hh:mm:ss.fraction', 'hhmmss.fraction', and ...
https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html
timestamp is a DOUBLE rather than BIGINT because its value includes a microseconds part. The MySQL server maintains many system variables that affect its operation. Most system variables can be set at server startup using options on the command ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-statement-histogram-summary-tables.html
The Performance Schema maintains statement event summary tables that contain information about minimum, maximum, and average statement latency (see Section 29.12.20.3, “Statement Summary Tables”). To permit assessment at a more fine-grained ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-error-log-table.html
Of the logs the MySQL server maintains, one is the error log to which it writes diagnostic messages (see Section 7.4.2, “The Error Log”). Typically, the server writes diagnostics to a file on the server host or to a system log service. As of ...
https://dev.mysql.com/doc/refman/8.0/en/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/doc/refman/8.0/en/performance-schema-events-statements-current-table.html
This value is computed in microseconds but normalized to picoseconds for easier comparison with other Performance Schema timers. The table stores one row per thread showing the current status of the thread's most recent monitored statement event, so ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-innodb-logging.html
Consider the following guidelines for optimizing redo logging: Increase the size of your redo log files. When InnoDB has written redo log files full, it must write the modified contents of the buffer pool to disk in a checkpoint. From MySQL 8.0.30, ...
https://dev.mysql.com/doc/refman/8.0/en/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/doc/refman/8.0/en/mysql-cluster-ndbinfo-cpudata-50ms.html
The cpudata_50ms table provides data about CPU usage per 50-millisecond interval over the last second.