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/mysql-enterprise-audit.html
MySQL Enterprise Audit uses the open MySQL Audit API to enable standard, policy-based monitoring and logging of connection and query activity executed on specific MySQL servers. Designed to meet the Oracle audit specification, MySQL Enterprise Audit ... MySQL Enterprise Edition includes MySQL Enterprise Audit, implemented using a server ...
https://dev.mysql.com/doc/refman/8.0/en/mysqld.html
System variables can be set at server startup, and many of them can be changed at runtime to effect dynamic server reconfiguration. MySQL Server manages access to the MySQL data directory that contains databases and tables. The data directory is ...
https://dev.mysql.com/doc/refman/8.0/en/mysqldump-delimited-text.html
If you invoke mysqldump with the --tab=dir_name option, it uses dir_name as the output directory and dumps tables individually in that directory using two files for each table. For a table named t1, the files are named t1.sql and t1.txt. The ...
https://dev.mysql.com/doc/refman/8.0/en/native-pluggable-authentication.html
Note The mysql_native_password authentication plugin is deprecated as of MySQL 8.0.34, disabled by default in MySQL 8.4, and removed as of MySQL 9.0.0. The following table shows the plugin names on the server and client sides. Installing Native ...
https://dev.mysql.com/doc/refman/8.0/en/operator-precedence.html
When used as a comparison operator, it has the same precedence as <=>, >=, >, <=, <, <>, !=, IS, LIKE, REGEXP, and IN(). Section 15.7.6.1, “SET Syntax for Variable Assignment”, and Section 11.4, “User-Defined Variables”, explain how MySQL ...
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 ...