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/sys-statements-with-errors-or-warnings.html
db The default database for the statement, or NULL if there is none. These views display normalized statements that have produced errors or warnings. By default, rows are sorted by descending error and warning counts. The ...
https://dev.mysql.com/doc/refman/5.7/en/sys-statements-with-runtimes-in-95th-percentile.html
db The default database for the statement, or NULL if there is none. full_scan The total number of full table scans performed by occurrences of the statement. These views list statements with runtimes in the 95th percentile. The ...
https://dev.mysql.com/doc/refman/5.7/en/sys-statements-with-sorting.html
db The default database for the statement, or NULL if there is none. The statements_with_sorting and x$statements_with_sorting views have these columns: query The normalized statement string. total_latency The total wait time of timed occurrences of ...
https://dev.mysql.com/doc/refman/5.7/en/sys-statements-with-temp-tables.html
db The default database for the statement, or NULL if there is none. These views list normalized statements that have used temporary tables. By default, rows are sorted by descending number of on-disk temporary tables used and descending number of ...
https://dev.mysql.com/doc/refman/5.7/en/bit-type.html
For example, assigning a value of b'101' to a BIT(6) column is, in effect, the same as assigning b'000101'. The BIT data type is used to store bit values. If you assign a value to a BIT(M) column that is less than M bits long, the value is padded ...
https://dev.mysql.com/doc/refman/5.7/en/collation-diagnostics.html
For example, the following message results if a collation definition contains a <aaa> tag: [Warning] Buffered warning: Unknown LDML tag: 'charsets/charset/collation/rules/aaa' If collation initialization is not possible, the server reports an ...In ... The MySQL server generates diagnostics when it finds problems while parsing the Index.xml file: Unknown tags are written to the error ...
https://dev.mysql.com/doc/refman/5.7/en/compiler-characteristics.html
In some cases, the compiler used to build MySQL affects the features available for use. The notes in this section apply for binary distributions provided by Oracle Corporation or that you compile yourself from source. icc (Intel C++ Compiler) ...
https://dev.mysql.com/doc/refman/5.7/en/condition-handling-restrictions.html
For example, this statement is invalid: PREPARE stmt1 FROM 'SIGNAL SQLSTATE "02000"'; SQLSTATE values in class '04' are not treated specially. In standard SQL, the first condition relates to the SQLSTATE value returned for the previous SQL statement. SIGNAL, RESIGNAL, and GET DIAGNOSTICS are not permissible as prepared ...
https://dev.mysql.com/doc/refman/5.7/en/data-change-optimization.html
For inserting and updating large volumes of data (known in the industry as ETL, for “extract-transform-load”), sometimes you use other SQL statements or external commands, that mimic the effects of INSERT, UPDATE, and DELETE statements. This ...
https://dev.mysql.com/doc/refman/5.7/en/debugging-server.html
If mysqld does not want to start, verify that you have no my.cnf files that interfere with your setup! You can check your my.cnf arguments with mysqld --print-defaults and avoid using them by starting with mysqld --no-defaults .... It may be a good ... If you are using some functionality that is very new in MySQL, you can try to run mysqld with the --skip-new option (which disables all new, potentially unsafe ...