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/replication-setup-replicas.html
For a full list of options, and information about the maximum permissible length for the string-valued options, see Section 13.4.2.1, “CHANGE MASTER TO Statement”. The database updates are automatically propagated to the replicas: $> mysql -h ...
https://dev.mysql.com/doc/refman/5.7/en/replication-solutions-performance.html
Also, as each replica must receive a full copy of the source's binary log, the network load on the source may also increase and create a bottleneck. As the number of replicas connecting to a source increases, the load, although minimal, also ...
https://dev.mysql.com/doc/refman/5.7/en/select-optimization.html
Minimize the number of full table scans in your queries, particularly for big tables. 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 ...
https://dev.mysql.com/doc/refman/5.7/en/server-configuration.html
The MySQL server, mysqld, has many command options and system variables that can be set at startup to configure its operation. To determine the default command option and system variable values used by the server, execute this command: $> mysqld ...
https://dev.mysql.com/doc/refman/5.7/en/show-profile.html
If LIMIT is given, OFFSET offset may be added to begin the output offset rows into the full set of rows. Note The SHOW PROFILE and SHOW PROFILES statements are deprecated; expect them to be removed in a future MySQL release. Use the Performance ...
https://dev.mysql.com/doc/refman/5.7/en/solaris-installation-pkg.html
The installation package enables you to install the runtime libraries only instead of the full Oracle Developer Studio; see instructions in Installing Only the Runtime Libraries on Oracle Solaris 11. You can install MySQL on Solaris using a binary ...
https://dev.mysql.com/doc/refman/5.7/en/solaris-installation.html
The installation package enables you to install the runtime libraries only instead of the full Oracle Developer Studio; see instructions in Installing Only the Runtime Libraries on Oracle Solaris 11. Note MySQL 5.7 supports Solaris 11 (Update 3 and ...
https://dev.mysql.com/doc/refman/5.7/en/sys-create-synonym-db.html
Given a schema name, this procedure creates a synonym schema containing views that refer to all the tables and views in the original schema. This can be used, for example, to create a shorter name by which to refer to a schema with a long name ...
https://dev.mysql.com/doc/refman/5.7/en/sys-host-summary-by-statement-latency.html
full_scans The total number of full table scans by statements for the host. The host_summary_by_statement_latency and x$host_summary_by_statement_latency views have these columns: host The host from which the client connected. Rows for which the ...
https://dev.mysql.com/doc/refman/5.7/en/sys-host-summary-by-statement-type.html
full_scans The total number of full table scans by occurrences of the statement event for the host. These views summarize informaion about statements executed, grouped by host and statement type. By default, rows are sorted by host and descending ...