PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
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-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 ...
https://dev.mysql.com/doc/refman/5.7/en/sha256-pluggable-authentication.html
Important To connect to the server using an account that authenticates with the sha256_password plugin, you must use either a TLS connection or an unencrypted connection that supports password exchange using an RSA key pair, as described later in ...
https://dev.mysql.com/doc/refman/5.7/en/sys-statement-performance-analyzer.html
This procedure disables binary logging during its execution by manipulating the session value of the sql_log_bin system variable. By setting in_table, this can be overwritten to copy the content of the specified table. The in_views parameter and the ... Creates a report of the statements running on the ...