Search Results
https://dev.mysql.com/doc/refman/8.4/en/data-size.html
(InnoDB compressed tables are readable and writable, while MyISAM compressed tables are read-only.) For MyISAM tables, if you do not have any variable-length columns (VARCHAR, TEXT, or BLOB columns), a fixed-size row format is used. MySQL supports ... Design your tables to minimize their space on the ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-size-pl.html
ndb_size.pl can also be found in the MySQL sources in storage/ndb/tools. Note ndb_size.pl is deprecated, and no longer supported, in NDB 8.4.3 and later. Options that can be used with ndb_size.pl are shown in the following table. Usage perl ... This ...
https://dev.mysql.com/doc/refman/8.4/en/key-cache-block-size.html
It is possible to specify the size of the block buffers for an individual key cache using the key_cache_block_size variable. The best performance for I/O operations is achieved when the size of read buffers is equal to the size of the native ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/glossary.html
To diagnose possible issues due to full table scans, choose a time period of heavy SQL activity from one of the graphs, use the Query Analyzer to locate queries that process large numbers of rows, and examine the explain plan for the queries. The ...
https://dev.mysql.com/doc/refman/8.4/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.4/en/password-too-long.html
This occurs when the library provided by the system to read passwords limits password values to a small number of characters (typically eight). That is a problem with the system library, not with MySQL. To work around it, change your MySQL password ...
https://dev.mysql.com/doc/refman/8.4/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 ...
https://dev.mysql.com/doc/refman/8.4/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 ...Memory allocation time can cause substantial performance drops if the global size is larger than needed by most queries that use ...This means that when you ...
https://dev.mysql.com/doc/ndbapi/en/ndb-error-codes-application-error.html
NDB error code QRY_CHAR_OPERAND_TRUNCATED MySQL error DMEC Error message Character operand was right truncated NDB error code QRY_CHAR_PARAMETER_TRUNCATED MySQL error DMEC Error message Character Parameter was right truncated NDB error code ... The ...
https://dev.mysql.com/doc/refman/8.4/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 ...The following conditions apply when altering the innodb_buffer_pool_chunk_size value: If innodb_buffer_pool_chunk_size * innodb_buffer_pool_instances is larger than the current buffer pool size when the buffer pool is initialized, innodb_buffer_pool_chunk_size is truncated to innodb_buffer_pool_size / ...