PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/binary-log.html
The binary log has two important purposes: For replication, the binary log on a replication source server provides a record of the data changes to be sent to replicas. The binary log contains “events” that describe database changes such as ...
https://dev.mysql.com/doc/refman/5.7/en/binlog-replication-configuration-overview.html
Important You cannot configure the source to log only certain events. This section describes replication between MySQL servers based on the binary log file position method, where the MySQL instance operating as the source (where the database ...
https://dev.mysql.com/doc/refman/5.7/en/blackhole-storage-engine.html
The BLACKHOLE storage engine acts as a “black hole” that accepts data but throws it away and does not store it. To examine the source for the BLACKHOLE engine, look in the sql directory of a MySQL source distribution. When you create a ...
https://dev.mysql.com/doc/refman/5.7/en/bug-reports.html
If a program produces an error message, it is very important to include the message in your report. Before posting a bug report about a problem, please try to verify that it is a bug and that it has not been reported already: Start by searching the ...
https://dev.mysql.com/doc/refman/5.7/en/can-not-connect-to-server.html
There are two ways to address this problem: Reduce the number of TCP ports consumed quickly by investigating connection pooling or persistent connections where possible Tune some settings in the Windows registry (see below) Important The following ... A MySQL client on Unix can connect to the mysqld server in two different ways: By using a Unix socket file to connect through a file in the file system (default /tmp/mysql.sock), or by using TCP/IP, which connects through a port ...
https://dev.mysql.com/doc/refman/5.7/en/charset-collation-information-schema.html
String columns in INFORMATION_SCHEMA tables have a collation of utf8_general_ci, which is case-insensitive. However, for values that correspond to objects that are represented in the file system, such as databases and tables, searches in ...
https://dev.mysql.com/doc/refman/5.7/en/charset-connection.html
The mysql, mysqladmin, mysqlcheck, mysqlimport, and mysqlshow client programs determine the default character set to use as follows: In the absence of other information, each client uses the compiled-in default character set, usually latin1. A ...
https://dev.mysql.com/doc/refman/5.7/en/checksum-table.html
Important If the checksums for two tables are different, then it is almost certain that the tables are different in some way. [QUICK | EXTENDED] CHECKSUM TABLE reports a checksum for the contents of a table. You can use this statement to verify that ...
https://dev.mysql.com/doc/refman/5.7/en/choosing-types.html
If accuracy is not too important or if speed is the highest priority, the DOUBLE type may be good enough. For optimum storage, you should try to use the most precise type in all cases. For example, if an integer column is used for values in the ...
https://dev.mysql.com/doc/refman/5.7/en/commit.html
Important Many APIs used for writing MySQL client applications (such as JDBC) provide their own methods for starting transactions that can (and sometimes should) be used instead of sending a START TRANSACTION statement from the client. SET ...