Search Results
https://dev.mysql.com/doc/refman/8.4/en/telemetry-metrics-meter-metrics.html
key_reads Key_reads ASYNC COUNTER The number of physical reads of a key block from disk into the MyISAM key cache. rows_deleted Innodb_rows_deleted ASYNC COUNTER The number of rows inserted into InnoDB tables. system_rows_inserted ... The following ...
https://dev.mysql.com/doc/refman/8.4/en/timestamp-initialization.html
For example: INSERT INTO t2 VALUES (CURRENT_TIMESTAMP); INSERT INTO t1 VALUES (NOW()); If the explicit_defaults_for_timestamp system variable is enabled, TIMESTAMP columns permit NULL values only if declared with the NULL attribute. TIMESTAMP and ...
https://dev.mysql.com/doc/refman/8.4/en/timestamp-lookups.html
Temporal values are stored in TIMESTAMP columns as UTC values, and values inserted into and retrieved from TIMESTAMP columns are converted between the session time zone and UTC. (The example shown earlier illustrates how this can occur.) The query ...(This is the same type of conversion performed by the CONVERT_TZ() ...
https://dev.mysql.com/doc/refman/8.4/en/tracing-example.html
Now we can examine the trace, whose first column (QUERY), containing the original statement to be traced, is shown here: SELECT * FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE\G *************************** 1. row *************************** QUERY: SELECT ...
https://dev.mysql.com/doc/refman/8.4/en/window-functions-usage.html
However, whereas an aggregate operation groups query rows into a single result row, a window function produces a result for each query row: The row for which function evaluation occurs is called the current row. partition_clause: A PARTITION BY ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-0.html
(Bug #36118772) Warnings for unused variables are turned into compilation errors when compiling with -DMYSQL_MAINTAINER_MODE=1. This means that some candidate plans grouped on {t2.x, t1.x} and others on {t1.x}, which were both valid but yielded ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-incremental-options.html
All InnoDB data modified after the LSN (specified directly or indirectly by the options you use) is copied into the incremental backup. By default, all non-InnoDB files are included into the incremental backup and in their fullness. Note No binary ... For an overview of incremental backups and usage examples for these options, see Section 4.3.3, “Making a Differential or Incremental Backup” and Section 5.1.3, “Restoring an Incremental ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-repository-options.html
The backup repository options are divided into two groups: the first one determines the structure of the backup, and the second one provides information on the original structure of the data on the backed-up server for future operations on the ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/bugs.backup.html
MySQL Enterprise Backup does not include the .pem files from the server into the backup. To avoid the problem, the server administrator should not put into the same directory the system tablespace and a general tablespace of the same basename; if ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/mysqlbackup.full.html
For convenience and consistency, you can include those options that remain unchanged for most backup jobs into the [mysqlbackup] section of the MySQL configuration file that you supply to mysqlbackup. Putting the options into a configuration file ...