Search Results
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-cluster-metric-mysqlserver-ddlstatementactivity-category.html
Table 8.3 DDL Statement Activity Metrics Target NameName of the OEM TargetAlter DB (Delta) The total number of ALTER DATABASE statements executed. Alter Event (Delta) The total number of ALTER EVENT statements executed. Alter Function (Delta) The ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-tablespace-autoextend-size.html
By default, when a file-per-table or general tablespace requires additional space, the tablespace is extended incrementally according to the following rules: If the tablespace is less than an extent in size, it is extended one page at a time. If ...
https://dev.mysql.com/doc/connectors/en/connector-j-multi-host-connections.html
The following sections discuss a number of topics that involve multi-host connections, namely, server load-balancing, failover, and replication. Developers should know the following things about multi-host connections that are managed through ...
https://dev.mysql.com/doc/internals/en/com-binlog-dump.html
Requests a binlog network stream from the master starting a given position. You can use SHOW BINARY LOGS to get the current logfile and position from the master. The master responds either with a binlog network stream a ERR_Packet or (if ...
https://dev.mysql.com/doc/internals/en/mismatch-of-focus-of-test-and-code-sequence.html
CREATE TABLE t1 ( id INT NOT NULL AUTO_INCREMENT, my_column VARCHAR(30), name LONGTEXT, PRIMARY KEY (id)); INSERT INTO t1(my_column,name) VALUES('2','two'); INSERT INTO t1(my_column,name) VALUES('1','one'); INSERT INTO t1(my_column,name) ...
https://dev.mysql.com/doc/internals/en/optimizer-transpositions.html
MySQL supports transpositions (reversing the order of operands around a relational operator) for simple expressions only. In other words: WHERE - 5 = column1 becomes: WHERE column1 = -5 However, MySQL does not support transpositions where ...
https://dev.mysql.com/doc/internals/en/replication-organization.html
We distinguish between two levels of the architecture: principles, and rules: principle High-level goal that declares how the program shall work, from an external point of view. An example of a principle is "no row events shall be written to the ...
https://dev.mysql.com/doc/ndbapi/en/overview-mgm-api.html
The NDB Cluster Management API, also known as the MGM API, is a C-language programming interface intended to provide administrative services for the cluster. These include starting and stopping NDB Cluster nodes, handling NDB Cluster logging, ...
https://dev.mysql.com/doc/refman/8.4/en/regexp.html
To control the maximum number of steps performed by the engine (and thus indirectly the execution time), set the regexp_time_limit system variable. Because this limit is expressed as number of steps, it affects execution time only indirectly. A - ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-logging.html
innodb_log_wait_for_flush_spin_hwm: Defines the maximum average log flush time beyond which user threads no longer spin while waiting for flushed redo. On a system with a multi-core processor, a value of 150 represents 100% usage of one CPU core ...