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/binary-log-setting.html
Switching the replication format at runtime is not recommended when any temporary tables exist, because temporary tables are logged only when using statement-based replication, whereas with row-based replication they are not logged. You can select ...
https://dev.mysql.com/doc/refman/5.7/en/binary-log.html
If the server unexpectedly exits between those two operations, the transaction is rolled back by InnoDB at restart but still exists in the binary log. The binary log contains “events” that describe database changes such as table creation ...
https://dev.mysql.com/doc/refman/5.7/en/blackhole-storage-engine.html
On a replica the same table exists but using the MyISAM engine. 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 ...
https://dev.mysql.com/doc/refman/5.7/en/bug-reports.html
When you provide an example of the problem, it is better to use the table names, variable names, and so forth that exist in your actual situation than to come up with new names. Before posting a bug report about a problem, please try to verify that ...
https://dev.mysql.com/doc/refman/5.7/en/cache-index.html
A key cache must exist before you assign indexes to it, or an error occurs: mysql> CACHE INDEX t1 IN non_existent_cache; ERROR 1284 (HY000): Unknown key cache 'non_existent_cache' By default, table indexes are assigned to the main (default) key ...| ...
https://dev.mysql.com/doc/refman/5.7/en/can-not-connect-to-server.html
You can always run mysqladmin version to check whether the Unix socket file that mysqladmin is trying to use really exists. A MySQL client on Unix can connect to the mysqld server in two different ways: By using a Unix socket file to connect ...
https://dev.mysql.com/doc/refman/5.7/en/cannot-create.html
For example, to specify a directory of C:\temp, use these lines: [mysqld] tmpdir=C:/temp The C:\temp directory must exist and have sufficient space for the MySQL server to write to. If you get an error of the following type for some queries, it ...
https://dev.mysql.com/doc/refman/5.7/en/changing-mysql-user.html
(It is a good idea to assign passwords to MySQL accounts in any case, but especially so when other login accounts exist on the server host.) See Section 2.9.4, “Securing the Initial MySQL Account”. On Windows, you can run the server as a ...
https://dev.mysql.com/doc/refman/5.7/en/character-arrays.html
Each simple character set has a configuration file located in the sql/share/charsets directory. For a character set named MYSYS, the file is named MYSET.xml. <map> elements appear within these elements: <ctype> defines attributes for each character. <collation> elements indicate character ordering for comparison and sorting, one element per ...
https://dev.mysql.com/doc/refman/5.7/en/charset-applications.html
Note If you use ALTER DATABASE to change the database default character set or collation, existing stored routines in the database that use those defaults must be dropped and recreated so that they use the new defaults. For applications that store ...