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/string-comparison-functions.html
mysql> SELECT STRCMP('text', 'text2'); -> -1 mysql> SELECT STRCMP('text2', 'text'); -> 1 mysql> SELECT STRCMP('text', 'text'); -> 0 STRCMP() performs the comparison using the collation of the arguments. Table 12.13 String Comparison Functions and ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndb-transporter-errors.html
This section lists error codes, names, and messages that are written to the cluster log in the event of transporter errors. 0x00 TE_NO_ERROR No error 0x01 TE_ERROR_CLOSING_SOCKET Error found during closing of socket 0x02 ...
https://dev.mysql.com/doc/refman/5.7/en/mysqld-safe.html
If the option is given as --malloc-lib=/path/to/some/library, that full path is added to the beginning of the LD_PRELOAD value. If the full path points to a nonexistent or unreadable file, mysqld_safe aborts with an error. To use a specific tcmalloc ... mysqld_safe is the recommended way to start a mysqld server on ...
https://dev.mysql.com/doc/refman/5.7/en/show-processlist.html
SHOW [FULL] PROCESSLIST The MySQL process list indicates the operations currently being performed by the set of threads executing within the server. Without the FULL keyword, SHOW PROCESSLIST displays only the first 100 characters of each statement ...For a comparison of this statement with other sources, see Sources of Process ...
https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html
Setting the SQL Mode The default SQL mode in MySQL 5.7 includes these modes: ONLY_FULL_GROUP_BY, STRICT_TRANS_TABLES, NO_ZERO_IN_DATE, NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, NO_AUTO_CREATE_USER, and NO_ENGINE_SUBSTITUTION. These modes were added ... The MySQL server can operate in different SQL modes, and can apply these modes differently for different clients, depending on the value of the sql_mode system ...
https://dev.mysql.com/doc/refman/5.7/en/subquery-optimization-with-exists.html
This fallback strategy is always the same: Do a full table scan. In EXPLAIN output, the fallback shows up as Full scan on NULL key in the Extra column: mysql> EXPLAIN SELECT t1.col1, t1.col1 IN (SELECT t2.key1 FROM t2 WHERE t2.col2=t1.col2) FROM ...
https://dev.mysql.com/doc/refman/5.7/en/sys-diagnostics.html
Be careful with the medium setting and especially the full setting, which has a large performance impact. Use of the medium or full setting requires the SUPER privilege. Creates a report of the current server status for diagnostic purposes. This ...
https://dev.mysql.com/doc/refman/5.7/en/check-table.html
Column Value Table The table name Op Always check Msg_type status, error, info, note, or warning Msg_text An informational message The statement might produce many rows of information for each checked table. The last row has a Msg_type value of ...
https://dev.mysql.com/doc/refman/5.7/en/index-merge-optimization.html
If all columns used in the query are covered by the used indexes, full table rows are not retrieved (EXPLAIN output contains Using index in Extra field in this case). Here is an example of such a query: SELECT COUNT(*) FROM t1 WHERE key1 = 1 AND ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-statement-summary-tables.html
(The DIGEST_TEXT column contains the corresponding normalized statement digest text, but is neither a grouping nor a summary column.) The maximum number of rows in the table is autosized at server startup. If no row has the digest value for the ...