PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/slow-query-log.html
Note If you specify the TABLE log destination, see Log Tables and “Too many open files” Errors. Note that if row-based replication is in use (binlog_format=ROW), these system variables have no effect. The slow query log consists of SQL ...
https://dev.mysql.com/doc/refman/8.0/en/solaris-installation-pkg.html
Note MySQL 5.7 has a dependency on the Oracle Developer Studio Runtime Libraries; but this does not apply to MySQL 8.0. The typical upgrade sequence is therefore: $> mysqladmin shutdown $> pkgrm mysql $> pkgadd -d mysql-8.0.46-solaris11-x86_64.pkg ... You can install MySQL on Solaris using a binary package of the native Solaris PKG format instead of the binary tarball ...
https://dev.mysql.com/doc/refman/8.0/en/string-comparison-functions.html
Note MySQL uses C escape syntax in strings (for example, \n to represent the newline character). Note Aggregate queries involving NOT LIKE comparisons with columns containing NULL may yield unexpected results. Table 14.13 String Comparison ...
https://dev.mysql.com/doc/refman/8.0/en/string-functions.html
mysql> SELECT LENGTH('text'); -> 4 Note The Length() OpenGIS spatial function is named ST_Length() in MySQL. mysql> SELECT SOUNDEX('Hello'); -> 'H400' mysql> SELECT SOUNDEX('Quadratically'); -> 'Q36324' Note This function implements the original ...
https://dev.mysql.com/doc/refman/8.0/en/string-type-syntax.html
Note Trailing spaces are removed when CHAR values are retrieved unless the PAD_CHAR_TO_FULL_LENGTH SQL mode is enabled. Note MySQL follows the standard SQL specification, and does not remove trailing spaces from VARCHAR values. The string data ...
https://dev.mysql.com/doc/refman/8.0/en/subquery-optimization-with-exists.html
AND trigcond(oe_N=ie_N) ) Each trigcond(X) is a special function that evaluates to the following values: X when the “linked” outer expression oe_i is not NULL TRUE when the “linked” outer expression oe_i is NULL Note Trigger functions are ...
https://dev.mysql.com/doc/refman/8.0/en/sys-schema-prerequisites.html
Before using the sys schema, the prerequisites described in this section must be satisfied. Because the sys schema provides an alternative means of accessing the Performance Schema, the Performance Schema must be enabled for the sys schema to work.
https://dev.mysql.com/doc/refman/8.0/en/system-schema.html
Note If MySQL is upgraded from an older version but the grant tables have not been upgraded from MyISAM to InnoDB, the server considers them read only and account-management statements produce an error. Note Like the mysql.func system table, the ...
https://dev.mysql.com/doc/refman/8.0/en/test-pluggable-authentication.html
Note This plugin is intended for testing and development purposes, and is not for use in production environments or on servers that are exposed to public networks. You can look in the server error log for a message indicating whether authentication ... MySQL includes a test plugin that checks account credentials and logs success or failure to the server error ...
https://dev.mysql.com/doc/refman/8.0/en/upgrade-before-you-begin.html
Review the Release Notes for information about fixes, changes, and new features. Note For supported Linux distributions, the preferred method for upgrading package-based installations is to use the MySQL software repositories (MySQL Yum Repository, ...The backup should include the mysql system database, which contains the MySQL data dictionary tables and system ...