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/information-schema-innodb-ft-index-cache-table.html
The INNODB_FT_INDEX_CACHE table provides token information about newly inserted rows in a FULLTEXT index. Before querying it, set the value of the innodb_ft_aux_table system variable to the name (including the database name) of the table that ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-metrics-table.html
The INNODB_METRICS table provides information about InnoDB performance and resource-related counters. For example, to enable the log module, metadata_table_handles_opened and metadata_table_handles_closed counters, enter the following line in the ...SET GLOBAL innodb_monitor_disable = [counter-name|module_name|pattern|all]; innodb_monitor_reset: Resets counter values to ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-truncate-table-reclaim-space.html
To reclaim operating system disk space when truncating an InnoDB table, the table must be stored in its own .ibd file. For a table to be stored in its own .ibd file, innodb_file_per_table must enabled when the table is created. Additionally, there ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-events-transactions-current-table.html
The table stores one row per thread showing the current status of the thread's most recent monitored transaction event, so there is no system variable for configuring the table size. Other tables that contain transaction event rows are logically ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-prepared-statements-instances-table.html
This is accessed through the MySQL C API and maps onto underlying server commands as shown in the following table. This is accessed using SQL statements and maps onto underlying server commands as shown in the following table. This table enables ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-wait-summary-tables.html
The Performance Schema maintains tables for collecting current and recent wait events, and aggregates that information in summary tables. Section 25.12.4, “Performance Schema Wait Event Tables” describes the events on which wait summaries are ...Example wait event summary information: mysql> SELECT * FROM performance_schema.events_waits_summary_global_by_event_name\G ...
https://dev.mysql.com/doc/refman/5.7/en/table-scan-avoidance.html
The output from EXPLAIN shows ALL in the type column when MySQL uses a full table scan to resolve a query. This usually happens under the following conditions: The table is so small that it is faster to perform a table scan than to bother with a ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-online-add-node-remarks.html
The ability to add new nodes online includes a means to reorganize NDBCLUSTER table data and indexes so that they are distributed across all data nodes, including the new ones, by means of the ALTER TABLE ... However, it is not possible to perform ...Table reorganization of both in-memory and Disk Data tables is ... This section provides general information about the ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-overview.html
However, if no columns are listed in the PARTITION BY KEY or PARTITION BY LINEAR KEY clause of the CREATE TABLE or ALTER TABLE statement used to create or modify a user-partitioned NDB table, then the table is not required to have an explicit ...The ... This section provides a conceptual overview of partitioning in MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-statistics-table.html
However, prefix lengths for index specifications in CREATE TABLE, ALTER TABLE, and CREATE INDEX statements are interpreted as number of characters for nonbinary string types (CHAR, VARCHAR, TEXT) and number of bytes for binary string types (BINARY, ...The STATISTICS table has these columns: TABLE_CATALOG The name of the catalog to which the table containing the index ...