PDF (US Ltr)
- 41.9Mb
PDF (A4)
- 42.0Mb
Man Pages (TGZ)
- 272.3Kb
Man Pages (Zip)
- 378.3Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/binary-log-setting.html
You can select the binary logging format explicitly by starting the MySQL server with --binlog-format=type. The supported values for type are: STATEMENT causes logging to be statement based. Setting the binary logging format does not activate ...
https://dev.mysql.com/doc/refman/9.7/en/bnl-bka-optimization.html
In MySQL, a Batched Key Access (BKA) Join algorithm is available that uses both index access to the joined table and a join buffer. The BKA algorithm supports inner join, outer join, and semijoin operations, including nested outer joins. Benefits ...
https://dev.mysql.com/doc/refman/9.7/en/change-replication-filter.html
Filters set using this statement differ from those set using the server options in two key respects: The statement does not require restarting the server to take effect, only that the replication SQL thread be stopped using STOP REPLICA SQL_THREAD ...
https://dev.mysql.com/doc/refman/9.7/en/checksum-table.html
[QUICK | EXTENDED] CHECKSUM TABLE reports a checksum for the contents of a table. You can use this statement to verify that the contents are the same before and after a backup, rollback, or other operation that is intended to put the data back to a ...
https://dev.mysql.com/doc/refman/9.7/en/compatibility.html
This section describes how MySQL relates to the ANSI/ISO SQL standards. MySQL Server has many extensions to the SQL standard, and here you can find out what they are and how to use them. You can also find information about functionality missing ...
https://dev.mysql.com/doc/refman/9.7/en/concurrent-inserts.html
If there are multiple INSERT statements, they are queued and performed in sequence, concurrently with the SELECT statements. The results of a concurrent INSERT may not be visible immediately. The concurrent_insert system variable can be set to ...
https://dev.mysql.com/doc/refman/9.7/en/connection-control-plugin-installation.html
This section describes how to install the connection control plugins, CONNECTION_CONTROL and CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS. For general information about installing plugins, see Section 7.6.1, “Installing and Uninstalling Plugins”.
https://dev.mysql.com/doc/refman/9.7/en/connection-interfaces.html
This section describes aspects of how the MySQL server manages client connections. Network Interfaces and Connection Manager Threads Client Connection Thread Management Connection Volume Management Network Interfaces and Connection Manager Threads ...
https://dev.mysql.com/doc/refman/9.7/en/converting-tables-to-innodb.html
If you have MyISAM tables that you want to convert to InnoDB for better reliability and scalability, review the following guidelines and tips before converting. Note Partitioned MyISAM tables created in previous versions of MySQL are not compatible ...
https://dev.mysql.com/doc/refman/9.7/en/cost-model.html
To generate execution plans, the optimizer uses a cost model that is based on estimates of the cost of various operations that occur during query execution. The optimizer has a set of compiled-in default “cost constants” available to it to make ...