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/mysql-cluster-compared.html
Since both NDB and InnoDB can serve as transactional MySQL storage engines, users of MySQL Server sometimes become interested in NDB Cluster. See Section 21.2.6.3, “NDB and InnoDB Feature Usage Summary”, for a comparison of the relative ...While ... MySQL Server offers a number of choices in storage ...
https://dev.mysql.com/doc/refman/5.7/en/derived-table-optimization.html
(For an example, see Section 8.2.2.2, “Optimizing Subqueries with Materialization”.) If merging would result in an outer query block that references more than 61 base tables, the optimizer chooses materialization instead. Thus, if an ...The ...
https://dev.mysql.com/doc/refman/5.7/en/sys-io-by-thread-by-latency.html
The io_by_thread_by_latency and x$io_by_thread_by_latency views have these columns: user For foreground threads, the account associated with the thread. These views summarize I/O consumers to display time waiting for I/O, grouped by thread.
https://dev.mysql.com/doc/refman/5.7/en/identifiers.html
See Section 9.4, “User-Defined Variables”, for more information and examples of workarounds. A user variable cannot be used directly in an SQL statement as an identifier or as part of an identifier. If you have databases or tables from an older ... Certain objects within MySQL, including database, table, index, column, alias, view, stored procedure, partition, tablespace, and other object names are known as ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-message-compression.html
Compression for messages sent in the group happens at the group communication engine level, before the data is handed over to the group communication thread, so it takes place within the context of the mysql user session thread. You could use the ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-intro.html
The default settings represent a combination of high reliability and the fewest surprises for database applications. For example, default settings avoid uncommitted data on the database side, or stale data returned for memcached get requests. You ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-nodes.html
SINGLEUSER is displayed in the status column for all data nodes when the cluster is in single user mode (see Section 21.6.6, “NDB Cluster Single User Mode”). For example, if you put the cluster in single user mode, you can sometimes see data ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-backups.html
Reset the replica cluster using this statement in the mysql client: mysqlR> RESET SLAVE; You can now start the cluster restoration process on the replica using the ndb_restore command for each backup file in turn. We assume that the replication ...
https://dev.mysql.com/doc/refman/5.7/en/linux-installation-yum-repo.html
A password for the superuser is set and stored in the error log file. For more information on the postinstallation procedures, see Section 2.9, “Postinstallation Setup and Testing”. Before You Start As a popular, open-source software, MySQL, in ...Follow these steps: Go to the Download MySQL Yum Repository page (https://dev.mysql.com/downloads/repo/yum/) in the MySQL Developer ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-metadata-locks-table.html
Metadata locking applies not just to tables, but also to schemas, stored programs (procedures, functions, triggers, scheduled events), tablespaces, user locks acquired with the GET_LOCK() function (see Section 12.14, “Locking Functions”), and ...