Search Results
https://dev.mysql.com/doc/refman/8.4/en/packet-too-large.html
When a MySQL client or the mysqld server receives a packet bigger than max_allowed_packet bytes, it issues an ER_NET_PACKET_TOO_LARGE error and closes the connection. With some clients, you may also get a Lost connection to MySQL server during query ... A communication packet is a single SQL statement sent to the MySQL server, a single row that is sent to the client, or a binary log event sent from a replication source server to a ...
https://dev.mysql.com/doc/mysql-errors/8.4/en/server-error-reference.html
Please do "ALTER TABLE `%s` FORCE" or dump/reload to fix it! Error number: 1708; Symbol: WARN_OPTION_BELOW_LIMIT; SQLSTATE: HY000 Message: The value of '%s' should be no less than the value of '%s' Error number: 1709; Symbol: ...The maximum row size ...The statement that waited too long was rolled back (not the entire ... The MySQL server writes ...
https://dev.mysql.com/doc/refman/8.4/en/large-page-support.html
Standard use of large pages in MySQL attempts to use the largest size supported, up to 4MB. This is the size of the InnoDB buffer pool divided by the large page size, which we can calculate as innodb_buffer_pool_size / Hugepagesize. Check any ...
https://dev.mysql.com/doc/refman/8.4/en/too-many-connections.html
If clients encounter Too many connections errors when attempting to connect to the mysqld server, all available connections are in use by other clients. The permitted number of connections is controlled by the max_connections system variable. The ...
https://dev.mysql.com/doc/internals/en/too-greedy-test.html
Let's assume we have to check that every new created table causes a row in information_schema.tables. --replace_column 15 <CREATE_TIME> 16 <UPDATE_TIME> 17 <CHECK_TIME> SELECT * FROM information_schema.tables; The SELECT above makes the test ...
https://dev.mysql.com/doc/internals/en/avoid-too-dense-code.html
except you intend to check the parser or the performance of the reader of the code ;-). Unfortunate example: select 1+1,1-1,1+1*2,8/5,8%5,mod(8,5),mod(8,5)|0,-(1+1)*-2; Improved example: SELECT 1 + 1, 1 - 1, 1 + 1 * 2, 8 / 5, 8 % 5, MOD(8,5), ...
https://dev.mysql.com/doc/ndbapi/en/ndb-error-codes-single.html
Out of transaction memory in local data manager, acc scan operation (increase SharedGlobalMemory) QRY_BATCH_SIZE_TOO_SMALL MySQL error. Encryption password is too long (see 'HELP START BACKUP') 1311 MySQL error. Out of logbuffer memory(specify ...
https://dev.mysql.com/doc/refman/8.4/en/table-size-limit.html
Generally, partitioning of tables into multiple tablespace files is recommended for tables larger than 1TB in size. MyISAM permits data and index files to grow up to 256TB by default, but this limit can be changed up to the maximum permissible size ... The effective maximum table size for MySQL databases is usually determined by operating system constraints on file sizes, not by MySQL internal ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-heatwave-estimate-cluster-size.html
Table 4-1 Cluster Size Table Warnings Table Status Issue Description TOO MANY COLUMNS TO LOAD The table has too many columns. Estimating Cluster Memory Size with MySQL HeatWave Autopilot 4.1.1 Estimating Cluster Memory Size with MySQL HeatWave ...
https://dev.mysql.com/doc/refman/8.4/en/column-count-limit.html
mysql> CREATE TABLE t (a VARCHAR(10000), b VARCHAR(10000), c VARCHAR(10000), d VARCHAR(10000), e VARCHAR(10000), f VARCHAR(10000), g VARCHAR(6000)) ENGINE=InnoDB CHARACTER SET latin1; ERROR 1118 (42000): Row size too large. You have to change some ...Row Size Limits The maximum row size for a given table is determined by several factors: The internal representation of a MySQL table has a maximum row size limit of 65,535 bytes, even if the storage engine is capable of supporting larger ...