PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/information-schema-tp-thread-group-state-table.html
Each row provides information about the current state of a group. This is where most threads end up when the thread group has created more threads than needed for normal operation. Often a thread group needs additional threads for a short while and ... The TP_THREAD_GROUP_STATE table has one row per thread group in the thread ...
https://dev.mysql.com/doc/refman/5.7/en/load-index.html
In addition, indexes on partitioned tables can be preloaded for one, several, or all partitions. The IGNORE LEAVES modifier causes only blocks for the nonleaf nodes of the index to be preloaded. In other words, if you wish to preload indexes for all ...tbl_index_list: tbl_name [PARTITION (partition_list)] [{INDEX|KEY} (index_name[, index_name] ...)] [IGNORE LEAVES] partition_list: { partition_name[, partition_name] ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-thread-states.html
Committing events to binlog Opening mysql.ndb_apply_status Processing events The thread is processing events for binary logging. Shutting down Syncing ndb table schema operation and binlog This is used to have a correct binary log of schema ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-system-variable-tables.html
Note The value of the show_compatibility_56 system variable affects the information available from the tables described here. For details, see the description of that variable in Section 5.1.7, “Server System Variables”. System variable ...The ...
https://dev.mysql.com/doc/refman/5.7/en/show-columns.html
SHOW [FULL] {COLUMNS | FIELDS} {FROM | IN} tbl_name [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW COLUMNS displays information about the columns in a given table. SHOW COLUMNS displays information only for those columns for which you ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html
Have you deleted the .frm file InnoDB: and not used DROP TABLE? Have you used DROP DATABASE InnoDB: for InnoDB tables in MySQL version <= 3.23.43? InnoDB: See the Restrictions section of the InnoDB manual. If the original table resides in a ...
https://dev.mysql.com/doc/refman/5.7/en/sys-table-exists.html
Parameters in_db VARCHAR(64): The name of the database in which to check for table existance. Tests whether a given table exists as a regular table, a TEMPORARY table, or a view. If both a temporary and a permanent table exist with the given name, ...
https://dev.mysql.com/doc/refman/5.7/en/do.html
In most respects, DO is shorthand for SELECT expr, ..., but has the advantage that it is slightly faster when you do not care about the result. For example, DO id FROM t1 is invalid because it references a table. DO is useful primarily with ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-doublewrite-buffer.html
Because the doublewrite buffer setting is global, doublewrite buffering is also disabled for data files residing on non-Fusion-io hardware. The doublewrite buffer is a storage area where InnoDB writes pages flushed from the buffer pool before ...If ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-filtering-names.html
To check which instrument or consumer names a pattern matches, perform a simple test: SELECT NAME FROM performance_schema.setup_instruments WHERE NAME LIKE 'pattern'; SELECT NAME FROM performance_schema.setup_consumers WHERE NAME LIKE 'pattern'; For ... Names given for filtering operations can be as specific or general as ...WHERE NAME LIKE 'wait/io/file/%'; The pattern '%/file/%' ...