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/performance-schema-transaction-tables.html
These tables store transaction events: events_transactions_current: The current transaction event for each thread. There are also summary tables that aggregate information about transaction events; see Section 25.12.15.4, “Transaction Summary ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-what-is-new-7-6.html
New features and other important changes in NDB Cluster 7.6 which are likely to be of interest are shown in the following list: New Disk Data table file format. A new file format is used in NDB 7.6 for NDB Disk Data tables, which makes it possible ...You can do this by performing an initial restart of each data node (that is, using the --initial option) as part of the upgrade ...
https://dev.mysql.com/doc/refman/5.7/en/migrating-from-year2.html
Several programs or statements convert YEAR(2) columns to 4-digit YEAR columns automatically: ALTER TABLE statements that result in a table rebuild. To convert 2-digit YEAR(2) columns to 4-digit YEAR manually, use ALTER TABLE or REPAIR TABLE. If you ... This section describes problems that can occur when using the 2-digit YEAR(2) data type and provides information about converting existing YEAR(2) columns to 4-digit year-valued columns, which can be declared as YEAR with an implicit display width of 4 characters, or equivalently as YEAR(4) with an explicit display ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-mysql-cluster.html
It is also possible to convert existing tables that use other storage engines to NDBCLUSTER using one or more ALTER TABLE statement. See Section 21.6.11, “NDB Cluster Disk Data Tables”, for more information. You must also remember to account for ... In the following section, we answer questions that are frequently asked about NDB Cluster and the NDB storage ...
https://dev.mysql.com/doc/refman/5.7/en/metadata-locking.html
For example, a second session blocks if it attempts any of these operations: DROP TABLE t; ALTER TABLE t ...; DROP TABLE nt; ALTER TABLE nt ...; LOCK TABLE t ... Metadata locking applies not just to tables, but also to schemas, stored programs ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-privilege-distribution.html
After the copies are created, mysql_cluster_move_privileges invokes mysql_cluster_move_grant_tables, which contains the ALTER TABLE ... Normally, each MySQL server's user privilege tables in the mysql database must use the MyISAM storage engine, ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-buffer-pool-tables.html
The InnoDB INFORMATION_SCHEMA buffer pool tables provide buffer pool status information and metadata about the pages within the InnoDB buffer pool. The InnoDB INFORMATION_SCHEMA buffer pool tables include those listed below: mysql> SHOW TABLES FROM ...INNODB_BUFFER_PAGE_LRU: Holds information about the pages in the InnoDB buffer pool, in particular how they are ordered in the LRU list that determines which pages to evict from the buffer pool when it becomes ...
https://dev.mysql.com/doc/refman/5.7/en/semijoins.html
A semijoin is a preparation-time transformation that enables multiple execution strategies such as table pullout, duplicate weedout, first match, loose scan, and materialization. For an inner join between two tables, the join returns a row from one ...The optimizer uses semijoin strategies to improve subquery execution, as described in this ...
https://dev.mysql.com/doc/refman/5.7/en/optimizer-hints.html
For example, you can enable an optimization for one table in a statement and disable the optimization for a different table. References to table and index names follow the usual identifier case sensitivity rules (see Section 9.2.3, “Identifier ...
https://dev.mysql.com/doc/refman/5.7/en/select.html
You can use SET max_seeks_for_key=value as an alternative way to force MySQL to prefer key scans instead of table scans. [into_option] [FROM table_references [PARTITION partition_list]] [WHERE where_condition] [GROUP BY {col_name | expr | position} ... SELECT [ALL | DISTINCT | DISTINCTROW ] [HIGH_PRIORITY] [STRAIGHT_JOIN] [SQL_SMALL_RESULT] [SQL_BIG_RESULT] [SQL_BUFFER_RESULT] [SQL_CACHE | SQL_NO_CACHE] [SQL_CALC_FOUND_ROWS] select_expr [, select_expr] ...