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/faqs-innodb-change-buffer.html
The innodb_io_capacity parameter sets an upper limit on the I/O activity performed by InnoDB background tasks such as merging data from the change buffer. How much space does InnoDB use for the change buffer? A.16.5. Where can I find additional ...
https://dev.mysql.com/doc/refman/5.7/en/if.html
[ELSE statement_list] END IF The IF statement for stored programs implements a basic conditional construct. Note There is also an IF() function, which differs from the IF statement described here. The IF statement can have THEN, ELSE, and ELSEIF ...
https://dev.mysql.com/doc/refman/5.7/en/myisam-key-cache.html
To minimize disk I/O, the MyISAM storage engine exploits a strategy that is used by many database management systems. It employs a cache mechanism to keep the most frequently accessed table blocks in memory: For index blocks, a special structure ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-limitations-limits.html
The maximum number of operations that can be performed per transaction is set using the configuration parameters MaxNoOfConcurrentOperations and MaxNoOfLocalOperations. Instead, the following rules hold true: A DELETE statement on an NDB table makes ... In this section, we list limits found in NDB Cluster that either differ from limits found in, or that are not found in, standard ...
https://dev.mysql.com/doc/refman/5.7/en/stored-objects.html
This chapter discusses stored database objects that are defined in terms of SQL code that is stored on the server for later execution. A procedure does not have a return value but can modify its parameters for later inspection by the caller. It can ...Stored objects include these object types: Stored procedure: An object created with CREATE PROCEDURE and invoked using the CALL ...
https://dev.mysql.com/doc/refman/5.7/en/adding-collation-choosing-id.html
The range of IDs from 1024 to 2047 is reserved for user-defined collations. The collation ID that you choose appears in these contexts: The ID column of the Information Schema COLLATIONS table. The number member of the MY_CHARSET_INFO data structure ...To add a collation, you must choose an ID value that is not currently ...
https://dev.mysql.com/doc/refman/5.7/en/ansi-diff-select-into-table.html
For example: INSERT INTO tbl_temp2 (fld_id) SELECT tbl_temp1.fld_order_id FROM tbl_temp1 WHERE tbl_temp1.fld_order_id > 100; Alternatively, you can use SELECT ... The same syntax can also be used inside stored routines using cursors and local ...
https://dev.mysql.com/doc/refman/5.7/en/comments.html
(Under some conditions, nested comments might be permitted, but usually are not, and users should avoid them.) MySQL Server supports certain variants of C-style comments. For example, MySQL Server recognizes the STRAIGHT_JOIN keyword in the ...
https://dev.mysql.com/doc/refman/5.7/en/common-errors.html
This section lists some errors that users frequently encounter when running MySQL programs. Although the problems show up when you try to run client programs, the solutions to many of the problems involves changing the configuration of the MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/connection-control-plugin.html
This capability provides a deterrent that slows down brute force attacks against MySQL user accounts. To collect information, it subscribes to the MYSQL_AUDIT_CONNECTION_CLASSMASK event class, and processes MYSQL_AUDIT_CONNECTION_CONNECT and ...This ... As of MySQL 5.7.17, MySQL Server includes a plugin library that enables administrators to introduce an increasing delay in server response to connection attempts after a configurable number of consecutive failed ...