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/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/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/internal-locking.html
Table-Level Locking MySQL uses table-level locking for MyISAM, MEMORY, and MERGE tables, permitting only one session to update those tables at a time. At times, it may be more efficient to disable deadlock detection and rely on the ...This type of ... This section discusses internal locking; that is, locking performed within the MySQL server itself to manage contention for table contents by multiple ...
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/innodb-memcached-replication.html
2013-09-24T13:04:38.639684Z 49 [Note] Replication I/O thread: connected to source 'root@localhost:13000', replication started in log '0.000001' at position 114 Testing the InnoDB memcached Replication Configuration This example demonstrates how to ... Because the daemon_memcached plugin supports the MySQL binary log, source server through the memcached interface can be replicated for backup, balancing intensive read workloads, and high ...
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/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/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 ...