PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/create-table-ndb-comment-options.html
It does not indicate the number of characters, which varies according to the character set and collation used by the column. NDB_COLUMN Options NDB_TABLE Options It is possible to set a number of options specific to NDB Cluster in the table comment ...
https://dev.mysql.com/doc/refman/8.0/en/error-message-elements.html
These elements have the following characteristics: Error code: This value is numeric. SQLSTATE value: This value is a five-character string (for example, '42S02'). The first two characters of an SQLSTATE value indicate the error class: Class = '00' ... This section discusses how error messages originate within MySQL and the elements they ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-tables-table.html
The output does not explicitly list the table default character set, but the collation name begins with the character set name. The information_schema_stats_expiry system variable defines the period of time before cached table statistics expire. If ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-compression-tuning.html
Whether to adjust the size of the buffer pool based on run-time performance characteristics, such as the amount of time the system spends compressing and uncompressing data. When to Use Compression In general, compression works best on tables that ... Most often, the internal optimizations described in InnoDB Data Storage and Compression ensure that the system runs well with compressed ...
https://dev.mysql.com/doc/refman/8.0/en/load-xml.html
(Bug #30753708, Bug #98199) The following clauses work essentially the same way for LOAD XML as they do for LOAD DATA: LOW_PRIORITY or CONCURRENT LOCAL REPLACE or IGNORE CHARACTER SET SET See Section 15.2.9, “LOAD DATA Statement”, for more ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-innodb-storage-layout.html
A CHAR(N) column always takes N characters to store data, even if the string is shorter or its value is NULL. When using COMPACT row format and variable-length character sets, such as utf8mb4 or sjis, CHAR(N) columns occupy a variable amount of ...
https://dev.mysql.com/doc/refman/8.0/en/show-table-status.html
The output does not explicitly list the table default character set, but the collation name begins with the character set name. SHOW TABLE STATUS [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW TABLE STATUS works likes SHOW TABLES, but ...
https://dev.mysql.com/doc/refman/8.0/en/alter-database.html
alter_option: { [DEFAULT] CHARACTER SET [=] charset_name | [DEFAULT] COLLATE [=] collation_name | [DEFAULT] ENCRYPTION [=] {'Y' | 'N'} | READ ONLY [=] {DEFAULT | 0 | 1} } ALTER DATABASE enables you to change the overall characteristics of a database. For any alter_option omitted from the statement, the database retains its current option value, with the exception that changing the character set may change the collation and vice ...
https://dev.mysql.com/doc/refman/8.0/en/change-replication-source-to.html
Values used for SOURCE_HOST and other CHANGE REPLICATION SOURCE TO options are checked for linefeed (\n or 0x0A) characters. The presence of such characters in these values causes the statement to fail with an error. When the receiver thread is ...] ...
https://dev.mysql.com/doc/refman/8.0/en/fulltext-fine-tuning.html
For example, to make two-character words searchable, you could put the following lines in an option file: [mysqld] innodb_ft_min_token_size=2 ft_min_word_len=2 Then restart the server and rebuild your FULLTEXT indexes. Character Set Modifications ...