PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 255.8Kb
Man Pages (Zip)
- 360.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/innodb-transaction-isolation-levels.html
The second UPDATE blocks when it tries to acquire x-locks on the same records, as it also uses the index defined on column b. Transaction isolation is one of the foundations of database processing. Isolation is the I in the acronym ACID; the ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html
The .frm file must have the same table schema as the orphan intermediate table (it must have the same columns and indexes) and must be placed in the database directory of the orphan intermediate table. In this case, use the following procedure to ...
https://dev.mysql.com/doc/refman/5.7/en/insert-select.html
To avoid ambiguous column reference problems when the SELECT and the INSERT refer to the same table, provide a unique alias for each table used in the SELECT part, and qualify column names in that part with the appropriate alias. ON DUPLICATE KEY ...
https://dev.mysql.com/doc/refman/5.7/en/loading-tables.html
You could create a text file pet.txt containing one record per line, with values separated by tabs, and given in the order in which the columns were listed in the CREATE TABLE statement. In its simplest form, you supply values for each column, in ...
https://dev.mysql.com/doc/refman/5.7/en/memory-storage-engine.html
MEMORY tables can have up to 64 indexes per table, 16 columns per index and a maximum key length of 3072 bytes. (This is an uncommon feature for implementations of hash indexes.) Columns that are indexed can contain NULL values. The MEMORY storage ...
https://dev.mysql.com/doc/refman/5.7/en/merge-table-problems.html
The checks ensure that the definitions of the tables and the parent MERGE table definition match by comparing column order, types, sizes and associated indexes. Because these checks take place when the tables are opened, any changes to the ... The ...
https://dev.mysql.com/doc/refman/5.7/en/monitor-mysql-memory-use.html
Instruments can be enabled by updating the ENABLED column of the Performance Schema setup_instruments table. After restarting the server, the ENABLED column of the Performance Schema setup_instruments table should report YES for memory instruments ... The following example demonstrates how to use Performance Schema and sys schema to monitor MySQL memory ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-cluster-operations.html
(Currently, the MySQL Server does not expose the NDB API transaction ID of an ongoing transaction.) The operation_type column can take any one of the values READ, READ-SH, READ-EX, INSERT, UPDATE, DELETE, WRITE, UNLOCK, REFRESH, SCAN, SCAN-SH, ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-config-nodes.html
The node_type column displays one of the following three values: MGM: Management node. The node_hostname column shows the node host as specified in the config.ini file. The config_nodes table shows nodes configured in an NDB Cluster config.ini file. For each node, the table displays a row containing the node ID, the type of node (management node, data node, or API node), and the name or IP address of the host on which the node is configured to ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-error-messages.html
The error_messages table provides information about The error_messages table contains the following columns: error_code Numeric error code error_description Description of error error_status Error status code error_classification Error ...This is ...