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/performance-schema-table-handles-table.html
The Performance Schema exposes table lock information through the table_handles table to show the table locks currently in effect for each opened table handle. This information shows which table handles the server has open, how they are locked, and ...The value is one of READ, READ WITH SHARED LOCKS, READ HIGH PRIORITY, READ NO INSERT, WRITE ALLOW WRITE, WRITE CONCURRENT INSERT, WRITE LOW PRIORITY, or ...
https://dev.mysql.com/doc/refman/5.7/en/multiple-tables.html
The pet table keeps track of which pets you have. If you want to record other information about them, such as events in their lives like visits to the vet or when litters are born, you need another table. What should this table look like? It needs ...An event type field, if you want to be able to categorize ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-online-add-node-example.html
In addition, for each table, the ALTER TABLE statement should be followed by an OPTIMIZE TABLE to reclaim wasted space. However, in NDBCLUSTER tables that existed prior to the addition of the new nodes, neither existing nor new data is distributed ...You can verify that all existing data nodes were restarted using the updated configuration by checking the ndbinfo.nodes table in the mysql ... In this section we provide a detailed example illustrating how to add new NDB Cluster data nodes ...
https://dev.mysql.com/doc/refman/5.7/en/join.html
MySQL supports the following JOIN syntax for the table_references part of SELECT statements and multiple-table DELETE and UPDATE statements: table_references: escaped_table_reference [, escaped_table_reference] ... A table reference (when it refers ...index_hint: { USE {INDEX|KEY} [FOR {JOIN|ORDER BY|GROUP BY}] ([index_list]) | {IGNORE|FORCE} {INDEX|KEY} [FOR {JOIN|ORDER BY|GROUP BY}] (index_list) } index_list: index_name [, index_name] ...
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/information-schema-innodb-sys-tables-table.html
Tables assigned to the system tablespace using CREATE TABLE or ALTER TABLE TABLESPACE=innodb_system have a SPACE_TYPE of General. The INNODB_SYS_TABLES table provides metadata about InnoDB tables, equivalent to the information from the SYS_TABLES ...The number reported includes three hidden columns that are created by InnoDB (DB_ROW_ID, DB_TRX_ID, and ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-event-tables.html
In addition, when events end, the Performance Schema can store them in history tables. For each event type, the Performance Schema uses three tables for storing current and historical events. The tables have names of the following forms, where xxx ... For wait, stage, statement, and transaction events, the Performance Schema can monitor and store current ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-variable-table-migration.html
The INFORMATION_SCHEMA has tables that contain system and status variable information (see Section 24.3.11, “The INFORMATION_SCHEMA GLOBAL_VARIABLES and SESSION_VARIABLES Tables”, and Section 24.3.10, “The INFORMATION_SCHEMA GLOBAL_STATUS and ...Applications should run as is, with no code changes, and should see the same variable names and values as in MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/replication-rules-table-options.html
The replica checks for and evaluates table options only if either of the following two conditions is true: No matching database options were found. When viewed in terms of events, the process of checking table options is the same for both row-based ...One or more database options were found, and were evaluated to arrive at an “execute” condition according to the rules described in the previous section (see Section 16.2.5.1, “Evaluation of Database-Level Replication and Binary Logging ...