PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/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/refman/8.0/en/server-system-variables.html
Unless a Block Nested-Loop or Batched Key Access algorithm is used, there is no gain from setting the buffer larger than required to hold each matching row, and all joins allocate at least the minimum size, so use caution in setting this variable to ...Starting the server with --skip-host-cache does not prevent runtime changes to the value of host_cache_size, but such changes have no effect and the cache is not re-enabled even if host_cache_size is set larger ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html
innodb_strict_mode=ON also enables a row size check when creating or altering a table, to prevent INSERT or UPDATE from failing due to the record being too large for the selected page size. Use innodb_ft_result_cache_limit to place a size limit on ...If you set the value too large, the amount of undo or redo data could impose some storage overhead, as with any long-running ...The --innodb-status-file option is intended for temporary use, as ...
https://dev.mysql.com/doc/refman/8.0/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.0/en/mysql-cluster-ndbd-definition.html
You can estimate the size of a hash index using this formula: size = ( (fragments * 32K) + (rows * 18) ) * fragment_replicas fragments is the number of fragments, fragment_replicas is the number of fragment replicas (normally 2), and rows is the ...
https://dev.mysql.com/doc/refman/8.0/en/glossary.html
Large fields are stored away from the page that holds the rest of the row data, as in dynamic row format. Because long variable-length column values are stored outside of the page that holds the row data, it is very efficient for rows that include ...It saves work for the developer, not to have to produce new unique values when inserting new ...
https://dev.mysql.com/doc/refman/8.0/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 ...
https://dev.mysql.com/doc/refman/8.0/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/refman/8.0/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/refman/8.0/en/innodb-row-format.html
Tables with many BLOB columns could cause B-tree nodes to become too full, and contain too few rows, making the entire index less efficient than if rows were shorter or column values were stored off-page. Tables with many BLOB columns could cause ...