PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/purge-binary-logs.html
This statement has no effect if the server was not started with the --log-bin option to enable binary logging. If you have an active replica that currently is reading one of the log files you are trying to delete, this statement does not delete the ... PURGE { BINARY | MASTER } LOGS { TO 'log_name' | BEFORE datetime_expr } The binary log is a set of files that contain information about data modifications made by the MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/replica-logs-status.html
The metadata in this repository includes the connection configuration, the replication user account details, the SSL settings for the connection, and the file name and position where the replication I/O thread is currently reading from the source's ... A replica server creates two replication metadata repositories, the connection metadata repository and the applier metadata ...
https://dev.mysql.com/doc/refman/5.7/en/tutorial.html
(If you are the administrator, you need to consult the relevant portions of this manual, such as Chapter 5, MySQL Server Administration.) This chapter describes the entire process of setting up and using a database. This chapter provides a tutorial ...mysql (sometimes referred to as the “terminal monitor” or just “monitor”) is an interactive program that enables you to connect to a MySQL server, run queries, and view the ...
https://dev.mysql.com/doc/refman/5.7/en/account-names.html
This section describes the syntax for account names, including special values and wildcard rules. Because IP wildcard values are permitted in host values (for example, '198.51.100.%' to match every host on a subnet), someone could try to exploit ...
https://dev.mysql.com/doc/refman/5.7/en/blackhole-storage-engine.html
(See Section 16.1.6, “Replication and Binary Logging Options and Variables”.) This filtered log is provided to the replica. This type of setup can be repeated with additional replication replicas. This should be borne in mind when considering ...
https://dev.mysql.com/doc/refman/5.7/en/charset-collation-implementations.html
MySQL implements several types of collations: Simple collations for 8-bit character sets This kind of collation is implemented using an array of 256 weights that defines a one-to-one mapping from character codes to weights. Complex collations for ...It is a case-insensitive collation, so the uppercase and lowercase versions of a character have the same weights and they compare as ...
https://dev.mysql.com/doc/refman/5.7/en/connecting.html
This section describes use of command-line options to specify how to establish connections to the MySQL server, for clients such as mysql or mysqldump. This command invokes mysql without specifying any explicit connection parameters: mysql Because ...For additional information if you are unable to connect, see Section 6.2.17, “Troubleshooting Problems Connecting to ...
https://dev.mysql.com/doc/refman/5.7/en/creating-ssl-files-using-openssl.html
This section describes how to use the openssl command to set up SSL certificate and key files for use by MySQL servers and clients. A typical error in this case is: ERROR 2026 (HY000): SSL connection error: error:00000001:lib(0):func(0):reason(1) ...The first example shows a simplified procedure such as you might use from the command ...
https://dev.mysql.com/doc/refman/5.7/en/federated-usagenotes.html
This means that, for a query that cannot use any indexes and so requires a full table scan, the server fetches all rows from the remote table and filters them locally. This occurs regardless of any WHERE or LIMIT used with this SELECT statement; ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-background.html
This creates a set of challenges that raise complexity of such systems to a whole different level. This can be summarized as having servers reaching agreement on each database state transition, so that they all progress as one single database or ...