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/mysql-installer-catalog-dashboard.html
MySQL Installer does not prompt you with the check box when the previous server upgrade was skipped or when the server was configured as a sandbox InnoDB Cluster. This section describes the MySQL Installer product catalog, the dashboard, and other ...
https://dev.mysql.com/doc/refman/5.7/en/mysqlbinlog-row-events.html
The following examples illustrate how mysqlbinlog displays row events that specify data modifications. These correspond to events with the WRITE_ROWS_EVENT, UPDATE_ROWS_EVENT, and DELETE_ROWS_EVENT type codes. The --base64-output=DECODE-ROWS and ...
https://dev.mysql.com/doc/refman/5.7/en/mysqlcheck.html
This is the case, for example, for InnoDB tables, which can be checked with CHECK TABLE, but not repaired with REPAIR TABLE. The mysqlcheck client performs table maintenance: It checks, repairs, optimizes, or analyzes tables. Each table is locked ...
https://dev.mysql.com/doc/refman/5.7/en/numeric-types.html
The BIT data type stores bit values and is supported for MyISAM, MEMORY, InnoDB, and NDB tables. These types include the exact numeric data types (INTEGER, SMALLINT, DECIMAL, and NUMERIC), as well as the approximate numeric data types (FLOAT, REAL, ...
https://dev.mysql.com/doc/refman/5.7/en/optimize-benchmarking.html
The two most important features to try with each workload are the MySQL query cache, and the adaptive hash index for InnoDB tables. To measure performance, consider the following factors: Whether you are measuring the speed of a single operation on ...
https://dev.mysql.com/doc/refman/5.7/en/optimize-blob.html
Do not use this technique when the entire table is compressed by InnoDB or MyISAM. When storing a large blob containing textual data, consider compressing it first. For a table with several columns, to reduce memory requirements for queries that do ...
https://dev.mysql.com/doc/refman/5.7/en/optimizer-hints.html
One means of control over optimizer strategies is to set the optimizer_switch system variable (see Section 8.9.2, “Switchable Optimizations”). Changes to this variable affect execution of all subsequent queries; to affect one query differently ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-memory-tables.html
Benchmark your application against equivalent InnoDB or MyISAM tables under a realistic workload, to confirm that any additional performance is worth the risk of losing data, or the overhead of copying data from a disk-based table at application ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-myisam.html
In MySQL, InnoDB is the default storage engine rather than MyISAM. The MyISAM storage engine performs best with read-mostly data or with low-concurrency operations, because table locks limit the ability to perform simultaneous updates.
https://dev.mysql.com/doc/refman/5.7/en/order-by-optimization.html
This section describes when MySQL can use an index to satisfy an ORDER BY clause, the filesort operation used when an index cannot be used, and execution plan information available from the optimizer about ORDER BY. An ORDER BY with and without ...