PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
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/column-count-limit.html
Each NULL column takes one bit extra, rounded up to the nearest byte. This section describes limits on the number of columns in tables and the size of individual rows. Column Count Limits Row Size Limits Column Count Limits MySQL has hard limit of ...
https://dev.mysql.com/doc/refman/9.7/en/components.html
A component that calculates an MD5 128-bit or SHA-1 checksum for the string. MySQL Server includes a component-based infrastructure for extending server capabilities. A component provides services that are available to the server and other ...
https://dev.mysql.com/doc/refman/9.7/en/compressed-format.html
Numbers with a value of zero are stored using one bit. Compressed storage format is a read-only format that is generated with the myisampack tool. Compressed tables have the following characteristics: Compressed tables take very little disk space.
https://dev.mysql.com/doc/refman/9.7/en/concurrent-inserts.html
Use of the CONCURRENT option affects the performance of LOAD DATA a bit, even if no other session is using the table at the same time. If there are multiple INSERT statements, they are queued and performed in sequence, concurrently with the SELECT ...
https://dev.mysql.com/doc/refman/9.7/en/connection-options.html
For better security, use a certificate with an RSA key size of at least 2048 bits. This section describes options supported by most MySQL client programs that control how client programs establish connections to the server, whether connections are ...
https://dev.mysql.com/doc/refman/9.7/en/constant-folding-optimization.html
Comparisons between constants and column values in which the constant value is out of range or of the wrong type with respect to the column type are now handled once during query optimization rather row-by-row than during execution. The comparisons ...
https://dev.mysql.com/doc/refman/9.7/en/constraints.html
Because of this, constraint handling is a bit different in MySQL than in other DBMSs. MySQL enables you to work both with transactional tables that permit rollback and with nontransactional tables that do not. We must handle the case when you have ...
https://dev.mysql.com/doc/refman/9.7/en/create-logfile-group.html
On 32-bit systems, the maximum supported value for INITIAL_SIZE is 4294967296 (4 GB). CREATE LOGFILE GROUP logfile_group ADD UNDOFILE 'undo_file' [INITIAL_SIZE [=] initial_size] [UNDO_BUFFER_SIZE [=] undo_buffer_size] [REDO_BUFFER_SIZE [=] ...
https://dev.mysql.com/doc/refman/9.7/en/create-table-foreign-keys.html
MySQL supports foreign keys, which permit cross-referencing related data across tables, and foreign key constraints, which help keep the related data consistent. A foreign key relationship involves a parent table that holds the initial column ...
https://dev.mysql.com/doc/refman/9.7/en/create-table.html
Columns using BLOB, TEXT, SET, ENUM, BIT, or spatial data types are not permitted; columns that use floating-point number types are also not permitted. | {FULLTEXT | SPATIAL} [INDEX | KEY] [index_name] (key_part,...) [index_option] ... | [CONSTRAINT ...