PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 255.8Kb
Man Pages (Zip)
- 360.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/security-plugins.html
MySQL includes several plugins that implement security features: Plugins for authenticating attempts by clients to connect to MySQL Server. For general discussion of the authentication process, see Section 6.2.13, “Pluggable Authentication”.
https://dev.mysql.com/doc/refman/5.7/en/select-optimization.html
Queries, in the form of SELECT statements, perform all the lookup operations in the database. Tuning these statements is a top priority, whether to achieve sub-second response times for dynamic web pages, or to chop hours off the time to generate ...
https://dev.mysql.com/doc/refman/5.7/en/selinux-troubleshooting.html
Troubleshooting SELinux typically involves placing SELinux into permissive mode, rerunning problematic operations, checking for access denial messages in the SELinux audit log, and placing SELinux back into enforcing mode after problems are ...
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 ...