Search Results
https://dev.mysql.com/doc/ndbapi/en/ndb-ndb.html
(See Section 2.3.12, “The Ndb_cluster_connection Class”.) catalogName is an optional parameter providing a namespace for the tables and indexes created in any connection from the Ndb object. The optional schemaName provides an additional ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-table-maintenance.html
This section discusses how to use myisamchk to check or repair MyISAM tables (tables that have .MYD and .MYI files for storing data and indexes). For general myisamchk background, see Section 6.6.4, “myisamchk — MyISAM Table-Maintenance ...
https://dev.mysql.com/doc/refman/8.4/en/show-open-tables.html
SHOW OPEN TABLES [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW OPEN TABLES lists the non-TEMPORARY tables that are currently open in the table cache. The FROM clause, if present, restricts the tables shown to those present in the db_name ...The WHERE clause can be given to select rows using more general conditions, as discussed in Section 28.8, “Extensions to SHOW ...
https://dev.mysql.com/doc/refman/8.4/en/column-count-limit.html
Functional key parts (see Section 15.1.15, “CREATE INDEX Statement”) are implemented as hidden virtual generated stored columns, so each functional key part in a table index counts against the table total column limit. mysql> CREATE TABLE t (a ... This section describes limits on the number of columns in tables and the size of individual ...The storage ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-config-metric-tableconfiguration-category.html
Default Tmp Storage Engine Sets the default storage engine for temporary tables (created with CREATE TEMPORARY TABLE). Max Heap Table Size The maximum size to which user-created MEMORY tables are permitted to grow. Sync Frm Enabled If this variable ... Lists the Table Configuration configuration metrics and provides a brief description of ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-cmp-per-index-table.html
The INNODB_CMP_PER_INDEX and INNODB_CMP_PER_INDEX_RESET tables provide status information on operations related to compressed InnoDB tables and indexes, with separate statistics for each combination of database, table, and index, to help you ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-table-reference.html
The following table summarizes INFORMATION_SCHEMA InnoDB tables. For greater detail, see the individual table descriptions. Table 28.3 INFORMATION_SCHEMA InnoDB Tables Table Name Description INNODB_BUFFER_PAGE Pages in InnoDB buffer pool ...
https://dev.mysql.com/doc/internals/en/optimizer-constants-constant-tables.html
unique_not_null_column INT NOT NULL UNIQUE then this expression FROM Table1 ... These rules mean that a constant table has at most one row value. MySQL will evaluate a constant table in advance, to find out what that value is. Here's an example: ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-ft-being-deleted-table.html
The INNODB_FT_BEING_DELETED table provides a snapshot of the INNODB_FT_DELETED table; it is used only during an OPTIMIZE TABLE maintenance operation. When OPTIMIZE TABLE is run, the INNODB_FT_BEING_DELETED table is emptied, and DOC_ID values are ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-table-descriptions.html
Tables in the performance_schema database can be grouped as follows: Setup tables. The events_waits_current table contains the most recent event for each thread. Other similar tables contain current events at different levels of the event ...An ...