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/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/create-table-ndb-comment-options.html
NDB_COLUMN Options NDB_TABLE Options It is possible to set a number of options specific to NDB Cluster in the table comment or column comments of an NDB table. NDB_COLUMN can be used in a column comment to set the size of the blob parts table ...
https://dev.mysql.com/doc/refman/5.7/en/union.html
Selected columns listed in corresponding positions of each SELECT statement should have the same data type. For example, the first column selected by the first statement should have the same type as the first column selected by the other statements.
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 ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-limitations-locking.html
However, if an AUTO_INCREMENT value is generated for any partitioning column then all partitions are locked. An UPDATE prunes locks only for tables on which no partitioning columns are updated. ON DUPLICATE KEY UPDATE is pruned as long as no ...In ...
https://dev.mysql.com/doc/refman/5.7/en/data-size.html
You can get better performance for a table and minimize storage space by using the techniques listed here: Table Columns Row Format Indexes Joins Normalization Table Columns Use the most efficient (smallest) data types possible. MEDIUMINT is often a ... Design your tables to minimize their space on the ...
https://dev.mysql.com/doc/refman/5.7/en/creating-tables.html
Storing birth date rather than age has other advantages, too: You can use the database for tasks such as generating reminders for upcoming pet birthdays. Use a CREATE TABLE statement to specify the layout of your table: mysql> CREATE TABLE pet (name ...You want a table that contains a record for each of your ...