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/performance-schema-transaction-summary-tables.html
COUNT_READ_WRITE, SUM_TIMER_READ_WRITE, MIN_TIMER_READ_WRITE, AVG_TIMER_READ_WRITE, MAX_TIMER_READ_WRITE These are similar to the COUNT_STAR and xxx_TIMER_WAIT columns, but summarize read-write transactions only. COUNT_READ_ONLY, ... The Performance ...Section 29.12.7, “Performance Schema Transaction Tables” describes the events on which transaction summaries are ...
https://dev.mysql.com/doc/refman/8.0/en/show-warnings.html
Warnings are generated for DML statements such as INSERT, UPDATE, and LOAD DATA as well as DDL statements such as CREATE TABLE and ALTER TABLE. SHOW WARNINGS [LIMIT [offset,] row_count] SHOW COUNT(*) WARNINGS SHOW WARNINGS is a diagnostic statement ...The LIMIT clause has the same syntax as for the SELECT ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-events-table.html
This is displayed as a DATETIME value, and is NULL if no start date and time are defined for the event. LAST_ALTERED The date and time when the event was last modified. TIME_ZONE The event time zone, which is the time zone used for scheduling the ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-waiter.html
--connect-retries Command-Line Format --connect-retries=# Type Integer Default Value 12 Minimum Value 0 Maximum Value 12 Number of times to retry connection before giving up. ndb_waiter repeatedly (each 100 milliseconds) prints out the status of ...
https://dev.mysql.com/doc/refman/8.0/en/lateral-derived-tables.html
If a lateral derived table is in the right operand of a join clause and contains a reference to the left operand, the join operation must be an INNER JOIN, CROSS JOIN, or LEFT [OUTER] JOIN. If the table is in the left operand and contains a ... A ...
https://dev.mysql.com/doc/refman/8.0/en/charset-column.html
Every “character” column (that is, a column of type CHAR, VARCHAR, a TEXT type, or any synonym) has a column character set and a column collation. CREATE TABLE t1 ( col1 CHAR(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ) CHARACTER SET ...CREATE TABLE t1 ( col1 CHAR(10) CHARACTER SET utf8mb4 ) CHARACTER SET latin1 COLLATE latin1_bin; The character set is specified for the column, but the collation is ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-gtids.html
The settings gtid_mode=ON and enforce_gtid_consistency=ON are required on all group members. All the transactions received directly by the group can therefore be identified and are grouped together in GTID sets, and it does not matter which member ... Group Replication uses GTIDs (global transaction identifiers) to track exactly which transactions have been committed on every server ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndbxfrm.html
The ndbxfrm utility, introduced in NDB 8.0.22, can be used to decompress, decrypt, and output information about files created by NDB Cluster that are compressed, encrypted, or both. Options --compress, -c Command-Line Format --compress Introduced ...This is similar to entering a password after invoking mysql --password with no password following the ...
https://dev.mysql.com/doc/refman/8.0/en/disk-issues.html
This makes both the seek and read times better, assuming that the disk is not used for other purposes as well. RAID N can be a problem if you have many writes, due to the time required to update the parity bits. That skips updates to the last access ... This section describes ways to configure storage devices when you can devote more and faster storage hardware to the database ...For ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-trx-table.html
During times of contention, it counts down to zero, and statements release the latch immediately after each row lookup. TRX_AUTOCOMMIT_NON_LOCKING A value of 1 indicates the transaction is a SELECT statement that does not use the FOR UPDATE or LOCK ... The INNODB_TRX table provides information about every transaction currently executing inside InnoDB, including whether the transaction is waiting for a lock, when the transaction started, and the SQL statement the transaction is executing, if ...