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/cost-model.html
To generate execution plans, the optimizer uses a cost model that is based on estimates of the cost of various operations that occur during query execution. DBAs can use this column to provide information about why a cost estimate row stores a ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-table-reference.html
The following table summarizes all available INFORMATION_SCHEMA tables. For greater detail, see the individual table descriptions. Table 24.1 INFORMATION_SCHEMA Tables Table Name Description Deprecated CHARACTER_SETS Available character sets ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-index-types.html
If a table has no PRIMARY KEY or suitable UNIQUE index, InnoDB generates a hidden clustered index named GEN_CLUST_INDEX on a synthetic column that contains row ID values. If there is no logical unique and non-null column or set of columns to use a ... Each InnoDB table has a special index called the clustered index that stores row ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-timing.html
The columns have these meanings: The TIMER_NAME column shows the names of the available timers. The timers in setup_timers that you can use are those that do not have NULL in the other columns. Processor cycle rate might change, such as when a ...
https://dev.mysql.com/doc/refman/5.7/en/view-restrictions.html
However, a view that is processed with the temptable algorithm is unable to take advantage of indexes on its underlying tables (although indexes can be used during generation of the temporary tables). SHOW CREATE VIEW displays view definitions using ... The maximum number of tables that can be referenced in the definition of a view is ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-cjk.html
You can obtain this information for a column column_name in the table table_name using the following query: SELECT HEX(column_name) FROM table_name; 3F is the encoding for the ? character; this means that ? is the character actually stored in the ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-range.html
While the examples work as shown for purposes of the present discussion, you should keep in mind that tables are extremely likely in practice to have primary keys, unique keys, or both, and that allowable choices for partitioning columns depend on ... A table that is partitioned by range is partitioned in such a way that each partition contains rows for which the partitioning expression value lies within a given ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-ft-index-table-table.html
This value might reflect the value of an ID column that you defined for the underlying table, or it can be a sequence value generated by InnoDB when the table contains no suitable column. The INNODB_FT_INDEX_TABLE table has these columns: WORD A ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-tables-table.html
The INNODB_SYS_TABLES table has these columns: TABLE_ID An identifier for the InnoDB table. The number reported includes three hidden columns that are created by InnoDB (DB_ROW_ID, DB_TRX_ID, and DB_ROLL_PTR). Use the INFORMATION_SCHEMA COLUMNS ...
https://dev.mysql.com/doc/refman/5.7/en/optimize-table.html
After doing substantial insert, update, or delete operations on columns that are part of a FULLTEXT index in an InnoDB table. After deleting a large part of a MyISAM or ARCHIVE table, or making many changes to a MyISAM or ARCHIVE table with ...