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/group-replication-multi-primary-mode.html
Any member that is compatible with the other group members is set to read/write mode when joining the group, and can process write transactions, even if they are issued concurrently. Group Replication does not handle client-side failover itself, so ... In multi-primary mode (group_replication_single_primary_mode=OFF) no member has a special ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-benefits.html
You can stop and start the memcached server without losing updates made to cached data. Because you can access the underlying data through SQL, you can produce reports, search or update across multiple keys, and call functions such as AVG() and ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-file-component.html
Warning For encryption key management, the component_keyring_file and component_keyring_encrypted_file components are not intended as a regulatory compliance solution. Security standards such as PCI, FIPS, and others require use of key management ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-rolling-restart.html
This is often done as part of a rolling upgrade or rolling downgrade, where high availability of the cluster is mandatory and no downtime of the cluster as a whole is permissible. This section discusses how to perform a rolling restart of an NDB ...
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/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 ...