PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/date-and-time-functions.html
When unix_timestamp is a decimal value, the fractional seconds precision of the DATETIME is the same as the precision of the decimal value, up to a maximum of 6. Functions that return the current date or time each are evaluated only once per query ...See Section 11.2, “Date and Time Data Types”, for a description of the range of values each date and time type has and the valid formats in which values may be ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbd-definition.html
StartPartialTimeout Version (or later) NDB 7.5.0 Type or units milliseconds Default 30000 Range 0 - 4294967039 (0xFFFFFEFF) Restart Type Node Restart: Requires a rolling restart of the cluster. ApiFailureHandlingTimeout Version (or later) NDB 7.6.34 ...LcpScanProgressTimeout Version (or later) NDB 7.5.0 Type or units second Default 60 Range 0 - 4294967039 (0xFFFFFEFF) Restart Type Node Restart: Requires a rolling restart of the ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-system-variables.html
When this maximum is exceeded, the Performance Schema increments the Performance_schema_nested_statement_lost status variable for each stored program statement executed. If this maximum is exceeded such that a digest cannot be instrumented, the ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-timing.html
The time a statement (or stage) takes to execute is in general orders of magnitude larger than the time it takes to execute a single wait. The extra “overhead” compared to the CYCLE timer is not significant, because the overhead caused by ...
https://dev.mysql.com/doc/refman/5.7/en/explain-output.html
The EXPLAIN statement provides information about how MySQL executes statements. This means that MySQL reads a row from the first table, and then finds a matching row in the second table, the third table, and so on. Column names are shown in the ...
https://dev.mysql.com/doc/refman/5.7/en/execution-plan-information.html
The set of operations that the optimizer chooses to perform the most efficient query is called the “query execution plan”, also known as the EXPLAIN plan. Depending on the details of your tables, columns, indexes, and the conditions in your ...
https://dev.mysql.com/doc/refman/5.7/en/execute.html
You can execute a given prepared statement multiple times, passing different variables to it or setting the variables to different values before each execution. EXECUTE stmt_name [USING @var_name [, @var_name] ...] After preparing a statement with ...If the prepared statement contains any parameter markers, you must supply a USING clause that lists user variables containing the values to be bound to the ...
https://dev.mysql.com/doc/refman/5.7/en/point-in-time-recovery-positions.html
Because the output of mysqlbinlog includes SET TIMESTAMP statements before each SQL statement recorded, the recovered data and related MySQL logs reflect the original times at which the transactions were executed. Beyond the point-in-time recovery ... The last section, Section 7.5.1, “Point-in-Time Recovery Using Binary Log”, explains the general idea of using the binary log to perform a ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-persistent-stats.html
In this case innodb_stats_persistent_sample_pages should be decreased until ANALYZE TABLE execution time is acceptable. If a balance cannot be achieved between accurate statistics and ANALYZE TABLE execution time, consider decreasing the number of ... The persistent optimizer statistics feature improves plan stability by storing statistics to disk and making them persistent across server restarts so that the optimizer is more likely to make consistent choices each time for a given ...
https://dev.mysql.com/doc/refman/5.7/en/time.html
MySQL recognizes TIME values in several formats, some of which can include a trailing fractional seconds part in up to microseconds (6 digits) precision. For information about fractional seconds support in MySQL, see Section 11.2.7, “Fractional ...