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/get-diagnostics.html
Within a stored procedure p(), we attempt to insert two values into a table that contains a TEXT NOT NULL column. The column prohibits NULL values, so the first insert succeeds but the second causes an exception. GET [CURRENT | STACKED] DIAGNOSTICS ...
https://dev.mysql.com/doc/refman/5.7/en/index-extensions.html
InnoDB automatically extends each secondary index by appending the primary key columns to it. Consider this table definition: CREATE TABLE t1 ( i1 INT NOT NULL DEFAULT 0, i2 INT NOT NULL DEFAULT 0, d DATE DEFAULT NULL, PRIMARY KEY (i1, i2), INDEX ...This can result in more efficient query execution plans and better ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-lock-waits-table.html
The INNODB_LOCK_WAITS table has these columns: REQUESTING_TRX_ID The ID of the requesting (blocked) transaction. To obtain details about the lock, join this column with the LOCK_ID column of the INNODB_LOCKS table. To obtain details about the lock, ... The INNODB_LOCK_WAITS table contains one or more rows for each blocked InnoDB transaction, indicating the lock it has requested and any locks that are blocking that ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-fields-table.html
The INNODB_SYS_FIELDS table provides metadata about the key columns (fields) of InnoDB indexes, equivalent to the information from the SYS_FIELDS table in the InnoDB data dictionary. The INNODB_SYS_FIELDS table has these columns: INDEX_ID An ...For ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-tablestats-table.html
Table statistics are updated only for DELETE or UPDATE operations that modify indexed columns. Statistics are not updated by operations that modify only nonindexed columns. ANALYZE TABLE clears table statistics and sets the STATS_INITIALIZED column ... The INNODB_SYS_TABLESTATS table provides a view of low-level status information about InnoDB ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-file-space.html
If a row exceeds the maximum row length, variable-length columns are chosen for external off-page storage until the row fits within the maximum row length limit. External off-page storage for variable-length columns differs by row format: COMPACT ...
https://dev.mysql.com/doc/refman/5.7/en/multiple-tables.html
In this example, the ON clause specifies that the name column in the pet table must match the name column in the event table. Because the name column occurs in both tables, you must be specific about which table you mean when referring to the column. This is done by prepending the table name to the column ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-limitations-transactions.html
NDBCLUSTER stores only part of a column value that uses any of MySQL's BLOB or TEXT data types in the table visible to MySQL; the remainder of the BLOB or TEXT is stored in a separate internal table that is not accessible to MySQL. This issue does ... A number of limitations exist in NDB Cluster with regard to the handling of ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-nodes.html
The config_generation column shows which version of the cluster configuration is in effect on each data node. The nodes table contains the following columns: node_id The data node's unique node ID in the cluster. config_generation The version of the ... This table contains information on the status of data ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-operations-per-fragment.html
The type column shows the schema object type used for this fragment, which can take any one of the values System table, User table, Unique hash index, or Ordered index. The table_id column value is unique at any given time, but can be reused if the ... The operations_per_fragment table provides information about the operations performed on individual fragments and fragment replicas, as well as about some of the results from these ...