PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/replication-rules-table-options.html
The replica checks for and evaluates table options only if either of the following two conditions is true: No matching database options were found. One or more database options were found, and were evaluated to arrive at an “execute” condition ...
https://dev.mysql.com/doc/refman/5.7/en/rewriter-query-rewrite-plugin.html
MySQL supports query rewrite plugins that can examine and possibly modify SQL statements received by the server before the server executes them. MySQL distributions include a postparse query rewrite plugin named Rewriter and scripts for installing ...
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 ...