PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/functions.html
Expressions can be used at several points in SQL statements, such as in the ORDER BY or HAVING clauses of SELECT statements, in the WHERE clause of a SELECT, DELETE, or UPDATE statement, or in SET statements. Rather than showing examples in this ...
https://dev.mysql.com/doc/refman/8.0/en/gis-data-formats.html
mysql> SELECT ST_X(Point(15, 20)); +---------------------+ | ST_X(POINT(15, 20)) | +---------------------+ | 15 | +---------------------+ mysql> SELECT ST_X(ST_GeomFromText('POINT(15 20)')); +---------------------------------------+ | ... Two ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-adding-instances.html
At this point, the group has one member in it, server s1, which has some data in it. It is now time to expand the group by adding the other two servers configured previously. 20.2.1.6.1 Adding a Second Instance In order to add a second instance, ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-change-primary.html
While the action runs, you can check its progress by issuing the statement shown here: mysql> SELECT event_name, work_completed, work_estimated -> FROM performance_schema.events_stages_current -> WHERE event_name LIKE "%stage/group_rpl%"\G ... This ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-distributed-recovery-connections.html
The joining member selects a suitable group member from this list to be its donor for distributed recovery, following the behaviors described in Section 20.5.4.4, “Fault Tolerance for Distributed Recovery”. If the joining member is not able to ... When a joining member connects to an online existing member for state transfer during distributed recovery, the joining member acts as a client on the connection and the existing member acts as a ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-restarting-group.html
You can get this by issuing the following statement: mysql> SELECT @@GLOBAL.GTID_EXECUTED The set of certified transactions on the group_replication_applier channel. Group Replication is designed to ensure that the database service is continuously ...
https://dev.mysql.com/doc/refman/8.0/en/index-extensions.html
EXPLAIN for the query produces this result: mysql> EXPLAIN SELECT COUNT(*) FROM t1 WHERE i1 = 3 AND d = '2000-01-01'\G *************************** 1. row *************************** id: 1 select_type: SIMPLE table: t1 type: ref possible_keys: ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-processlist-table.html
DB The default database for the thread, or NULL if none has been selected. For example, if a CALL statement executes a stored procedure that is executing a SELECT statement, the INFO value shows the SELECT statement. The following statements are ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-tables-table.html
In such cases, use SELECT COUNT(*) to obtain an accurate count. A more accurate method of obtaining this information in such cases is to query the INFORMATION_SCHEMA PARTITIONS table, as shown in this example: SELECT SUM(DATA_FREE) FROM ...The ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-deadlocks-handling.html
Use EXPLAIN SELECT to determine which indexes the MySQL server regards as the most appropriate for your queries. If you can afford to permit a SELECT to return data from an old snapshot, do not add a FOR UPDATE or FOR SHARE clause to it. This ...