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/replication-problems.html
If the preceding step does not work or does not apply, try to understand whether it would be safe to make the update manually (if needed) and then ignore the next statement from the source. If you are sure that the replica started out perfectly ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-read-only-instance.html
To enable read-only mode for an entire MySQL instance, specify the following configuration options at server startup: --innodb-read-only=1 If the instance is on read-only media such as a DVD or CD, or the /var directory is not writeable by all: ...
https://dev.mysql.com/doc/refman/8.0/en/charset-restrictions.html
However, you can perform IN BOOLEAN MODE searches on the column without an index. The REGEXP and RLIKE operators work in byte-wise fashion, so they are not multibyte safe and may produce unexpected results with multibyte character sets. Identifiers ...
https://dev.mysql.com/doc/refman/8.0/en/data-directory-initialization.html
(For upgrades to an existing installation, perform the upgrade procedure instead; see Chapter 3, Upgrading MySQL.) However, the command that initializes the data directory does not overwrite any existing mysql schema tables, so it is safe to run in ... After MySQL is installed, the data directory must be initialized, including the tables in the mysql system schema: For some MySQL installation methods, data directory initialization is automatic, as described in Section 2.9, “Postinstallation Setup and ...
https://dev.mysql.com/doc/refman/8.0/en/load-data-local-security.html
To avoid connecting to untrusted servers, clients can establish a secure connection and verify the server identity by connecting using the --ssl-mode=VERIFY_IDENTITY option and the appropriate CA certificate. The utilities handle the file transfer ... The LOAD DATA statement loads a data file into a ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-replication-tables.html
The replication_applier_status_by_worker table is nonempty only when the replica is operating in multithreaded mode. It refers to the master.info file used for the replica's source metadata repository, which has been superseded by the use of ...This ...
https://dev.mysql.com/doc/refman/8.0/en/internal-locking.html
FOR UPDATE statement for each group of rows expected to be modified, even if the data change statements come later in the transaction. Table-Level Locking MySQL uses table-level locking for MyISAM, MEMORY, and MERGE tables, permitting only one ...
https://dev.mysql.com/doc/refman/8.0/en/table-locking.html
But because only one session can write to a table at any one time, for best performance with these other storage engines, use them primarily for tables that are queried often and rarely inserted into or updated. During the update, all other sessions ... InnoDB tables use row-level locking so that multiple sessions and applications can read from and write to the same table simultaneously, without making each other wait or producing inconsistent ...
https://dev.mysql.com/doc/refman/8.0/en/time-zone-support.html
If you start the server using mysqld_safe, its --timezone option provides another way to set the system time zone. For most operating systems, the latest update or service pack prepares your system for the time changes. Check the website for your ...
https://dev.mysql.com/doc/refman/8.0/en/loadable-function-reference.html
The following table lists each function that is loadable at runtime and provides a short description of each one. For a table listing built-in functions and operators, see Section 14.1, “Built-In Function and Operator Reference” For general ...