PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.9Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/mysql-command-options.html
--bind-address=ip_address Command-Line Format --bind-address=ip_address On a computer having multiple network interfaces, use this option to select which interface to use for connecting to the MySQL server. --compression-algorithms=value ... mysql ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-file-formats.html
Elements following that one represent events such as client connect and disconnect events, executed SQL statements, and so forth. <AUDIT_RECORD> <TIMESTAMP>2019-10-03T14:09:38 UTC</TIMESTAMP> <RECORD_ID>6_2019-10-03T14:06:33</RECORD_ID> ... The ...
https://dev.mysql.com/doc/refman/8.0/en/mysqladmin.html
To kill threads belonging to other users, the connected user must have the CONNECTION_ADMIN privilege (or the deprecated SUPER privilege). This changes the password to new_password for the account that you use with mysqladmin for connecting to the ...You can use it to check the server's configuration and current status, to create and drop databases, and ...
https://dev.mysql.com/doc/refman/8.0/en/mysqlbinlog.html
To read remote binary logs, the connection parameter options can be given to indicate how to connect to the server. mysqlbinlog's own connection compression does less if transaction payloads are already compressed, but still operates on uncompressed ... The server's binary log consists of files containing “events” that describe modifications to database ...
https://dev.mysql.com/doc/refman/8.0/en/added-deprecated-removed.html
Mysqlx_compression_algorithm: Compression algorithm in use for X Protocol connection for this session. Mysqlx_compression_level: Compression level in use for X Protocol connection for this session. admin_address: IP address to bind to for ...
https://dev.mysql.com/doc/refman/8.0/en/mysqlslap.html
--compression-algorithms=value Command-Line Format --compression-algorithms=value Introduced 8.0.18 Type Set Default Value uncompressed Valid Values zlibzstduncompressed The permitted compression algorithms for connections to the server. --detach=N ... mysqlslap is a diagnostic program designed to emulate client load for a MySQL server and to report the timing of each ...
https://dev.mysql.com/doc/refman/8.0/en/server-status-variables.html
The optional GLOBAL keyword aggregates the values over all connections, and SESSION shows the values for the current connection. mysql> SHOW GLOBAL STATUS; +-----------------------------------+------------+ | Variable_name | Value | ... The MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/change-master-to.html
] CHANGE MASTER TO changes the parameters that the replica server uses for connecting to the source and for reading data from the source. For connections by accounts that authenticate using this plugin, the source does not send the public key unless ...It also updates the contents of the replication metadata repositories (see Section 19.2.4, “Relay Log and Replication Metadata ...
https://dev.mysql.com/doc/refman/8.0/en/change-replication-source-to.html
] CHANGE REPLICATION SOURCE TO changes the parameters that the replica server uses for connecting to the source and reading data from the source. For connections by accounts that authenticate using this plugin, the source does not send the public ...
https://dev.mysql.com/doc/refman/8.0/en/mysqldump.html
Note A dump made using PowerShell on Windows with output redirection creates a file that has UTF-16 encoding: mysqldump [options] > dump.sql However, UTF-16 is not permitted as a connection character set (see Impermissible Client Character Sets), so ... The mysqldump client utility performs logical backups, producing a set of SQL statements that can be executed to reproduce the original database object definitions and table ...