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/connection-interfaces.html
Connection Volume Management To control the maximum number of clients the server permits to connect simultaneously, set the max_connections system variable at server startup or at runtime. It implements a thread pool that increases server ... This ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-columns-table.html
COLUMN_KEY Whether the column is indexed: If COLUMN_KEY is empty, the column either is not indexed or is indexed only as a secondary column in a multiple-column, nonunique index. on update CURRENT_TIMESTAMP for TIMESTAMP or DATETIME columns that ...
https://dev.mysql.com/doc/refman/5.7/en/declare-handler.html
statement handler_action: { CONTINUE | EXIT | UNDO } condition_value: { mysql_error_code | SQLSTATE [VALUE] sqlstate_value | condition_name | SQLWARNING | NOT FOUND | SQLEXCEPTION } The DECLARE ... The handler_action value indicates what action the ...HANDLER statement specifies a handler that deals with one or more ...
https://dev.mysql.com/doc/refman/5.7/en/select-optimization.html
Tuning these statements is a top priority, whether to achieve sub-second response times for dynamic web pages, or to chop hours off the time to generate huge overnight reports. With efficient use of the InnoDB buffer pool, MyISAM key cache, and the ...NDB Cluster supports a join pushdown optimization whereby a qualifying join is sent in its entirety to NDB Cluster data nodes, where it can be distributed among them and executed in ...
https://dev.mysql.com/doc/refman/5.7/en/xa.html
In essence, this extends ACID properties “up a level” so that multiple ACID transactions can be executed in concert as components of a global operation that also has ACID properties. The process for executing a global transaction uses two-phase ... Support for XA transactions is available for the InnoDB storage ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-create-table-external.html
Attempting to access a table when the associated data file is missing causes a serious error that requires a server restart. There are different reasons for creating InnoDB tables externally; that is, creating tables outside of the data directory.
https://dev.mysql.com/doc/refman/5.7/en/out-of-range-and-overflow.html
When a floating-point or fixed-point column is assigned a value that exceeds the range implied by the specified (or default) precision and scale, MySQL stores the value representing the corresponding endpoint of that range. If strict SQL mode is ...
https://dev.mysql.com/doc/refman/5.7/en/table-size-limit.html
The effective maximum table size for MySQL databases is usually determined by operating system constraints on file sizes, not by MySQL internal limits. If you encounter a full-table error, there are several reasons why it might have occurred: The ...For up-to-date information operating system file size limits, refer to the documentation specific to your operating ...
https://dev.mysql.com/doc/refman/5.7/en/replication-rbr-safe-unsafe.html
When activated, this causes such warnings not to be written to the error log; instead, for each 50 warnings of this type, a note The last warning was repeated N times in last S seconds is written to the error log. Formerly, if a large number of such ...This continues as long as the 50 most recent such warnings were issued in 50 seconds or less; once the rate has decreased below this threshold, the warnings are once again logged ...
https://dev.mysql.com/doc/refman/5.7/en/account-upgrades.html
Notes: The upgrade operation just described is safe to execute at any time because it makes the mysql_native_password plugin explicit only for accounts that already use it implicitly. To upgrade these accounts to use mysql_native_password ... The ...