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/mysqld-multi.html
mysqld_multi is designed to manage several mysqld processes that listen for connections on different Unix socket files and TCP/IP ports. It can start or stop servers, or report their current status. Note For some Linux platforms, MySQL installation ...
https://dev.mysql.com/doc/refman/5.7/en/mysqldump-copying-to-other-server.html
On Server 2: $> mysql < dump.sql Use of --databases with the mysqldump command line causes the dump file to include CREATE DATABASE and USE statements that create the database if it does exist and make it the default database for the reloaded data.
https://dev.mysql.com/doc/refman/5.7/en/native-pluggable-authentication.html
Installing Native Pluggable Authentication The mysql_native_password plugin exists in server and client forms: The server-side plugin is built into the server, need not be loaded explicitly, and cannot be disabled by unloading it. MySQL includes ...
https://dev.mysql.com/doc/refman/5.7/en/ndb-restore-to-different-version.html
21.5.24.1.1 Restoring an NDB backup to a previous version of NDB Cluster You may encounter issues when restoring a backup taken from a later version of NDB Cluster to a previous one, due to the use of features which do not exist in the earlier ...
https://dev.mysql.com/doc/refman/5.7/en/old-native-pluggable-authentication.html
Installing Old Native Pluggable Authentication The mysql_old_password plugin exists in server and client forms: The server-side plugin is built into the server, need not be loaded explicitly, and cannot be disabled by unloading it. MySQL includes ...
https://dev.mysql.com/doc/refman/5.7/en/optimize-overview.html
Typical users aim to get the best database performance out of their existing software and hardware configurations. Database performance depends on several factors at the database level, such as tables, queries, and configuration settings. These ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb-logging.html
For information about modifying an existing redo log file configuration, see Changing the Number or Size of InnoDB Redo Log Files. Consider the following guidelines for optimizing redo logging: Make your redo log files big, even as big as the ...
https://dev.mysql.com/doc/refman/5.7/en/outer-join-optimization.html
MySQL implements an A LEFT JOIN B join_specification as follows: Table B is set to depend on table A and all tables on which A depends. Table A is set to depend on all tables (except B) that are used in the LEFT JOIN condition. The LEFT JOIN ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-info.html
This section discusses obtaining information about existing partitions, which can be done in a number of ways. Methods of obtaining such information include the following: Using the SHOW CREATE TABLE statement to view the partitioning clauses used ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-limitations-partitioning-keys-unique-keys.html
These rules also apply to existing nonpartitioned tables that you wish to partition using ALTER TABLE ... This section discusses the relationship of partitioning keys with primary keys and unique keys. The rule governing this relationship can be ...