Search Results
https://dev.mysql.com/doc/refman/8.4/en/internal-temporary-tables.html
For such tables, only the max_heap_table_size variable determines how large a table can grow, and there is no conversion to on-disk format. When using the MEMORY storage engine for in-memory temporary tables (internal_tmp_mem_storage_engine=MEMORY), ...SELECT statements that select from and insert into the same table, MySQL creates an internal temporary table to hold the rows from the SELECT, then inserts those rows into the target ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-replica.html
If you need to put the relay logs in some area other than the data directory because your relay logs tend to be very large and you do not want to decrease max_relay_log_size. The setting for replica_max_allowed_packet must be larger than the ...
https://dev.mysql.com/doc/internals/en/files-in-innodb-sources.html
\data (DATA) File Name What Name Stands For Size Comment Inside File --------- -------------------- ------ ------------------- data0data.c Data / Data 15,344 SQL data field and tuple data0type.c Data / Type 7,417 Data types This is a collection of ...The format of each section will be like this every time: \subdirectory-name (LONGER EXPLANATORY NAME) File Name What Name Stands For Size Comment Inside File file-name my-own-guess in-bytes from-the-file-itself ...
https://dev.mysql.com/doc/ndbapi/en/ndb-error-codes-temporary-resource-error.html
The following list enumerates all NDB errors of type TR (Temporary Resource error).
https://dev.mysql.com/doc/refman/8.4/en/replication-options-binary-log.html
Where possible, rows stored in the binary log are grouped into events with a size not exceeding the value of this setting. If you often use large transactions, you can increase this cache size to get better performance by reducing or eliminating the ...If an event cannot be split, the maximum size can be ... Startup Options Used with Binary Logging System Variables Used with Binary Logging You can use the mysqld options and system variables that are described in this section to affect the operation of the binary log as well ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-persistent-stats.html
row *************************** database_name: sakila table_name: actor last_update: 2014-05-28 16:16:44 n_rows: 200 clustered_index_size: 1 sum_of_other_index_sizes: 1 ...mysql> SELECT * FROM innodb_index_stats \G *************************** 1. row ...Increasing innodb_stats_persistent_sample_pages too much, however, could cause ANALYZE TABLE to run ... The persistent optimizer statistics feature improves plan stability by storing statistics to disk and making them persistent across ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-page-compression.html
row *************************** SPACE: 45 NAME: employees/employees FS_BLOCK_SIZE: 4096 FILE_SIZE: 23068672 ALLOCATED_SIZE: 19415040 Page compression metadata for the employees table shows that the apparent file size is 23068672 bytes while the ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-system-variables.html
group_replication_communication_max_message_size must be less than replica_max_allowed_packet, because the applier thread cannot handle message fragments larger than the maximum permitted packet size. Transactions larger than this size are rolled ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-undo-tablespaces.html
In this case, if the file extension size is larger than 16MB, and the previous file extension occurred within the last second, the new undo tablespace is created at a quarter of the size defined by the innodb_max_undo_log_size variable. To handle ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-limits.html
ERROR 1070 (42000): Too many key parts specified; max 16 parts allowed The maximum row size, excluding any variable-length columns that are stored off-page, is slightly less than half of a page for 4KB, 8KB, 16KB, and 32KB page sizes. Although ...