PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/sys-schema-index-statistics.html
update_latency The total wait time of timed updates in the index. The schema_index_statistics and x$schema_index_statistics views have these columns: table_schema The schema that contains the table. select_latency The total wait time of timed reads ...
https://dev.mysql.com/doc/refman/8.0/en/sys-schema-table-statistics-with-buffer.html
update_latency The total wait time of timed update I/O events for the table. These views summarize table statistics, including InnoDB buffer pool statistics. By default, rows are sorted by descending total wait time (tables with most contention ...
https://dev.mysql.com/doc/refman/8.0/en/sys-schema-table-statistics.html
update_latency The total wait time of timed update I/O events for the table. By default, rows are sorted by descending total wait time (tables with most contention first). The schema_table_statistics and x$schema_table_statistics views have these ...
https://dev.mysql.com/doc/refman/8.0/en/sys-sys-config.html
Configuration changes made by updating this table persist across client sessions and server restarts. First, modify the value in the table itself: mysql> UPDATE sys.sys_config SET value = 'OFF' WHERE variable = 'debug'; Second, to also ensure that ... This table contains sys schema configuration options, one row per ...
https://dev.mysql.com/doc/refman/8.0/en/traceable-statements.html
Statements which are traceable are listed here: SELECT INSERT REPLACE UPDATE DELETE EXPLAIN with any of the preceding statements SET DO DECLARE, CASE, IF, and RETURN as used in stored routines CALL Tracing is supported for both INSERT and REPLACE ...For statements which are prepared and executed in separate steps, preparation and execution are traced ...
https://dev.mysql.com/doc/refman/8.0/en/upgrading-what-is-upgraded.html
If the actual data dictionary version is lower than the current expected version, the server creates data dictionary tables with updated definitions, copies persisted metadata to the new tables, atomically replaces the old tables with the new ones, ... Installing a new version of MySQL may require upgrading these parts of the existing installation: The mysql system schema, which contains tables that store information required by the MySQL server as it runs (see Section 7.3, “The mysql System ...
https://dev.mysql.com/doc/refman/8.0/en/using-explain.html
The EXPLAIN statement provides information about how MySQL executes statements: EXPLAIN works with SELECT, DELETE, INSERT, REPLACE, and UPDATE statements. If you have a problem with indexes not being used when you believe that they should be, run ...When EXPLAIN is used with an explainable statement, MySQL displays information from the optimizer about the statement execution ...
https://dev.mysql.com/doc/refman/8.0/en/window-function-restrictions.html
The SQL standard imposes a constraint on window functions that they cannot be used in UPDATE or DELETE statements to update rows. Using such functions in a subquery of these statements (to select rows) is permitted. MySQL does not support these ...
https://dev.mysql.com/doc/refman/8.0/en/alter-tablespace.html
RENAME TO operations are implicitly performed in autocommit mode, regardless of the autocommit setting. It can be used to add a new data file to, or to drop a data file from an NDB tablespace. It can also be used to rename an NDB Cluster Disk Data ...
https://dev.mysql.com/doc/refman/8.0/en/arithmetic-functions.html
For subtraction, if the NO_UNSIGNED_SUBTRACTION SQL mode is enabled, the result is signed even if any operand is unsigned. Table 14.9 Arithmetic Operators Name Description %, MOD Modulo operator * Multiplication operator + Addition operator - Minus ...