Search Results
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/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/innodb-compression-tuning.html
Setting the compressed page size too large wastes some space, but the pages do not have to be compressed as often. You can expect less compression from a MySQL compressed table than from file-based compression tools, because MySQL compresses data in ...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 ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-max-allowed-packet.html
Also, in row-based replication, a single event can be significantly larger than the max_allowed_packet size, because the value of max_allowed_packet only limits each column of the table. If you are replicating large column values (such as might be ... max_allowed_packet sets an upper limit on the size of any single message between the MySQL server and clients, including ...
https://dev.mysql.com/doc/refman/8.4/en/create-table.html
You need to set this only for large tables with variable-size rows. (See Section 7.1.8, “Server System Variables”.) If you want all your tables to be able to grow above the default limit and are willing to have your tables slightly slower and ...
https://dev.mysql.com/doc/refman/8.4/en/connection-interfaces.html
To accommodate a large number of simultaneous connections, the stack size per thread must be kept small, leading to a situation where it is either too small or the server consumes large amounts of memory. In this connection thread model, there are ... This section describes aspects of how the MySQL server manages client ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-logging.html
Thus, if you have transactions that update, insert, or delete many rows, making the log buffer larger saves disk I/O. If you specify a value for innodb_log_write_ahead_size that is larger than the innodb_page_size value, the ... Consider the ...When ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-compliance-administration-standard-rules.html
To help ensure low levels of fragmentation, set the autoextend increment (the amount of space that the InnoDB tablespace will grow) to an amount that is large in size. Severity Minor Warning Advice Consider setting max_heap_table_size to be equal to ...When enabled, it causes a MySQL server to write informational log events such as row query log events to its binary ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-api-definition.html
Most scans are performed in parallel to protect the MySQL Server from receiving too much data from many nodes in parallel; this parameter sets a limit to the total batch size over all nodes. If you plan to deploy a large number of data nodes, it is ... The [mysqld] and [api] sections in the config.ini file define the behavior of the MySQL servers (SQL nodes) and other applications (API nodes) used to access cluster ...
https://dev.mysql.com/doc/refman/8.4/en/mysqldump.html
With large data sizes, even if the backup step takes a reasonable time, restoring the data can be very slow because replaying the SQL statements involves disk I/O for insertion, index creation, and so on. For large-scale backup and restore, a ...