PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.9Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/keyring-okv-plugin.html
For example: STANDBY_SERVER=host_ip:port_num,host_ip:port_num,host_ip:port_num,host_ip:port_num Ensure that the list of standby servers is kept short, accurate, and up to date, and servers that are no longer valid are removed. For example: ... Note ...
https://dev.mysql.com/doc/refman/8.0/en/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/doc/refman/8.0/en/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/doc/refman/8.0/en/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/doc/refman/8.0/en/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/doc/refman/8.0/en/mysql-cluster-ndbinfo-dict-obj-tree.html
The dict_obj_tree table provides a tree-based view of table information from the dict_obj_info table. This is intended primarily for use in testing, but can be useful in visualizing hierarchies of NDB database objects. This means that you must know ...
https://dev.mysql.com/doc/refman/8.0/en/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/doc/refman/8.0/en/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 ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-columns.html
Columns using other data types relating to dates or times are not supported as partitioning columns. The next two sections discuss COLUMNS partitioning, which are variants on RANGE and LIST partitioning. COLUMNS partitioning enables the use of ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-info.html
From MySQL 8.0.16, when insertions, deletions, or updates are made to partitioned tables, the binary log records information about the partition and (if any) the subpartition in which the row event took place. For an update event, the partition ...