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/date-and-time-functions.html
TIME if the date argument is a TIME value and the calculations involve only HOURS, MINUTES, and SECONDS parts (that is, no date parts). DATETIME if the first argument is a DATETIME (or TIMESTAMP) value, or if the first argument is a DATE and the ...
https://dev.mysql.com/doc/refman/9.7/en/expressions.html
For example, if you specify a unit of DAY_SECOND, the value of expr is expected to have days, hours, minutes, and seconds parts. If you specify a value like '1:10', MySQL assumes that the days and hours parts are missing and the value represents ...
https://dev.mysql.com/doc/refman/9.7/en/create-event.html
For example, “two minutes and ten seconds” can be expressed as + INTERVAL '2:10' MINUTE_SECOND. Similarly, you can express “every two weeks, beginning six hours and fifteen minutes from now” as EVERY 2 WEEK STARTS CURRENT_TIMESTAMP + ...
https://dev.mysql.com/doc/refman/9.7/en/date-and-time-literals.html
For example, '20070523091528' and '070523091528' are interpreted as '2007-05-23 09:15:28', but '071122129015' is illegal (it has a nonsensical minute part) and becomes '0000-00-00 00:00:00'. Similarly, for values specified as strings that include ...
https://dev.mysql.com/doc/refman/9.7/en/option-tracker-component-supported-components.html
To be shown in the mysql_option.option_usage and mysql_option tables, a component or plugin must be written and compiled with support for the Option Tracker. The name of the Option Tracker status variable (usage counter) associated with this ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-ndbinfo-backup-id.html
This table provides a way to find the ID of the backup started most recently for this cluster. The backup_id table contains a single column id, which corresponds to a backup ID taken using the ndb_mgm client START BACKUP command.
https://dev.mysql.com/doc/refman/9.7/en/option-tracker-component-status-variables.html
option_tracker_usage:Binary Log Incremented every 600 seconds (10 minutes) while binary logging is enabled. option_tracker_usage:Group Replication This status variable is incremented every 600 seconds (10 minutes) whenever the MySQL Group ... The ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/en/change-replication-source-to.html
If both the default settings are used, the replica waits 60 seconds between reconnection attempts (SOURCE_CONNECT_RETRY=60), and keeps attempting to reconnect at this rate for 10 minutes (SOURCE_RETRY_COUNT=10). If both the default settings are ...] ...
https://dev.mysql.com/doc/refman/9.7/en/sys-statement-performance-analyzer.html
Example To create a report with the queries in the 95th percentile since the last truncation of events_statements_summary_by_digest and with a one-minute delta period: Create a temporary table to store the initial snapshot. Creates a report of the ...