Search Results
https://dev.mysql.com/doc/mysql-errors/8.4/en/server-error-reference.html
The maximum row size for the used table type, not counting BLOBs, is %ld. Transaction rolled back and must be restarted Error number: 1624; Symbol: ER_REPLICA_HEARTBEAT_VALUE_OUT_OF_RANGE; SQLSTATE: HY000 Message: The requested value for the ... The ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-max-allowed-packet.html
max_allowed_packet sets an upper limit on the size of any single message between the MySQL server and clients, including replicas. If you are replicating large column values (such as might be found in TEXT or BLOB columns) and max_allowed_packet is ...Row-based replication sends all columns and column values for updated rows from the source to the replica, including values of columns that were not actually changed by the ...
https://dev.mysql.com/doc/refman/8.4/en/server-system-variables.html
Example: Suppose that the block size for a given variable is given as 4096, and you set the value of the variable to 100000 (we assume that the variable's maximum value is greater than this number). In some cases, the stated maximum for a variable ... The MySQL server maintains many system variables that affect its ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-system-variables.html
performance_schema_accounts_size Command-Line Format --performance-schema-accounts-size=# System Variable performance_schema_accounts_size Scope Global Dynamic No SET_VAR Hint Applies No Type Integer Default Value -1 (signifies autoscaling; do not ...The Performance Schema automatically sizes the values of several of its parameters at server startup if they are not set ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-config-metric-performanceschema-category.html
Digests Size The maximum number of rows in the events_statements_summary_by_digest table. Max Digest Length The maximum number of bytes available for computing statement digests. Max Digest Sample Age The query resample age (in seconds) for the ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-parameters.html
innodb_adaptive_flushing_lwm Command-Line Format --innodb-adaptive-flushing-lwm=# System Variable innodb_adaptive_flushing_lwm Scope Global Dynamic Yes SET_VAR Hint Applies No Type Integer Default Value 10 Minimum Value 0 Maximum Value 70 Defines ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-conflict-resolution.html
Some types of conflict resolution supported by NDB Cluster (NDB$OLD(), NDB$MAX(), and NDB$MAX_DELETE_WIN(); NDB$MAX_INS() and NDB$MAX_DEL_WIN_INS()) implement this user-defined column as a “timestamp” column (although its type cannot be ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-relation-functions-mbr.html
In other words, it is the rectangle bounded by the points (min(x), min(y)), (min(x), max(y)), (max(x), max(y)), and (max(x), min(y)), where min() and max() represent the geometry's minimum and maximum x-coordinate or y-coordinate, respectively. That ... MySQL provides several MySQL-specific functions that test the relationship between minimum bounding rectangles (MBRs) of two geometries g1 and ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-config.html
ndb_config can also provide an offline dump of all configuration parameters which can be used, along with their default, maximum, and minimum values and other information. --config_from_node=# Command-Line Format --config-from-node=# Type Numeric ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-config-metric-innodbconfiguration-category.html
Adaptive Max Sleep Delay Allows InnoDB to automatically adjust the value of innodb_thread_sleep_delay up or down according to the current workload. Change Buffer Max Size Maximum size for the InnoDB change buffer, as a percentage of the total size ... Lists the InnoDB Configuration configuration metrics and provides a brief description of ...