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/innodb-statistics-estimation.html
Unnecessary full table scans for such tables can be a substantial performance issue. See Section 8.2.1.20, “Avoiding Full Table Scans” for tips on tuning such queries. Optimizer statistics are not persisted to disk when ...
https://dev.mysql.com/doc/refman/5.7/en/myisamchk-table-info.html
For packed numbers, this should always be the full length of the column. For strings, it may be shorter than the full length of the indexed column, because you can index a prefix of a string column. To obtain a description of a MyISAM table or ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-installer.html
An internet connection is required to download a manifest containing metadata for the latest MySQL products that are not part of a full bundle. Full or Current Bundle: Bundles all of the MySQL products for Windows (including the MySQL server).
https://dev.mysql.com/doc/refman/5.7/en/MySQLInstallerConsole.html
If pre-release products are available, both GA and pre-release products are installed when the value of the --type option value is Client or Full. The setup type can be one of the following: Server: Installs a single MySQL server Client: Installs ...
https://dev.mysql.com/doc/refman/5.7/en/nested-loop-joins.html
MySQL join buffering has these characteristics: Join buffering can be used when the join is of type ALL or index (in other words, when no possible keys can be used, and a full scan is done, of either the data or index rows, respectively), or range.
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-event-tables.html
When the history tables become full, old events are discarded as new events are added. For _history_long, when the table becomes full, the oldest row is discarded when a new row is added, regardless of which thread generated either row. For wait, ...
https://dev.mysql.com/doc/refman/5.7/en/program-variables.html
Both set the size of the server's key buffer to 512MB: [mysqld] key_buffer_size=512M [mysqld] key-buffer-size=512M In older versions of MySQL, program options could be specified in full or as any unambiguous prefix. In MySQL 5.7, option prefixes are ... Many MySQL programs have internal variables that can be set at runtime using the SET ...
https://dev.mysql.com/doc/refman/5.7/en/recovery-from-backups.html
To recover, first we restore the last full backup we have (the one from Sunday 1 p.m.). The full backup file is just a set of SQL statements, so restoring it is very easy: $> mysql < backup_sunday_1_PM.sql At this point, the data is restored to its ... Now, suppose that we have a catastrophic unexpected exit on Wednesday at 8 ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-variables.html
However, when mysqlbinlog parses a SET @@sql_mode = mode statement, the full mode value, including NO_DIR_IN_CREATE, is passed to the receiving server. sql_mode is also replicated except for the NO_DIR_IN_CREATE mode; the replica always preserves ...
https://dev.mysql.com/doc/refman/5.7/en/replication-mode-change-online-verify-transactions.html
If you use a circular replication topology where multiple servers may have write clients, perform step 2 for each source-replica connection, until you have completed the full circle. Repeat the whole process so that you do the full circle twice.