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/mysql-cluster-ndbd-definition.html
A single join involving 10 tables requires 11 transaction records; if there are 10 such joins in a transaction, then 10 * 11 = 110 transaction records are required for this transaction, per MySQL server, or 110 * 10 = 1100 transaction records total.
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-diskpagebuffer.html
The diskpagebuffer table provides statistics about disk page buffer usage by NDB Cluster Disk Data tables. The diskpagebuffer table contains the following columns: node_id The data node ID block_instance Block instance pages_written Number of pages ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo.html
In addition, pushing down of joins is not supported on ndbinfo tables; so joining large ndbinfo tables can require transfer of a large amount of data to the requesting API node, even when the query makes use of a WHERE clause. ndbinfo is a database ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-waiter.html
STARTING: The node's ndbd process has started, but the node has not yet joined the cluster. ndb_waiter repeatedly (each 100 milliseconds) prints out the status of all cluster data nodes until either the cluster reaches a given status or the ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-start-phases.html
At this point in a node restart or initial node restart, event delivery is handed over to the node joining the cluster. The newly-joined node takes over responsibility for delivering its primary data to subscribers. This section provides a ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-innodb-cluster-introduction.html
In the past, to provision a new instance before it joins a set of MySQL instances you would need to somehow manually transfer the transactions to the joining instance. This chapter introduces MySQL InnoDB Cluster, which combines MySQL technologies ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-tips.html
Setting max_join_size to 1,000,000 causes multiple-table SELECT statements to produce an error if the server estimates it must examine more than 1,000,000 row combinations. This section provides information about techniques for more effective use ...
https://dev.mysql.com/doc/refman/5.7/en/order-by-optimization.html
(This is the first table in the EXPLAIN output that does not have a const join type.) The query has different ORDER BY and GROUP BY expressions. This section describes when MySQL can use an index to satisfy an ORDER BY clause, the filesort ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-replication-tables.html
By contrast, using the Performance Schema tables, information about replica status can be searched using general SELECT queries, including complex WHERE conditions, joins, and so forth. If needed, these values can be obtained from the process list ...This is similar to the information available from the SHOW SLAVE STATUS statement, but representation in table form is more accessible and has usability benefits: SHOW SLAVE STATUS output is useful for visual inspection, but not so much for programmatic ...
https://dev.mysql.com/doc/refman/5.7/en/range-optimization.html
The range access method uses a single index to retrieve a subset of table rows that are contained within one or several index value intervals. The following sections describe conditions under which the optimizer uses range access. Additionally, for ...