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/replication-howto-additionalslaves.html
Alternatively, if you have already tried to start the new replica after following the remaining steps in this section and have encountered errors like those described previously, then perform the following steps: If you have not already done so, ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-service.html
MySQL Server supports a keyring service that enables internal server components and plugins to securely store sensitive information for later retrieval. MySQL distributions provide a keyring interface that is accessible at two levels: At the SQL ...
https://dev.mysql.com/doc/refman/5.7/en/subqueries.html
All subquery forms and operations that the SQL standard requires are supported, as well as a few features that are MySQL-specific. Here is an example of a subquery: SELECT * FROM t1 WHERE column1 = (SELECT column1 FROM t2); In this example, SELECT * ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-compression-tuning.html
Whether to adjust the size of the buffer pool based on run-time performance characteristics, such as the amount of time the system spends compressing and uncompressing data. If the system performs DML operations on compressed tables, and the way the ... Most often, the internal optimizations described in InnoDB Data Storage and Compression ensure that the system runs well with compressed ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-cmpmem-table.html
RELOCATION_TIME The total time in microseconds used for relocating blocks of size PAGE_SIZE. RELOCATION_OPS The number of times a block of size PAGE_SIZE has been relocated. row *************************** page_size: 1024 buffer_pool_instance: 0 ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-linux-native-aio.html
With synchronous I/O, query threads queue I/O requests, and InnoDB background threads retrieve the queued requests one at a time, issuing a synchronous I/O call for each. InnoDB uses the asynchronous I/O subsystem (native AIO) on Linux to perform ...
https://dev.mysql.com/doc/refman/5.7/en/gone-away.html
The most common reason for the MySQL server has gone away error is that the server timed out and closed the connection. You can check whether the MySQL server died and restarted by executing mysqladmin version and examining the server's uptime. By ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-online-ddl-limitations.html
When the DML operations are applied, it is possible to encounter a duplicate key entry error (ERROR 1062 (23000): Duplicate entry), even if the duplicate entry is only temporary and would be reverted by a later entry in the online log. An online DDL ... The following limitations apply to online DDL operations: The table is copied when creating an index on a TEMPORARY ...
https://dev.mysql.com/doc/refman/5.7/en/mysqlbinlog-row-events.html
This is similar to --base64-output=NEVER but does not exit with an error if a row event is found. # at 400 #080828 15:03:08 server id 1 end_log_pos 442 Delete_rows: table id 17 flags: STMT_END_F ### DELETE FROM test.t ### WHERE ### @1=1 ### ... The ...
https://dev.mysql.com/doc/refman/5.7/en/bug-reports.html
If you get a parse error for an SQL statement, please check your syntax closely. For solutions to some common problems, see Section B.3, “Problems and Common Errors”. Writing a good bug report takes patience, but doing it right the first time ...