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/sys-session.html
These views are similar to processlist and x$processlist, but they filter out background processes to display only user sessions. For descriptions of the columns, see Section 26.4.3.22, “The processlist and x$processlist Views”.
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-issues.html
(A gap event is a type of “incident event,” which indicates an incident that occurs that affects the contents of the database but that cannot easily be represented as a set of changes. For information about implementing this type of setup, see ...If this occurs, it is entirely possible for new data to be inserted into the source cluster without being recorded in the source SQL node's binary ...
https://dev.mysql.com/doc/refman/5.7/en/custom-benchmarks.html
A free benchmark suite is the Open Source Database Benchmark, available at http://osdb.sourceforge.net/. In most cases, performance problems turn out to be due to issues of basic database design (for example, table scans are not good under high ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-dml.html
Therefore, consider focussing initial development efforts on write-intensive applications that are I/O-bound, and look for opportunities to use MySQL with the daemon_memcached plugin for new write-intensive applications. INSERT becomes add, UPDATE ... Benchmarks suggest that the daemon_memcached plugin speeds up DML operations (inserts, updates, and deletes) more than it speeds up ...
https://dev.mysql.com/doc/refman/5.7/en/replication-multi-source.html
This section provides tutorials on how to configure sources and replicas for multi-source replication, how to start, stop and reset multi-source replicas, and how to monitor multi-source replication. In a multi-source replication topology, a replica ... MySQL multi-source replication enables a replica to receive transactions from multiple immediate sources in ...
https://dev.mysql.com/doc/refman/5.7/en/timezone-problems.html
You can set the time zone for the server with the --timezone=timezone_name option to mysqld_safe. You can also set it by setting the TZ environment variable before you start mysqld. This should be done for the environment in which the server runs ...
https://dev.mysql.com/doc/refman/5.7/en/archive-storage-engine.html
When you create an ARCHIVE table, the server creates a table format file in the database directory. The ARCHIVE engine also supports the AUTO_INCREMENT table option in CREATE TABLE statements to specify the initial sequence value for a new table or ...To examine the source for the ARCHIVE engine, look in the storage/archive directory of a MySQL source ... The ARCHIVE storage ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-metrics-table.html
Module names can be used to enable, disable, or reset all counters for a particular subsystem. mysql> SET GLOBAL innodb_monitor_reset = dml_inserts; Query OK, 0 rows affected (0.00 sec) mysql> SELECT * FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-overview-requirements.html
Communication latency between these processes can directly affect the observed performance and latency of user queries. When setting timeout values such as HeartbeatIntervalDbDb and HeartbeatIntervalDbApi for NDB Cluster, care must be taken care to ... One of the strengths of NDB Cluster is that it can be run on commodity hardware and has no unusual requirements in this regard, other than for large amounts of RAM, due to the fact that all live data storage is done in ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-security-networking-issues.html
Also see Section 21.4.1, “Quick Test Setup of NDB Cluster”, for configuration examples using HostName with API nodes. We show an example of an NDB Cluster setup using such a physically segregated network here: Figure 21.9 NDB Cluster with ...It ... In this section, we discuss basic network security issues as they relate to NDB ...