Search Results
https://dev.mysql.com/doc/refman/8.4/en/enum.html
For example, this CREATE TABLE statement does not work because the CONCAT function cannot be used to construct an enumeration value: CREATE TABLE sizes ( size ENUM('small', CONCAT('med','ium'), 'large') ); You also cannot employ a user variable as ...This means that you can use the following SELECT statement to find rows into which invalid ENUM values were assigned: mysql> SELECT * FROM tbl_name WHERE enum_col=0; The index of the NULL value is ...
https://dev.mysql.com/doc/refman/8.4/en/storage-requirements.html
The internal representation of a table has a maximum row size of 65,535 bytes, even if the storage engine is capable of supporting larger rows. For more information, see Chapter 18, Alternative Storage Engines, and Section 10.4.7, “Limits on Table ...Table data might be compressed, either for a column or an entire row, complicating the calculation of storage requirements for a table or ... InnoDB Table Storage Requirements NDB Table Storage Requirements Numeric Type Storage Requirements Date and Time Type Storage Requirements String Type Storage ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-reference.html
Audit_log_event_max_drop_size The size of the largest dropped event in performance logging mode. If audit_log_rotate_on_size is 0, automatic audit log file rotation is disabled and rotation occurs only when performed manually. audit_log_max_size ...
https://dev.mysql.com/doc/refman/8.4/en/password-management.html
Password failure tracking, to enable temporary account locking after too many consecutive incorrect-password login failures. To expire an account password manually, use the ALTER USER statement: ALTER USER 'jeffrey'@'localhost' PASSWORD EXPIRE; This ... MySQL supports these password-management capabilities: Password expiration, to require passwords to be changed ...
https://dev.mysql.com/doc/refman/8.4/en/thread-pool.html
The plugin implements a thread pool that increases server performance by efficiently managing statement execution threads for large numbers of client connections. The thread pool addresses several problems of the model that uses one thread per ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-options-variables.html
Because --ndb-log-empty-epochs=1 causes the size of the ndb_binlog_index table to increase independently of the size of the binary log, users should be prepared to manage the growth of this table, even if they expect the cluster to be idle a large ...This is generally not recommended, although it may be useful to disable transaction support within a given client session when that session is used to import one or more dump files with large transactions; this allows a multi-row insert to be executed in parts, rather than as a single ...
https://dev.mysql.com/doc/internals/en/floating-point-types.html
The bugfix was developed in two steps: The first attempt looked like this (in principle): length= sprintf(buff, "%.*g", field_length, nr); if (length > field_length) length= sprintf(buff, "%.*g", field_length-5, nr); If the libc conversion produces ... The MySQL Reference Manual has a discussion of floating-point numbers in Section 11.2 Numeric Types, including details about the ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-buffer-pool.html
Ideally, you set the size of the buffer pool to as large a value as practical, leaving enough memory for other processes on the server to run without excessive paging. For efficiency of high-volume read operations, the buffer pool is divided into ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-config-metric-connectionbuffers-category.html
Both begin with a size given by net_buffer_length (in bytes) but are dynamically enlarged up to max_allowed_packet bytes as needed. Read Rnd Buffer Size The size (in bytes) for reading rows in sorted order following a key-sorting operation, to avoid ...Table 7.8 Connection Buffers Configuration Metrics NameDescriptionBulk Insert Buffer Size Limits the size (in bytes) of the special tree-like cache MyISAM uses to make bulk inserts faster for INSERT ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-error-messages.html
Error number: ML003014; SQLSTATE: HY000 Message: The size of model generated is larger than the maximum allowed. Example: ERROR HY000: ML003014: The size of model generated is larger than the maximum allowed. The syntax for a forecasting task ...If ... Each error message includes an error number, SQLSTATE value, and message string, as described in Error Message Sources and ...