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/multiple-windows-servers.html
You can run multiple servers on Windows by starting them manually from the command line, each with appropriate operating parameters, or by installing several servers as Windows services and running them that way. General instructions for running ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb.html
InnoDB is the storage engine that MySQL customers typically use in production databases where reliability and concurrency are important. This section explains how to optimize database operations for InnoDB tables.
https://dev.mysql.com/doc/refman/5.7/en/replication-statements-master.html
Section 13.4.2, “SQL Statements for Controlling Replica Servers”, discusses statements for managing replica servers. In addition to the statements described here, the following SHOW statements are used with source servers in replication. SHOW ...
https://dev.mysql.com/doc/refman/5.7/en/selinux-mode.html
Permissive mode allows operations that are not permitted in enforcing mode and logs those operations to the SELinux audit log. In disabled mode, polices are not enforced, and contexts are not applied to system objects, which makes it difficult to ...
https://dev.mysql.com/doc/refman/5.7/en/sql-replication-statements.html
Replication can be controlled through the SQL interface using the statements described in this section. Statements are split into a group which controls replication source servers, a group which controls replica servers, and a group which can be ...
https://dev.mysql.com/doc/refman/5.7/en/subquery-optimization.html
Note A limitation on UPDATE and DELETE statements that use a subquery to modify a single table is that the optimizer does not use semijoin or materialization subquery optimizations. As a workaround, try rewriting them as multiple-table UPDATE and ...
https://dev.mysql.com/doc/refman/5.7/en/symbolic-links-to-databases.html
On Unix, the way to symlink a database is first to create a directory on some disk where you have free space and then to create a soft link to it from the MySQL data directory. $> mkdir /dr1/databases/test $> ln -s /dr1/databases/test ...
https://dev.mysql.com/doc/refman/5.7/en/sys-quote-identifier.html
Given a string argument, this function produces a quoted identifier suitable for inclusion in SQL statements. This is useful when a value to be used as an identifier is a reserved word or contains backtick (`) characters. Example mysql> SELECT ...
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/sys-ps-setup-reload-saved.html
This procedure disables binary logging during its execution by manipulating the session value of the sql_log_bin system variable. Reloads a Performance Schema configuration saved earlier within the same session using ps_setup_save(). That is a ...