PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/permission-optimization.html
Simplifying the privileges established by GRANT statements enables MySQL to reduce permission-checking overhead when clients execute statements. The more complex your privilege setup, the more overhead applies to all SQL statements. For example, if ...
https://dev.mysql.com/doc/refman/8.0/en/programs-client.html
This section describes client programs that connect to the MySQL server.
https://dev.mysql.com/doc/refman/8.0/en/programs-installation.html
The programs in this section are used when installing or upgrading MySQL.
https://dev.mysql.com/doc/refman/8.0/en/programs-server.html
This section describes mysqld, the MySQL server, and several programs that are used to start the server.
https://dev.mysql.com/doc/refman/8.0/en/replication-configuration.html
This section describes how to configure the different types of replication available in MySQL and includes the setup and configuration required for a replication environment, including step-by-step instructions for creating a new replication ...For ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-charset.html
The following applies to replication between MySQL servers that use different character sets: If the source has databases with a character set different from the global character_set_server value, you should design your CREATE TABLE statements so ...A good workaround is to state the character set and collation explicitly in CREATE TABLE ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-checksum-table.html
The storage format is not guaranteed to remain the same between MySQL versions, so the checksum value might change following an upgrade. CHECKSUM TABLE returns a checksum that is calculated row by row, using a method that depends on the table row ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-current-user.html
In some cases, such as statements that change passwords, the function reference is expanded before it is written to the binary log, so that the statement includes the user name. For all other cases, the name of the current user on the source is ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-directory.html
This can cause problems if no corresponding directory exists in the replica host file system or if it exists but is not accessible to the replica MySQL server. If a DATA DIRECTORY or INDEX DIRECTORY table option is used in a CREATE TABLE statement ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-floatvalues.html
Comparisons of floating-point values might yield different results on source and replica servers due to differences in computer architecture, the compiler used to build MySQL, and so forth. With statement-based replication, values are converted ...