PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
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/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 ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-examples.html
The Performance Schema is a tool to help a DBA do performance tuning by taking real measurements instead of “wild guesses.” This section demonstrates some ways to use the Performance Schema for this purpose. To begin, you should have a ...The ...
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/show-table-status.html
The WHERE clause can be given to select rows using more general conditions, as discussed in Section 28.8, “Extensions to SHOW Statements”. For InnoDB tables, the row count is only a rough estimate used in SQL optimization. (This is also true if ... SHOW TABLE STATUS [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW TABLE STATUS works likes SHOW TABLES, but provides a lot of information about each non-TEMPORARY ...
https://dev.mysql.com/doc/refman/8.0/en/binary-log-transaction-compression.html
If your replication topology handles large transactions, be aware that a large transaction which can be replicated successfully when binary log transaction compression is not in use, might stop replication due to its size when binary log transaction ...Binary log transaction compression is only applied for the row-based binary logging ... Beginning with ...
https://dev.mysql.com/doc/refman/8.0/en/fulltext-stopwords.html
Maximum and minimum word length values are configurable using the innodb_ft_max_token_size and innodb_ft_min_token_size variables. The stopword list is loaded and searched for full-text queries using the server character set and collation (the ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-disk-data-objects.html
This log file group is to be made up of two undo log files, which we name undo_1.log and undo_2.log, whose initial sizes are 16 MB and 12 MB, respectively. (The default initial size for an undo log file is 128 MB.) Optionally, you can also specify a ... NDB Cluster Disk Data storage is implemented using the following objects: Tablespace: Acts as containers for other Disk Data ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-innodb-transaction-management.html
Avoid performing rollbacks after inserting, updating, or deleting huge numbers of rows. To minimize the chance of this issue occurring: Increase the size of the buffer pool so that all the data change changes can be cached rather than immediately ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-limitations-syntax.html
Attempting to create an index on an NDB table column whose width is greater than 3072 bytes is rejected with ER_TOO_LONG_KEY: Specified key was too long; max key length is 3072 bytes. (The size of an NDB column index is always the same as the width ... Some SQL statements relating to certain MySQL features produce errors when used with NDB tables, as described in the following list: Temporary ...