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/create-table-ndb-comment-options.html
NDB_COLUMN can be used in a column comment to set the size of the blob parts table column used for storing parts of blob values by NDB to its maximum. Using any value other than 0 or 1 results in a syntax error. The effect of using ... NDB_COLUMN ...
https://dev.mysql.com/doc/refman/5.7/en/full-table.html
If a table-full error occurs, it may be that the disk is full or that the table has reached its maximum size. The effective maximum table size for MySQL databases is usually determined by operating system constraints on file sizes, not by MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-metrics-table.html
The TIME_ENABLED and TIME_ELAPSED values indicate when the counter was last enabled and how many seconds have elapsed since that time. Note Because each counter adds a degree of runtime overhead, use counters conservatively on production servers to ... The INNODB_METRICS table provides information about InnoDB performance and resource-related ...
https://dev.mysql.com/doc/refman/5.7/en/replication-gtids-functions.html
WAIT_FOR_EXECUTED_GTID_SET(): Waits until all transactions in a given GTID set have been executed. To perform the same check with GTID_SUBTRACT(), execute the following statement on the replica: SELECT GTID_SUBTRACT(source_gtid_executed, ... This ...
https://dev.mysql.com/doc/refman/5.7/en/deallocate-prepare.html
Attempting to execute a prepared statement after deallocating it results in an error. {DEALLOCATE | DROP} PREPARE stmt_name To deallocate a prepared statement produced with PREPARE, use a DEALLOCATE PREPARE statement that refers to the prepared ...
https://dev.mysql.com/doc/refman/5.7/en/charset-unicode-utf8mb4.html
utf8mb4 contrasts with the utf8mb3 character set, which supports only BMP characters and uses a maximum of three bytes per character: For a BMP character, utf8mb4 and utf8mb3 have identical storage characteristics: same code values, same encoding, ... The utf8mb4 character set has these characteristics: Supports BMP and supplementary ...
https://dev.mysql.com/doc/refman/5.7/en/integer-types.html
MySQL supports the SQL standard integer types INTEGER (or INT) and SMALLINT. As an extension to the standard, MySQL also supports the integer types TINYINT, MEDIUMINT, and BIGINT. The following table shows the required storage and range for each ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-resources.html
max The maximum amount (number of 32KB pages) of this resource that is available to this data node. 0 in this column indicates that the resource is unlimited, which means the effective maximum is 4294967295 (232-1). This table provides information ...
https://dev.mysql.com/doc/refman/5.7/en/preventing-use-of-optimizer-trace.html
If, for some reason, you wish to prevent users from seeing traces of their queries, start the server with the options shown here: --maximum-optimizer-trace-max-mem-size=0 --optimizer-trace-max-mem-size=0 This sets the maximum size to 0 and prevents ...
https://dev.mysql.com/doc/refman/5.7/en/system-variables-controlling-tracing.html
optimizer_trace_max_mem_size: Maximum amount of memory that can be used for storing all traces. The following system variables affect optimizer tracing: optimizer_trace: Enables or disables optimizer tracing. optimizer_trace_features: Enables or ...