PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/group-replication-tuning-recovery.html
This critical component in Group Replication is fault tolerant and configurable. This way there is a good chance that the same server is not selected more than once when multiple members enter the group. This behavior was extended to also cover ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-triggers-table.html
This is the type of operation on the associated table for which the trigger activates. These columns indicate the catalog and schema (database) in which this table occurs, and the table name, respectively. This is a TIMESTAMP(2) value (with a ...To ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-buffer-pool-tables.html
Example 14.6 Querying System Data in the INNODB_BUFFER_PAGE Table This query provides an approximate count of pages that contain system data by excluding pages where the TABLE_NAME value is either NULL or includes a slash / or period . The ... The ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-setup.html
This section describes how to set up the daemon_memcached plugin on a MySQL server. Because the memcached daemon is tightly integrated with the MySQL server to avoid network traffic and minimize latency, you perform this process on each MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/multiple-tables.html
What should this table look like? It needs to contain the following information: The pet name so that you know which animal each event pertains to. Given these considerations, the CREATE TABLE statement for the event table might look like this: ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-logs-event-buffer.html
The remainder of this discussion focuses on the implementation based on NDB_LE_EventBufferStatus2. Event buffer logging reports in the cluster log use the format shown here: Node node_id: Event buffer status (object_id): used=bytes_used ... NDB uses ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-blob-tool.html
This tool can be used to check for and remove orphaned BLOB column parts from NDB tables, as well as to generate a file listing any orphaned parts. These options cause ndb_blob_tool to check for orphaned BLOB parts, remove any orphaned BLOB parts, ...It is sometimes useful in diagnosing and repairing corrupted or damaged NDB tables containing BLOB or TEXT ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-preparation.html
If the source cluster is already in use, you can create a backup of the source and load this onto the replica to cut down on the amount of time required for the replica to synchronize itself with the source. If the replica is also running NDB ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-threads-table.html
PROCESSLIST_ID For a foreground thread (associated with a user connection), this is the connection identifier. This is the same value displayed in the ID column of the INFORMATION_SCHEMA PROCESSLIST table, displayed in the Id column of SHOW ... The ...
https://dev.mysql.com/doc/refman/5.7/en/query-cache-configuration.html
The have_query_cache server system variable indicates whether the query cache is available: mysql> SHOW VARIABLES LIKE 'have_query_cache'; +------------------+-------+ | Variable_name | Value | +------------------+-------+ | have_query_cache | YES | ... Note The query cache is deprecated as of MySQL 5.7.20, and is removed in MySQL ...