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-performance-ro-txn.html
You can still make changes to session-specific temporary tables in a read-only transaction, or issue locking queries for them, because those changes and locks are not visible to any other transaction. InnoDB can avoid the overhead associated with ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html
Information about table definitions is stored both in the .frm files, and in the InnoDB data dictionary. If you move .frm files around, or if the server crashes in the middle of a data dictionary operation, these sources of information can become ...
https://dev.mysql.com/doc/refman/5.7/en/monitor-alter-table-performance-schema.html
You can monitor ALTER TABLE progress for InnoDB tables using Performance Schema. There are seven stage events that represent different phases of ALTER TABLE. Each stage event reports a running total of WORK_COMPLETED and WORK_ESTIMATED for the ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-disk-data-objects.html
NDB Cluster Disk Data storage is implemented using a number of Disk Data objects. These include the following: Tablespaces act as containers for other Disk Data objects. One or more undo log files are assigned to a log file group, which is then ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-log-statistics.html
The NDB management client's CLUSTERLOG STATISTICS command can provide a number of useful statistics in its output. Counters providing information about the state of the cluster are updated at 5-second reporting intervals by the transaction ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-config-values.html
You can obtain output that is more specific, more detailed, or both by issuing the proper queries. The config_values table, implemented in NDB 7.5.0, provides information about the current state of node configuration parameter values. Each row in ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo.html
row *************************** Engine: ndbcluster Support: YES Comment: Clustered, fault-tolerant tables Transactions: YES XA: NO Savepoints: NO *************************** 2. row *************************** Engine: CSV Support: YES Comment: CSV ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-option-tables.html
Ndb_pushed_queries_defined: Number of joins that API nodes have attempted to push down to data nodes. Ndb_pushed_queries_dropped: Number of joins that API nodes have tried to push down, but failed. Ndb_pushed_queries_executed: Number of joins ...
https://dev.mysql.com/doc/refman/5.7/en/optimization-indexes.html
You must find the right balance to achieve fast queries using the optimal set of indexes. The best way to improve the performance of SELECT operations is to create indexes on one or more of the columns that are tested in the query. The index ...
https://dev.mysql.com/doc/refman/5.7/en/optimize-blob.html
For a table with several columns, to reduce memory requirements for queries that do not use the BLOB column, consider splitting the BLOB column into a separate table and referencing it with a join query when needed. Rather than testing for equality ... When storing a large blob containing textual data, consider compressing it ...