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/group-replication-configuring-instances.html
Configuring group_replication_group_name tells the plugin that the group that it is joining, or creating, is named "aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa". In other words, any existing data which is on the server bootstrapping the group is what is ...
https://dev.mysql.com/doc/refman/5.7/en/select.html
SELECT [ALL | DISTINCT | DISTINCTROW ] [HIGH_PRIORITY] [STRAIGHT_JOIN] [SQL_SMALL_RESULT] [SQL_BIG_RESULT] [SQL_BUFFER_RESULT] [SQL_CACHE | SQL_NO_CACHE] [SQL_CALC_FOUND_ROWS] select_expr [, select_expr] ... SELECT supports explicit partition ...
https://dev.mysql.com/doc/refman/5.7/en/condition-filtering.html
In join processing, prefix rows are those rows passed from one table in a join to the next. In general, the optimizer attempts to put tables with low prefix counts early in the join order to keep the number of row combinations from increasing ...To ...
https://dev.mysql.com/doc/refman/5.7/en/index-hints.html
(For the general syntax for specifying tables in a SELECT statement, see Section 13.2.9.2, “JOIN Clause”.) The syntax for referring to an individual table, including index hints, looks like this: tbl_name [[AS] alias] [index_hint_list] ... Index ...
https://dev.mysql.com/doc/refman/5.7/en/multiple-tables.html
When combining (joining) information from multiple tables, you need to specify how records in one table can be matched to records in the other. An INNER JOIN permits rows from either table to appear in the result if and only if both tables meet the ... The pet table keeps track of which pets you ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-events-waits-current-table.html
The job of the Performance Schema instrumentation is to provide row count and accumulated execution time per table in the join. Assume a join query of the following form that is executed using a table join order of t1, t2, t3: SELECT ... Table ...
https://dev.mysql.com/doc/refman/5.7/en/derived-table-optimization.html
Consider a query that joins the result of a derived table to another table: If the optimizer processes that other table first and finds that it returns no rows, the join need not be carried out further and the optimizer can completely skip ...The ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-adding-instances.html
Start Group Replication and s2 starts the process of joining the group. Tip When Group Replication starts successfully and the server joins the group it checks the super_read_only variable. If the server should join the group as read-write instance, ... At this point, the group has one member in it, server s1, which has some data in ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-recovering-from-a-point-in-time.html
To synchronize the server joining the group with the donor up to a specific point in time, the server joining the group and donor make use of the MySQL Global Transaction Identifiers (GTIDs) mechanism. However, GTIDS only provide a means to realize ...View and View Changes To explain the concept of view change markers, it is important to understand what a view and a view change ...
https://dev.mysql.com/doc/refman/5.7/en/myisampack.html
--join=big_tbl_name, -j big_tbl_name Command-Line Format --join=big_tbl_name Type String Join all tables named on the command line into a single packed table big_tbl_name. The source tables are read for the join operation but not modified. After ...