PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-pgman-time-track-stats.html
This table provides information regarding the latency of disk operations for NDB Cluster Disk Data tablespaces. The size of the page read to or written from a Disk Data tablespace is always 32 KB. Log wait latency (log_waits column) is the length ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-threads.html
The threads table provides information about threads running in the NDB kernel.
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-diffengines.html
Configuring different engines on the source and replica depends on how you set up the initial replication process: If you used mysqldump to create the database snapshot on your source, you could edit the dump file text to change the engine type used ... It does not matter for the replication process whether the original table on the source and the replicated table on the replica use different storage engine ...
https://dev.mysql.com/doc/refman/8.0/en/password-management.html
To establish policy for individual accounts, use the PASSWORD EXPIRE option of the CREATE USER and ALTER USER statements. To establish policy for individual accounts, use the PASSWORD HISTORY and PASSWORD REUSE INTERVAL options of the CREATE USER ...
https://dev.mysql.com/doc/refman/8.0/en/replace.html
For information about generated columns, see Section 15.1.20.8, “CREATE TABLE and Generated Columns”. | TABLE table_name} value: {expr | DEFAULT} value_list: value [, value] ... REPLACE works exactly like INSERT, except that if an old row in the ... REPLACE [LOW_PRIORITY | DELAYED] [INTO] tbl_name [PARTITION (partition_name [, partition_name] ...)] [(col_name [, col_name] ...)] { {VALUES | VALUE} (value_list) [, (value_list)] ...
https://dev.mysql.com/doc/refman/8.0/en/mysqlbinlog.html
When you specify this option, mysqlbinlog stops with an error message if it encounters any events that are disallowed under the REQUIRE_ROW_FORMAT restrictions, including LOAD DATA INFILE instructions, creating or dropping temporary tables, INTVAR, ...Note that from MySQL 8.0.14, mysqlbinlog returns a suitable error if you attempt to read an encrypted binary log file directly, but older versions of mysqlbinlog do not recognise the file as a binary log file at ...
https://dev.mysql.com/doc/refman/8.0/en/plugin-loading.html
For example, if the plugin implements a storage engine, existing tables for the storage engine become inaccessible, and attempts to create new tables for the storage engine result in tables that use the default storage engine unless the ...Built-in ... Server plugins must be loaded into the server before they can be ...
https://dev.mysql.com/doc/refman/8.0/en/data-type-defaults.html
Examples: CREATE TABLE t1 ( i INT DEFAULT -1, c VARCHAR(10) DEFAULT '', price DOUBLE(16,2) DEFAULT 0.00 ); SERIAL DEFAULT VALUE is a special case. Suppose that a table t is defined as follows: CREATE TABLE t (i INT NOT NULL); In this case, i has no ...An expression default value for one column can refer to other table columns, with the exception that references to generated columns or columns with expression default values must be to columns that occur earlier in the table ...
https://dev.mysql.com/doc/refman/8.0/en/trigger-syntax.html
To create a trigger or drop a trigger, use the CREATE TRIGGER or DROP TRIGGER statement, described in Section 15.1.22, “CREATE TRIGGER Statement”, and Section 15.1.34, “DROP TRIGGER Statement”. Here is a simple example that associates a ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-cpustat.html
The cpustat table provides per-thread CPU statistics gathered each second, for each thread running in the NDB kernel.