PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/create-table-ndb-comment-options.html
NDB_COLUMN Options NDB_TABLE Options It is possible to set a number of options specific to NDB Cluster in the table comment or column comments of an NDB table. NDB_COLUMN can be used in a column comment to set the size of the blob parts table ...
https://dev.mysql.com/doc/refman/5.7/en/union.html
Selected columns listed in corresponding positions of each SELECT statement should have the same data type. For example, the first column selected by the first statement should have the same type as the first column selected by the other statements.
https://dev.mysql.com/doc/refman/5.7/en/diagnostics-area.html
The definitions apply for conditions generated other than by a signal (that is, by a SIGNAL or RESIGNAL statement). CATALOG_NAME, SCHEMA_NAME, TABLE_NAME, COLUMN_NAME: Strings that indicate the catalog, schema, table, and column related to the ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-compression-syntax-warnings.html
Specifying a KEY_BLOCK_SIZE with any other ROW_FORMAT generates a warning that you can view with SHOW WARNINGS. If you are running with innodb_strict_mode enabled, the combination of a KEY_BLOCK_SIZE with any ROW_FORMAT other than COMPRESSED ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-troubleshoot.html
These limits primarily apply if you intend to create an index on a value column to run report-generating queries on that column using SQL. loose-daemon_memcached_option='-vvv' If columns specified to hold memcached values are the wrong data type, ...
https://dev.mysql.com/doc/refman/5.7/en/myisam-storage-engine.html
See Section 4.5.3, “mysqlcheck — A Table Maintenance Program”, Section 4.6.3, “myisamchk — MyISAM Table-Maintenance Utility”, and Section 4.6.5, “myisampack — Generate Compressed, Read-Only MyISAM Tables”. Also, the code in the ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-indexes-table.html
0 = nonunique secondary index; 1 = automatically generated clustered index (GEN_CLUST_INDEX); 2 = unique nonclustered index; 3 = clustered index; 32 = full-text index; 64 = spatial index; 128 = secondary index on a virtual generated column. The ...
https://dev.mysql.com/doc/refman/5.7/en/data-size.html
You can get better performance for a table and minimize storage space by using the techniques listed here: Table Columns Row Format Indexes Joins Normalization Table Columns Use the most efficient (smallest) data types possible. MEDIUMINT is often a ... Design your tables to minimize their space on the ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-disabling.html
Starting the audit log plugin with audit_log_disable = true generates a warning (ER_WARN_AUDIT_LOG_DISABLED) with the following message: Audit Log is disabled. When audit_log_disable is set to true, audit log function calls and variable changes ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-logging-configuration.html
Encryption is based on a user-defined password (with the exception of the initial password, which the audit log plugin generates). If not, the plugin automatically generates a random initial encryption password and stores it in the keyring. Blocking ... This section describes how to configure audit logging characteristics, such as the file to which the audit log plugin writes events, the format of written events, whether to enable log file compression and encryption, and space ...