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/blob.html
The maximum size of a BLOB or TEXT object is determined by its type, but the largest value you actually can transmit between the client and server is determined by the amount of available memory and the size of the communications buffers. A BLOB is ...These differ only in the maximum length of the values they can ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-message-compression.html
Messages that have a payload larger than the specified number of bytes are compressed. Note that the maximum supported input size for the LZ4 compression algorithm is 2113929216 bytes. This limit is lower than the maximum possible value for the ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-status-monitoring.html
Increasing the maximum number of connections or the maximum size of some buffers increases the maximum number of instances that might be allocated at once. When the server cannot create a mutex instrument, these results occur: No row for the ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-porting-mysql.html
When using functions such as AVG(), which depend on the number of rows in the result set, include WHERE clauses to filter out non-numeric values. row *************************** name: aaa db_schema: test db_table: demo_test key_columns: c1 ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-multi-versioning.html
Otherwise, InnoDB cannot discard data from the update undo logs, and the rollback segment may grow too big, filling up the undo tablespace in which it resides. The physical size of an undo log record in the rollback segment is typically smaller than ...It keeps information about old versions of changed rows to support transactional features such as concurrency and ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-benefits.html
InnoDB tables can handle large quantities of data, even on operating systems where file size is limited to 2GB. Performance benefits are not limited to large tables with long-running queries. When the same rows are accessed over and over from a ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-import.html
ADDED: NDB 8.0.30 --monitor=# Periodically print status of running job if something has changed (status, rejected rows, temporary errors). Default is 0 which means that any rejected row causes a fatal error. Prior to NDB 8.0.28, the order of the ...
https://dev.mysql.com/doc/refman/8.0/en/string-type-syntax.html
The effective maximum length of a VARCHAR is subject to the maximum row size (65,535 bytes, which is shared among all columns) and the character set used. See Section 10.4.7, “Limits on Table Column Count and Row Size”. If this is done, MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-temporary-tablespace.html
row *************************** FILE_NAME: ./ibtmp1 TABLESPACE_NAME: innodb_temporary ENGINE: InnoDB INITIAL_SIZE: 12582912 TotalSizeBytes: 12582912 DATA_FREE: 6291456 MAXIMUM_SIZE: NULL TotalSizeBytes shows the current size of the global temporary ...The size of the pool never shrinks and tablespaces are added to the pool automatically as ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-flow-control.html
The replication protocol provides a mechanism to avoid having too much distance, in terms of transactions applied, between fast and slow members. Whenever the size of one of these queues exceeds the user-defined threshold, the throttling mechanism ... MySQL Group Replication ensures that a transaction commits only after a majority of the members in a group have received it and agreed on the relative order amongst all transactions sent ...