PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.6Kb
Man Pages (Zip)
- 402.0Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-replication-asynchronous-connection-failover-managed-table.html
When you add a group member to the source list and define it as part of a managed group, the asynchronous connection failover mechanism updates the source list to keep it in line with membership changes, adding and removing group members ... This ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-replication-tables.html
By contrast, using the Performance Schema tables, information about replica status can be searched using general SELECT queries, including complex WHERE conditions, joins, and so forth. If needed, these values can be obtained from the process list ...This is similar to the information available from the SHOW REPLICA STATUS statement, but representation in table form is more accessible and has usability benefits: SHOW REPLICA STATUS output is useful for visual inspection, but not so much for programmatic ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-variables-info-table.html
The variables_info table shows, for each system variable, the source from which it was most recently set, and its range of values. VARIABLE_SOURCE The source from which the variable was most recently set: COMMAND_LINE The variable was set on the ...
https://dev.mysql.com/doc/refman/8.0/en/range-optimization.html
In MySQL 8.0, index dive skipping is possible for queries that satisfy all these conditions: The query is for a single table, not a join on multiple tables. For JSON output, rows_examined_per_scan and rows_produced_per_join do not appear, ... The ...
https://dev.mysql.com/doc/refman/8.0/en/replication-asynchronous-connection-failover.html
When you add a group member to the source list and define it as part of a managed group, the asynchronous connection failover mechanism updates the source list to keep it in line with membership changes, adding and removing group members ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options-source.html
In a Group Replication environment, view change log events, which are special transactions queued by each group member when a new member joins the group, are tagged with the server version of the group member queuing the transaction. This ensures ...
https://dev.mysql.com/doc/refman/8.0/en/start-group-replication.html
If super_read_only=ON is set and the member should join as a primary, super_read_only is set to OFF once Group Replication successfully starts. Otherwise, the server is not allowed to join a group as a secondary. While a member is rejoining a ...
https://dev.mysql.com/doc/refman/8.0/en/subquery-optimization-with-exists.html
Table-condition generator: If the subquery is a join of several tables, the triggered condition is checked as soon as possible. For multiple-table subqueries, execution of NULL IN (SELECT ...) is particularly slow because the join optimizer does not ... Certain optimizations are applicable to comparisons that use the IN (or =ANY) operator to test subquery ...
https://dev.mysql.com/doc/refman/8.0/en/table-cache.html
For example, for 200 concurrent running connections, specify a table cache size of at least 200 * N, where N is the maximum number of tables per join in any of the queries which you execute. This means the table needs to be opened twice if two ...
https://dev.mysql.com/doc/refman/8.0/en/values.html
VALUES is a DML statement introduced in MySQL 8.0.19 which returns a set of one or more rows as a table. In other words, it is a table value constructor which also functions as a standalone SQL statement. VALUES row_constructor_list [ORDER BY ...