PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html
avoid_temporal_upgrade Command-Line Format --avoid-temporal-upgrade[={OFF|ON}] Deprecated Yes System Variable avoid_temporal_upgrade Scope Global Dynamic Yes Type Boolean Default Value OFF This variable controls whether ALTER TABLE implicitly ...
https://dev.mysql.com/doc/refman/5.7/en/upgrading-from-previous-series.html
System Table Changes Incompatible change: The Password column of the mysql.user system table was removed in MySQL 5.7.6. All credentials are stored in the authentication_string column, including those formerly stored in the Password column. If ...
https://dev.mysql.com/doc/refman/5.7/en/converting-tables-to-innodb.html
File-per-table tablespaces also support the Barracuda file format and associated features such as table compression, efficient off-page storage for long variable-length columns, and large index prefixes. Create an empty InnoDB table with identical ... If you have MyISAM tables that you want to convert to InnoDB for better reliability and scalability, review the following guidelines and tips before ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-persistent-stats.html
If innodb_stats_auto_recalc is disabled, you can ensure the accuracy of optimizer statistics by executing the ANALYZE TABLE statement after making substantial changes to indexed columns. When an index is added to an existing table, or when a column ... The persistent optimizer statistics feature improves plan stability by storing statistics to disk and making them persistent across server restarts so that the optimizer is more likely to make consistent choices each time for a given ...
https://dev.mysql.com/doc/refman/5.7/en/mysqldump.html
--allow-keywords Command-Line Format --allow-keywords Permit creation of column names that are keywords. This works by prefixing each column name with the table name. --complete-insert, -c Command-Line Format --complete-insert Use complete INSERT ...
https://dev.mysql.com/doc/refman/5.7/en/information-functions.html
Although the expression can be a subquery, it must return a single column and at most a single row. For example, BENCHMARK(10, (SELECT * FROM t)) fails if the table t has more than one column or more than one row. The value returned by ...It may be ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-file-summary-tables.html
COUNT_MISC, SUM_TIMER_MISC, MIN_TIMER_MISC, AVG_TIMER_MISC, MAX_TIMER_MISC These columns aggregate all other I/O operations, including CREATE, DELETE, OPEN, CLOSE, STREAM_OPEN, STREAM_CLOSE, SEEK, TELL, FLUSH, STAT, FSTAT, CHSIZE, RENAME, and SYNC.
https://dev.mysql.com/doc/refman/5.7/en/explain-output.html
When all tables are processed, MySQL outputs the selected columns and backtracks through the table list until a table is found for which there are more matching rows. EXPLAIN Output Columns EXPLAIN Join Types EXPLAIN Extra Information EXPLAIN Output ... The EXPLAIN statement provides information about how MySQL executes ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-row-format.html
The B-tree index that represents an entire table is known as the clustered index, which is organized according to the primary key columns. The nodes of a clustered index data structure contain the values of all columns in the row. The nodes of a ...
https://dev.mysql.com/doc/refman/5.7/en/rewriter-query-rewrite-plugin-usage.html
When the plugin reads each rule from the rules table, it computes a normalized (statement digest) form from the pattern and a digest hash value, and uses them to update the normalized_pattern and pattern_digest columns: mysql> SELECT * FROM ... To ...