Search Results
https://dev.mysql.com/doc/refman/8.4/en/do.html
In most respects, DO is shorthand for SELECT expr, ..., but has the advantage that it is slightly faster when you do not care about the result. It cannot be used in all cases where SELECT can be used. DO is useful primarily with functions that have ...
https://dev.mysql.com/doc/refman/8.4/en/example-maximum-row.html
Task: Find the number, dealer, and price of the most expensive article.
https://dev.mysql.com/doc/refman/8.4/en/faqs-mysql-cluster.html
There is no user-facing mechanism for influencing this selection, which is completely automatic; the fact that it is automatic is a key part of NDB Cluster's internal architecture. However, it also means that queries that could otherwise use range ... In the following section, we answer questions that are frequently asked about MySQL NDB Cluster and the NDB storage ...
https://dev.mysql.com/doc/refman/8.4/en/flush.html
This operation has no effect on tables used for the general query log (see Section 7.4.1, “Selecting General Query Log and Slow Query Log Output Destinations”). This operation has no effect on tables used for the slow query log (see Section ...| ...
https://dev.mysql.com/doc/refman/8.4/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.4/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.4/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.4/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.4/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.4/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 ...