https://dev.mysql.com/innodb-page-compression.html
During recovery, updated pages are written out in an uncompressed form. InnoDB supports page-level compression for tables that reside in file-per-table tablespaces. Page compression is enabled by specifying the COMPRESSION attribute with CREATE ...
https://dev.mysql.com/insert.html
[ON DUPLICATE KEY UPDATE assignment_list] INSERT [LOW_PRIORITY | DELAYED | HIGH_PRIORITY] [IGNORE] [INTO] tbl_name [PARTITION (partition_name [, partition_name] ...)] SET assignment_list [ON DUPLICATE KEY UPDATE assignment_list] INSERT [LOW_PRIORITY ... INSERT [LOW_PRIORITY | DELAYED | HIGH_PRIORITY] [IGNORE] [INTO] tbl_name [PARTITION (partition_name [, partition_name] ...)] [(col_name [, col_name] ...)] {VALUES | VALUE} (value_list) [, (value_list)] ...
https://dev.mysql.com/json-attribute-functions.html
The functions in this section return attributes of JSON values. An error occurs if the argument is not a valid JSON document. An empty array, empty object, or scalar value has depth 1. A nonempty array containing only elements of depth 1 or ...
https://dev.mysql.com/lateral-derived-tables.html
A derived table cannot normally refer to (depend on) columns of preceding tables in the same FROM clause. As of MySQL 8.0.14, a derived table may be defined as a lateral derived table to specify that such references are permitted. Nonlateral ...
https://dev.mysql.com/myisamchk-table-info.html
If you start the MySQL server with external locking disabled, myisamchk may report an error for a table that is updated while it runs. This may be updated after a table is loaded (or greatly changed) with myisamchk -a. If this is not updated at all, ... To obtain a description of a MyISAM table or statistics about it, use the commands shown ...
https://dev.mysql.com/mysql-cluster-disk-data-objects.html
Once table ts_1 has been created as shown, you can perform INSERT, SELECT, UPDATE, and DELETE statements on it just as you would with any other MySQL table. NDB Cluster Disk Data storage is implemented using the following objects: Tablespace: Acts ...
https://dev.mysql.com/mysql-cluster-ndbd-definition.html
In setting values for these, it is important to understand how DataMemory is used, as it usually needs to be updated to reflect actual usage by the cluster. The entire amount specified by this value is allocated in memory, so it is extremely ... The ...
https://dev.mysql.com/mysql-installer-catalog-dashboard.html
By default, and when an Internet connection is present, MySQL Installer updates the catalog daily. You can also update the catalog manually from the dashboard (described later). An up-to-date catalog performs the following actions: Populates the ...
https://dev.mysql.com/mysqlbinlog.html
The second line starts with a date and time indicating when the statement started on the server where the event originated. (In particular, no cross-database updates should be used.) When used together with the --rewrite-db option, the --rewrite-db ... The server's binary log consists of files containing “events” that describe modifications to database ...
https://dev.mysql.com/optimizer-statistics.html
Here is a sample histogram object: { "buckets": [ [ 1, 0.3333333333333333 ], [ 2, 0.6666666666666666 ], [ 3, 1 ] ], "null-values": 0, "last-updated": "2017-03-24 13:32:40.000000", "sampling-rate": 1, "histogram-type": "singleton", ... The ...
