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-online-upgrade-combining-versions.html
However, while you are in the process of upgrading an online group, in order to maximize availability, you might need to have members with different MySQL Server versions running at the same time. At this point the member applies the policies for ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-single-primary-mode.html
The following diagram shows this process: Figure 20.4 New Primary Election When a new primary is chosen, it might have a backlog of changes that had been applied on the old primary but have not yet been applied on the new one. Because all members ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-summary.html
Read/write transactions commit only after they have been approved by the group. Note that if two transactions are bound to conflict more often than not, then it is a good practice to start them on the same server, where they have a chance to ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-understanding-consistency-guarantees.html
This means that as soon as the incoming traffic slows down or stops, all group members have the same data content. Since the group should behave as a single entity, it is reasonable to expect that writes on the primary are instantaneously available ... In terms of distributed consistency guarantees, either in normal or failure repair operations, Group Replication has always been an eventual consistency ...
https://dev.mysql.com/doc/refman/8.0/en/hexadecimal-literals.html
Hexadecimal literal values are written using X'val' or 0xval notation, where val contains hexadecimal digits (0..9, A..F). Lettercase of the digits and of any leading X does not matter. A leading 0x is case-sensitive and cannot be written as 0X.
https://dev.mysql.com/doc/refman/8.0/en/host-cache.html
Starting the server with --skip-host-cache does not prevent runtime changes to the value of host_cache_size, but such changes have no effect and the cache is not re-enabled even if host_cache_size is set larger than 0. The MySQL server maintains an ...
https://dev.mysql.com/doc/refman/8.0/en/identifier-case-sensitivity.html
If you are using MySQL on only one platform, you do not normally have to use a lower_case_table_names setting other than the default. For example, on Unix, you can have two different tables named my_table and MY_TABLE, but on Windows these two names ... In MySQL, databases correspond to directories within the data ...
https://dev.mysql.com/doc/refman/8.0/en/index.html
It may include documentation of features of MySQL versions that have not yet been released. For information about which versions have been released, see the MySQL 8.0 Release Notes. If you have any questions about the features included in your ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-introduction.html
In some cases (for example, the ROUTINE_DEFINITION column in the INFORMATION_SCHEMA ROUTINES table), users who have insufficient privileges see NULL. Some tables have different privilege requirements; for these, the requirements are mentioned in the ... INFORMATION_SCHEMA provides access to database metadata, information about the MySQL server such as the name of a database or table, the data type of a column, or access ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-processlist-table.html
Like the output from the SHOW PROCESSLIST statement, the PROCESSLIST table provides information about all threads, even those belonging to other users, if you have the PROCESS privilege. Otherwise (without the PROCESS privilege), nonanonymous users ... Important INFORMATION_SCHEMA.PROCESSLIST is deprecated and subject to removal in a future MySQL ...