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/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/constraint-invalid-data.html
Invalid values for ENUM and SET columns are handled as described in Section 1.6.3.4, “ENUM and SET Constraints”. You can select stricter treatment of input values by using the STRICT_TRANS_TABLES or STRICT_ALL_TABLES SQL modes: SET sql_mode = ...
https://dev.mysql.com/doc/refman/5.7/en/drop-tablespace.html
ENGINE sets the storage engine that uses the tablespace, where engine_name is the name of the storage engine. For an InnoDB tablespace, all tables must be dropped from the tablespace prior to a DROP TABLESPACE operation. As with the InnoDB system ...
https://dev.mysql.com/doc/refman/5.7/en/rebuilding-tables.html
This section describes how to rebuild or repair tables or indexes, which may be necessitated by: Changes to how MySQL handles data types or character sets. For example, an error in a collation might have been corrected, necessitating a table ...
https://dev.mysql.com/doc/refman/5.7/en/index-btree-hash.html
Understanding the B-tree and hash data structures can help predict how different queries perform on different storage engines that use these data structures in their indexes, particularly for the MEMORY storage engine that lets you choose B-tree or ...In the second statement, only rows with 'Pat' <= key_col < 'Pau' are ...
https://dev.mysql.com/doc/refman/5.7/en/insert-select.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; The following conditions hold for INSERT ... To ensure that the binary log can be used to re-create the original tables, ...
https://dev.mysql.com/doc/refman/5.7/en/loading-tables.html
For missing values (such as unknown sexes or death dates for animals that are still living), you can use NULL values. These are sufficient for the statement to read the file pet.txt properly. See Section 6.1.6, “Security Considerations for LOAD ...
https://dev.mysql.com/doc/refman/5.7/en/numeric-types.html
The keyword INT is a synonym for INTEGER, and the keywords DEC and FIXED are synonyms for DECIMAL. MySQL treats DOUBLE as a synonym for DOUBLE PRECISION (a nonstandard extension). MySQL also treats REAL as a synonym for DOUBLE PRECISION (a ...These ...