PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
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 ...
https://dev.mysql.com/doc/refman/5.7/en/replication-administration-status.html
From MySQL 5.7, the Performance Schema has replication tables that provide this information in a more accessible form. Normally, you want this to be Yes unless you have not yet started replication or have explicitly stopped it with STOP SLAVE. A ...
https://dev.mysql.com/doc/refman/5.7/en/session-state-tracking.html
Transaction state tracking enables this, which is useful for applications that may wish to move transactions from a busy server to one that is less loaded. The following characteristics are relevant for this purpose: READ ONLY READ WRITE ISOLATION ...A client can enable these trackers to receive notification of changes to its session ...