Search Results
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-remote.html
You can estimate the size of your data by checking the data directory size on your file system and the size of any tablespaces that reside outside of the data directory. When estimating data size on the donor, remember that only InnoDB data is ...
https://dev.mysql.com/doc/refman/8.4/en/mysqld-safe.html
--core-file-size=size Command-Line Format --core-file-size=size Type String The size of the core file that mysqld should be able to create. Note The innodb_buffer_pool_in_core_file variable can be used to reduce the size of core files on operating ... mysqld_safe is the recommended way to start a mysqld server on ...
https://dev.mysql.com/doc/refman/8.4/en/structured-system-variables.html
A key cache structured variable has these components: key_buffer_size key_cache_block_size key_cache_division_limit key_cache_age_threshold This section describes the syntax for referring to structured variables. Examples: hot_cache.key_buffer_size ... A structured variable differs from a regular system variable in two respects: Its value is a structure with components that specify server parameters considered to be closely ...
https://dev.mysql.com/doc/internals/en/com-query-response.html
It is made up of two parts: the column definitions the rows which consist of a sequence of packets. In case the query could generate the column-definition, but generating the rows afterwards failed, a ERR_Packet may be sent instead of the last ...
https://dev.mysql.com/doc/refman/8.4/en/show-processlist.html
The SHOW PROCESSLIST statement is very useful if you get the “too many connections” error message and want to find out what is going on. row *************************** Id: 1 User: system user Host: db: NULL Command: Connect Time: 1030455 State: ... SHOW [FULL] PROCESSLIST Important The INFORMATION SCHEMA implementation of SHOW PROCESSLIST is deprecated and subject to removal in a future MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-issues.html
In other words, the replication line (indicated by the curved arrows in the diagram) directly connects all SQL nodes used as sources and replicas. This type of circular replication scheme for NDB Cluster, in which the line of replication (again ...
https://dev.mysql.com/doc/refman/8.4/en/query-log.html
However, when using row-based binary logging, updates are sent as row changes rather than SQL statements, and thus these statements are never written to the query log when binlog_format is ROW. See Section 19.2.1.1, “Advantages and Disadvantages ... The general query log is a general record of what mysqld is ...
https://dev.mysql.com/doc/internals/en/innodb-field-start-offsets.html
There are two complications for special cases: Complication #1: The size of each offset can be either one byte or two bytes. One-byte offsets are only usable if the total record size is less than 127. There is a flag in the "Extra Bytes" part which ... The Field Start Offsets is a list in which each entry is the position, relative to the Origin, of the start of the next ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-config-metric-innodbfulltext-category.html
Cache Size Size of the cache that holds a parsed document in memory while creating an InnoDB FULLTEXT index. Max Token Size Maximum length of words that are stored in an InnoDB FULLTEXT index. Min Token Size Minimum length of words that are stored ... Lists the InnoDB Fulltext configuration metrics and provides a brief description of ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-doublewrite-buffer.html
Data is written to the doublewrite buffer in a large sequential chunk, with a single fsync() call to the operating system (except in the case that innodb_flush_method is set to O_DIRECT_NO_FSYNC). The default size of a flush list doublewrite file is ... The doublewrite buffer is a storage area where InnoDB writes pages flushed from the buffer pool before writing the pages to their proper positions in the InnoDB data ...