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/group-replication-deploying-in-single-primary-mode.html
This section explains how to create a replication group with three MySQL Server instances, each running on a different host machine. Figure 20.7 Group Architecture This tutorial explains how to get and deploy MySQL Server with the Group Replication ... Each of the MySQL server instances in a group can run on an independent physical host machine, which is the recommended way to deploy Group ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-deploying-locally.html
This section explains how to create a replication group with three MySQL Server instances on one physical machine. The most common way to deploy Group Replication is using multiple server instances, to provide high availability. It is also possible ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-network-partitioning.html
The following sections explain what to do if the system partitions in such a way that no quorum is automatically achieved by the servers in the group. In this particular case, the group membership list needs to be reset to allow the system to ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-upgrading-member.html
This section explains the steps required for upgrading a member of a group. The process of upgrading a member of a group is common to all methods and is explained first. This procedure is part of the methods described at Section 20.8.3.3, “Group ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-introduction.html
To check the efficiency of a query, you can use EXPLAIN. For information about using EXPLAIN output to tune INFORMATION_SCHEMA queries, see Section 10.2.3, “Optimizing INFORMATION_SCHEMA Queries”. INFORMATION_SCHEMA provides access to database ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-deadlocks-handling.html
It explains how to organize database operations to minimize deadlocks and the subsequent error handling required in applications. Use EXPLAIN SELECT to determine which indexes the MySQL server regards as the most appropriate for your queries. This ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-tips.html
As of MySQL 8.0.13, safe-updates mode also includes these behaviors: EXPLAIN with UPDATE and DELETE statements does not produce safe-updates errors. This enables use of EXPLAIN plus SHOW WARNINGS to see why an index is not used, which can be helpful ... This section provides information about techniques for more effective use of mysql and about mysql operational ...
https://dev.mysql.com/doc/refman/8.0/en/no-matching-rows.html
If you have a complicated query that uses many tables but that returns no rows, you should use the following procedure to find out what is wrong: Test the query with EXPLAIN to check whether you can find something that is obviously wrong. Select ...
https://dev.mysql.com/doc/refman/8.0/en/optimizer-statistics.html
A different method of disabling histogram statistics is to turn off the condition_fanout_filter flag of the optimizer_switch system variable (although this may disable other optimizations as well): SET optimizer_switch='condition_fanout_filter=off'; ... The column_statistics data dictionary table stores histogram statistics about column values, for use by the optimizer in constructing query execution ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-events-statements-current-table.html
For additional information, see the description of the Extra column from EXPLAIN output for the Range checked for each record value in Section 10.8.2, “EXPLAIN Output Format”. The table stores one row per thread showing the current status of the ...