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-solutions-performance.html
Source 2 is the replica of Source 1 that provides the replication functionality to the remainder of the replicas in the replication structure. As the number of replicas connecting to a source increases, the load, although minimal, also increases, ...
https://dev.mysql.com/doc/refman/5.7/en/rewriter-query-rewrite-plugin.html
A loadable function named load_rewrite_rules() is used by the flush_rewrite_rules() stored procedure. MySQL supports query rewrite plugins that can examine and possibly modify SQL statements received by the server before the server executes them.
https://dev.mysql.com/doc/refman/5.7/en/row-subqueries.html
For information about how each operator works for row comparisons, see Section 12.4.2, “Comparison Functions and Operators”. Scalar or column subqueries return a single value or a column of values. A row subquery is a subquery variant that ...
https://dev.mysql.com/doc/refman/5.7/en/select-into.html
For the INTO var_list variant: var_list names a list of one or more variables, each of which can be a user-defined variable, stored procedure or function parameter, or stored program local variable. INTO form of SELECT enables a query result to be ...
https://dev.mysql.com/doc/refman/5.7/en/selinux-context-mysql-feature-ports.html
If ports used by MySQL features do not have the correct SELinux context, the features might not function correctly. If you enable certain MySQL features, you might need to set the SELinux TCP port context for additional ports used by those features. The following sections describe how to set port contexts for MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/semijoins.html
It must not be implicitly grouped (it must contain no aggregate functions). A semijoin is a preparation-time transformation that enables multiple execution strategies such as table pullout, duplicate weedout, first match, loose scan, and ...
https://dev.mysql.com/doc/refman/5.7/en/show-create-view.html
SHOW CREATE VIEW view_name This statement shows the CREATE VIEW statement that creates the named view. row *************************** View: v Create View: CREATE ALGORITHM=UNDEFINED DEFINER=`bob`@`localhost` SQL SECURITY DEFINER VIEW `v` AS select ...
https://dev.mysql.com/doc/refman/5.7/en/show-processlist.html
This is the same value displayed in the ID column of the INFORMATION_SCHEMA PROCESSLIST table, displayed in the PROCESSLIST_ID column of the Performance Schema threads table, and returned by the CONNECTION_ID() function within the thread. SHOW ...
https://dev.mysql.com/doc/refman/5.7/en/source-installation.html
Warning Building MySQL with nonstandard options may lead to reduced functionality, performance, or security. Building MySQL from the source code enables you to customize build parameters, compiler optimizations, and installation location. For a ...
https://dev.mysql.com/doc/refman/5.7/en/sql-compound-statements.html
END compound statement and other statements that can be used in the body of stored programs: Stored procedures and functions, triggers, and events. These objects are defined in terms of SQL code that is stored on the server for later invocation (see ...