PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.1Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/perl-installation.html
MySQL Perl support requires that you have installed MySQL client programming support (libraries and header files). These tests attempt to connect to the local MySQL server using the default user name and password. (The default user name is your ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-invoked.html
Replication of invoked features such as loadable functions and stored programs (stored procedures and functions, triggers, and events) provides the following characteristics: The effects of the feature are always replicated. In the case of CREATE ...The following statements are replicated using statement-based replication: CREATE EVENT ALTER EVENT DROP EVENT CREATE PROCEDURE DROP PROCEDURE CREATE FUNCTION DROP FUNCTION CREATE TRIGGER DROP TRIGGER However, the effects of features created, modified, or dropped using these statements are replicated using row-based ...
https://dev.mysql.com/doc/refman/8.0/en/replication-howto-masterbaseconfig.html
To configure a source to use binary log file position based replication, you must ensure that binary logging is enabled, and establish a unique server ID. This server ID is used to identify individual servers within the replication topology, and ...
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-backups-rawdata.html
To shut down the server and back up the files: Shut down the replica MySQL server: $> mysqladmin shutdown Copy the data files. If you want to be able to restore the data and operate as a replica (for example, in the event of failure of the replica), ... To guarantee the integrity of the files that are copied, backing up the raw data files on your MySQL replica should take place while your replica server is shut ...
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions.html
This section provides general notes and advice on using replication for specific solution types. For information on using replication in a backup environment, including notes on the setup, backup procedure, and files to back up, see Section 19.4.1, ... Replication can be used in many different environments for a range of ...
https://dev.mysql.com/doc/refman/8.0/en/replication-threads.html
When a START REPLICA statement is issued on a replica server, the replica creates an I/O (receiver) thread, which connects to the source and asks it to send the updates recorded in its binary logs. The replication receiver thread reads the updates ...When replica_parallel_workers (in MySQL 8.0.26 and earlier, use slave_parallel_workers) is equal to 0, the replica creates an SQL (applier) thread to read the relay log that is written by the replication receiver thread and execute the transactions contained in ...
https://dev.mysql.com/doc/refman/8.0/en/row-constructor-optimization.html
For example, these two statements are semantically equivalent: SELECT * FROM t1 WHERE (column1,column2) = (1,1); SELECT * FROM t1 WHERE column1 = 1 AND column2 = 1; In addition, the optimizer handles both expressions the same way. However, the row ...The optimizer is less likely to use available indexes if the row constructor columns do not cover the prefix of an ...
https://dev.mysql.com/doc/refman/8.0/en/selinux.html
Security-Enhanced Linux (SELinux) is a mandatory access control (MAC) system that implements access rights by applying a security label referred to as an SELinux context to each system object. SELinux policy modules use SELinux contexts to define ...Interaction between system objects is only permitted if a policy rule allows ...
https://dev.mysql.com/doc/refman/8.0/en/solaris-installation-pkg.html
Note MySQL 5.7 has a dependency on the Oracle Developer Studio Runtime Libraries; but this does not apply to MySQL 8.0. For example: $> gunzip mysql-8.0.44-solaris11-x86_64.pkg.gz To install a new package, use pkgadd and follow the onscreen prompts.
https://dev.mysql.com/doc/refman/8.0/en/solaris-installation.html
Note MySQL 8.0 supports Solaris 11.4 and higher MySQL on Solaris is available in a number of different formats. To use a standard tar binary installation, use the notes provided in Section 2.2, “Installing MySQL on Unix/Linux Using Generic ...For ...