Search Results
https://dev.mysql.com/doc/refman/8.4/en/alter-table.html
For both InnoDB and MyISAM, if the value is less than or equal to the maximum value currently in the AUTO_INCREMENT column, the value is reset to the current maximum AUTO_INCREMENT column value plus one. ENGINE_ATTRIBUTE and ... ALTER TABLE tbl_name ...
https://dev.mysql.com/doc/refman/8.4/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. If the system performs DML operations on compressed tables, and the way the ... 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.4/en/locking-service.html
Timeout values must be integers indicating how many seconds to wait to acquire locks before giving up with an error. Lock acquisition calls take an integer timeout value that indicates how many seconds to wait to acquire locks before giving up. If ...Namespace and lock names must be non-NULL, nonempty, and have a maximum length of 64 ... MySQL distributions provide a locking interface that is accessible at two levels: At the ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-limitations-variables.html
A group_concat_max_len session variable with a value that exceeds the maximum MySQL HeatWave column length (65532 bytes). time_zone and timestamp variable settings are not passed to MySQL HeatWave when queries are offloaded.
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-billing-free-quota.html
The way you are billed for backup storage depends on the DB System State: Active/Inactive: You are billed only when the backups' total size exceeds the free quota described below. You are entitled to a maximum of 150 GiB free backup storage, which ... Billing and Free Quota for Backup Storage 18.6 Billing and Free Quota for Backup Storage The backup storage billing depends on the DB system state and the data storage size that you defined while creating a DB system or updating the storage ...
https://dev.mysql.com/doc/refman/8.4/en/bit-type.html
The maximum combined size of all BIT columns used in a given NDB table must not exceed 4096 bits. The BIT data type is used to store bit values. If you assign a value to a BIT(M) column that is less than M bits long, the value is padded on the left ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-statement-histogram-summary-tables.html
Each statement histogram summary table has these summary columns containing aggregated values: BUCKET_TIMER_LOW, BUCKET_TIMER_HIGH A bucket counts statements that have a latency, in picoseconds, measured between BUCKET_TIMER_LOW and ... The ...To ...
https://dev.mysql.com/doc/refman/8.4/en/load-data.html
Unless REPLACE is also specified, LOCAL has the same effect as the IGNORE modifier on the interpretation of input file contents and error handling; see Duplicate-Key and Error Handling, and Column Value Assignment. For example, if mysqld was started ...The file can be read from the server host or the client host, depending on whether the LOCAL modifier is ...
https://dev.mysql.com/doc/refman/8.4/en/ldap-pluggable-authentication.html
Table 8.22 System variables for SASL-based and simple LDAP Authentication System Variable Name Default Timeout Value authentication_ldap_sasl_connect_timeout 30 seconds authentication_ldap_sasl_response_timeout 30 seconds ...With this plugin-loading ... Note LDAP pluggable authentication is an extension included in MySQL Enterprise Edition, a commercial ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-wait-summary-tables.html
row *************************** EVENT_NAME: wait/synch/mutex/sql/BINARY_LOG::LOCK_index COUNT_STAR: 8 SUM_TIMER_WAIT: 2119302 MIN_TIMER_WAIT: 196092 AVG_TIMER_WAIT: 264912 MAX_TIMER_WAIT: 569421 ... row *************************** EVENT_NAME: ...