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-howto-additionalslaves.html
Use the Performance Schema replication tables or issue SHOW SLAVE STATUS to confirm that the new replica has the correct settings when compared with the existing replica. You can add another replica to an existing replication configuration without ...
https://dev.mysql.com/doc/refman/5.7/en/replication-mode-change-online-enable-gtids.html
This can be checked using: SHOW STATUS LIKE 'ONGOING_ANONYMOUS_TRANSACTION_COUNT'; Note On a replica, it is theoretically possible that this shows zero and then nonzero again. This is not a problem, it suffices that it shows zero once. This section ...
https://dev.mysql.com/doc/refman/5.7/en/replication-multi-source-start-replica.html
To verify that both channels have started and are operating correctly, you can issue SHOW SLAVE STATUS statements on the replica, for example: mysql> SHOW SLAVE STATUS FOR CHANNEL "source_1"\G mysql> SHOW SLAVE STATUS FOR CHANNEL "source_2"\G .
https://dev.mysql.com/doc/refman/5.7/en/resignal.html
RESIGNAL may change some or all information before passing it on. RESIGNAL is related to SIGNAL, but instead of originating a condition as SIGNAL does, RESIGNAL relays existing condition information, possibly after modifying it. RESIGNAL makes it ...
https://dev.mysql.com/doc/refman/5.7/en/semijoins.html
EXPLAIN output indicates the use of semijoin strategies as follows: Semijoined tables show up in the outer select. For extended EXPLAIN output, the text displayed by a following SHOW WARNINGS shows the rewritten query, which displays the semijoin ...
https://dev.mysql.com/doc/refman/5.7/en/set-variable.html
For example, the following two statements are identical in setting the session value of max_join_size to the current global value: SET @@SESSION.max_join_size = DEFAULT; SET @@SESSION.max_join_size = @@GLOBAL.max_join_size; To display system ...
https://dev.mysql.com/doc/refman/5.7/en/sha256-pluggable-authentication.html
The following table shows the plugin names on the server and client sides. The actual value differs from that shown here, but should be nonempty: mysql> SHOW STATUS LIKE 'Rsa_public_key'\G *************************** 1. A client user who can connect ... MySQL provides two authentication plugins that implement SHA-256 hashing for user account passwords: sha256_password: Implements basic SHA-256 ...
https://dev.mysql.com/doc/refman/5.7/en/spatial-geojson-functions.html
This example shows the parsing result for a simple GeoJSON object: mysql> SET @json = '{ "type": "Point", "coordinates": [102.0, 0.0]}'; mysql> SELECT ST_AsText(ST_GeomFromGeoJSON(@json)); +--------------------------------------+ | ... This section ...
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/using-explain.html
For SELECT statements, EXPLAIN produces additional execution plan information that can be displayed using SHOW WARNINGS. EXPLAIN tbl_name is synonymous with DESCRIBE tbl_name and SHOW COLUMNS FROM tbl_name. For more information, see Section 13.8.1, ... The EXPLAIN statement provides information about how MySQL executes statements: EXPLAIN works with SELECT, DELETE, INSERT, REPLACE, and UPDATE ...