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/innodb-information-schema-files-table.html
The Information Schema FILES table provides metadata about all InnoDB tablespace types including file-per-table tablespaces, general tablespaces, the system tablespace, temporary table tablespaces, and undo tablespaces (if present). Note The ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-cluster-locks.html
The cluster_locks table provides information about current lock requests holding and waiting for locks on NDB tables in an NDB Cluster, and is intended as a companion table to cluster_operations. Information obtain from the cluster_locks table may ...The transaction ID (transid column) is the identifier generated by the NDB API for the transaction requesting or holding the current ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-transporters.html
This information is shown in the table's status column, which can have any one of the following values: CONNECTING, CONNECTED, DISCONNECTING, or DISCONNECTED. Rows where the node_id is that of a data node which is not currently connected are not ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-delete-all.html
In some cases, this can be much faster than DELETE or even TRUNCATE TABLE. Usage ndb_delete_all -c connection_string tbl_name -d db_name This deletes all rows from the table named tbl_name in the database named db_name. Options that can be used with ...--connect-retries Command-Line Format --connect-retries=# Type Integer Default Value 12 Minimum Value 0 Maximum Value 12 Number of times to retry connection before giving ...
https://dev.mysql.com/doc/refman/5.7/en/explain.html
In practice, the DESCRIBE keyword is more often used to obtain information about table structure, whereas EXPLAIN is used to obtain a query execution plan (that is, an explanation of how MySQL would execute a query). By default, DESCRIBE displays ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-locking-reads.html
(Old versions of a record cannot be locked; they are reconstructed by applying undo logs on an in-memory copy of the record.) These clauses are primarily useful when dealing with tree-structured or graph-structured data, either in a single table or ... If you query data and then insert or update related data within the same transaction, the regular SELECT statement does not give enough ...
https://dev.mysql.com/doc/refman/5.7/en/load-index.html
| ALL } The LOAD INDEX INTO CACHE statement preloads a table index into the key cache to which it has been assigned by an explicit CACHE INDEX statement, or into the default key cache otherwise. LOAD INDEX INTO CACHE applies only to MyISAM tables, ...tbl_index_list: tbl_name [PARTITION (partition_list)] [{INDEX|KEY} (index_name[, index_name] ...)] [IGNORE LEAVES] partition_list: { partition_name[, partition_name] ...
https://dev.mysql.com/doc/refman/5.7/en/multiple-key-caches.html
This feature enables you to assign different table indexes to different key caches. Where there are multiple key caches, the server must know which cache to use when processing queries for a given MyISAM table. By default, all MyISAM table indexes ... Shared access to the key cache improves performance but does not eliminate contention among sessions ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-sql-statements.html
However, you can use LIKE to filter queries against the Information Schema ENGINES table, as discussed in the next item. SELECT * FROM INFORMATION_SCHEMA.ENGINES [WHERE ENGINE LIKE 'NDB%'] This is the equivalent of SHOW ENGINES, but uses the ENGINES ... This section discusses several SQL statements that can prove useful in managing and monitoring a MySQL server that is connected to an NDB Cluster, and in some cases provide information about the cluster ...
https://dev.mysql.com/doc/refman/5.7/en/optimize-overview.html
Database performance depends on several factors at the database level, such as tables, queries, and configuration settings. In practice, the advanced InnoDB performance features mean that InnoDB tables often outperform the simpler MyISAM tables, ...