PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 255.5Kb
Man Pages (Zip)
- 360.4Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
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. For a comparison of this statement with other sources, see Sources of Process Information. If you ...
https://dev.mysql.com/doc/refman/5.7/en/statement-caching.html
For certain statements that a client might execute multiple times during a session, the server converts the statement to an internal structure and caches that structure to be used during execution. Caching enables the server to perform more ...
https://dev.mysql.com/doc/refman/5.7/en/stored-routines.html
A stored routine is a set of SQL statements that can be stored in the server. Once this has been done, clients don't need to keep reissuing the individual statements but can refer to the stored routine instead. If you are upgrading to MySQL 5.7 from ...
https://dev.mysql.com/doc/refman/5.7/en/subquery-optimization-with-exists.html
Certain optimizations are applicable to comparisons that use the IN (or =ANY) operator to test subquery results. This section discusses these optimizations, particularly with regard to the challenges that NULL values present. The last part of the ...
https://dev.mysql.com/doc/refman/5.7/en/sys-format-statement.html
Given a string (normally representing an SQL statement), reduces it to the length given by the statement_truncate_len configuration option, and returns the result. Otherwise, the middle part of the string is replaced by an ellipsis (...). This ...
https://dev.mysql.com/doc/refman/5.7/en/sys-statements-with-errors-or-warnings.html
These views display normalized statements that have produced errors or warnings. By default, rows are sorted by descending error and warning counts. The statements_with_errors_or_warnings and x$statements_with_errors_or_warnings views have these ...
https://dev.mysql.com/doc/refman/5.7/en/sys-statements-with-temp-tables.html
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 in-memory temporary tables used. The statements_with_temp_tables and ...
https://dev.mysql.com/doc/refman/5.7/en/too-many-connections.html
If clients encounter Too many connections errors when attempting to connect to the mysqld server, all available connections are in use by other clients. The permitted number of connections is controlled by the max_connections system variable. The ...
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. Some command interpreters associate certain key sequences with signals, such as Control+C to ...
https://dev.mysql.com/doc/refman/5.7/en/validate-password.html
The validate_password plugin serves to improve security by requiring account passwords and enabling strength testing of potential passwords. This plugin exposes a set of system variables that enable you to configure password policy. The ...