PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/slow-query-log.html
The server writes less information to the slow query log if you use the --log-short-format option. Note that if row-based replication is in use (binlog_format=ROW), these system variables have no effect. Queries are only added to the replica's slow ... The slow query log consists of SQL statements that take more than long_query_time seconds to execute and require at least min_examined_row_limit rows to be ...
https://dev.mysql.com/doc/refman/8.0/en/storage-engines.html
For information about features offered in commercial MySQL Server binaries, see MySQL Editions, on the MySQL website. For more information about InnoDB, see Chapter 17, The InnoDB Storage Engine. CSV tables let you import or dump data in CSV format, ... Storage engines are MySQL components that handle the SQL operations for different table ...
https://dev.mysql.com/doc/refman/8.0/en/table-size-limit.html
For up-to-date information operating system file size limits, refer to the documentation specific to your operating system. For example, for tables that use the dynamic storage format, a value of 4 permits tables up to 4GB; a value of 6 permits ...
https://dev.mysql.com/doc/refman/8.0/en/upgrading-from-previous-series.html
Data Dictionary Changes caching_sha2_password as the Preferred Authentication Plugin Configuration Changes Server Changes InnoDB Changes SQL Changes Changed Server Defaults Valid Performance Regressions Data Dictionary Changes MySQL Server 8.0 ...
https://dev.mysql.com/doc/refman/8.0/en/which-version.html
When preparing to install MySQL, decide which version and distribution format (binary or source) to use. After choosing which MySQL version to install, decide which distribution format to install for your operating system. Binary distributions are ...First, decide whether to install from a bugfix series like MySQL 8.4, or use an innovation release like MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/windows-choosing-package.html
For MySQL 8.0, there are multiple installation package formats to choose from when installing MySQL on Windows. The package formats described in this section are: MySQL Installer MySQL noinstall ZIP Archives MySQL Docker Images Program Database ...
https://dev.mysql.com/doc/refman/8.0/en/account-names.html
This means that you should specify account host values in the same format used by DNS. To avoid problems like these, it is advisable to check the format in which your DNS returns host names and addresses. MySQL account names consist of a user name ...
https://dev.mysql.com/doc/refman/8.0/en/charset-repertoire.html
The ASCII range is a subset of UNICODE range, so a string with ASCII repertoire can be converted safely without loss of information to the character set of any string with UNICODE repertoire. The repertoire of a character set is the collection of ...
https://dev.mysql.com/doc/refman/8.0/en/checksum-table.html
For example, the storage format for temporal types such as TIME, DATETIME, and TIMESTAMP changed in MySQL 5.6 prior to MySQL 5.6.5, so if a 5.5 table is upgraded to MySQL 5.6, the checksum value may change. [QUICK | EXTENDED] CHECKSUM TABLE reports ...
https://dev.mysql.com/doc/refman/8.0/en/comments.html
(It does this to determine statement boundaries within a multiple-statement input line.) For information about differences between the server and mysql client parsers, see Section 6.5.1.6, “mysql Client Tips”. If this format is used to comment ... MySQL Server supports three comment styles: From a # character to the end of the ...