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/uninstall-plugin.html
If you are uninstalling a plugin with no intention of reinstalling it later and you care about the table contents, you should dump the table with mysqldump and remove the WITH PARSER clause from the dumped CREATE TABLE statement so that you can ...
https://dev.mysql.com/doc/refman/5.7/en/using-stack-trace.html
If that does not help you find out why mysqld died, you should create a bug report and include the output from the preceding command with the bug report. On some operating systems, the error log contains a stack trace if mysqld dies unexpectedly.
https://dev.mysql.com/doc/refman/5.7/en/verifying-index-usage.html
Always check whether all your queries really use the indexes that you have created in the tables. Use the EXPLAIN statement, as described in Section 8.8.1, “Optimizing Queries with EXPLAIN”.
https://dev.mysql.com/doc/refman/5.7/en/where-optimization.html
If there is an ORDER BY clause and a different GROUP BY clause, or if the ORDER BY or GROUP BY contains columns from tables other than the first table in the join queue, a temporary table is created. This section discusses optimizations that can be ...
https://dev.mysql.com/doc/refman/5.7/en/while.html
Example: CREATE PROCEDURE dowhile() BEGIN DECLARE v1 INT DEFAULT 5; WHILE v1 > 0 DO ... [begin_label:] WHILE search_condition DO statement_list END WHILE [end_label] The statement list within a WHILE statement is repeated as long as the ...
https://dev.mysql.com/doc/refman/5.7/en/zlib-decompress.html
The zlib_decompress utility decompresses mysqlpump output that was created using ZLIB compression. Invoke zlib_decompress like this: zlib_decompress input_file output_file Example: mysqlpump --compress-output=ZLIB > dump.zlib zlib_decompress ...
https://dev.mysql.com/doc/refman/5.7/en/ansi-diff-comments.html
In this case, the generated statement looks like this: UPDATE account SET balance=balance--1 WHERE account_id=5752; balance--1 is valid standard SQL, but -- is interpreted as the start of a comment, and part of the expression is discarded. The ...
https://dev.mysql.com/doc/refman/5.7/en/condition-filtering.html
Condition filtering enables the optimizer to use other relevant conditions in the WHERE clause not taken into account by the access method, and thus improve its prefix row count estimates. It was not already taken into account by the access method.
https://dev.mysql.com/doc/refman/5.7/en/unix-signal-response.html
On Unix and Unix-like systems, a process can be the recipient of signals sent to it by the root system account or the system account that owns the process. This is like executing a SHUTDOWN statement without having to connect to the server (which ...Some command interpreters associate certain key sequences with signals, such as Control+C to send a SIGINT ...
https://dev.mysql.com/doc/refman/5.7/en/data-masking-function-reference.html
Table 6.35 MySQL Enterprise Data Masking and De-Identification Functions Name Description gen_blacklist() Perform dictionary term replacement gen_dictionary_drop() Remove dictionary from registry gen_dictionary_load() Load dictionary into registry ...