Search Results
https://dev.mysql.com/doc/ndbapi/en/overview-selecting-tc.html
Note that this is only a hint; the system can be reconfigured at any time, in which case the NDB API chooses a transaction coordinator without using the hint. The default method is to select the transaction coordinator (TC) determined to be the ...
https://dev.mysql.com/doc/internals/en/notes-on-mtr2.html
NOTE: You can no longer be sure of executing test cases in a particular order due to this and other changes brought on by MTR2. MTR2 has brought some new utility that can improve testing, but also some elements that can be pitfalls. Changes ...
https://dev.mysql.com/doc/internals/en/support-for-insert.html
*/ if (table->next_number_field && buf == table->record[0]) update_auto_increment(); return mi_write(file,buf); } Three items of note in the preceding example include the updating of table statistics for writes, the setting of the timestamp prior to ... Once you have read support in your storage engine, the next feature to implement is support for INSERT ...
https://dev.mysql.com/doc/refman/8.4/en/sys-statement-analysis.html
max_latency The maximum single wait time of timed occurrences of the statement. err_count The total number of errors produced by occurrences of the statement. total_latency The total wait time of timed occurrences of the statement. avg_latency The ...The statement_analysis and x$statement_analysis views have these columns: query The normalized statement ...
https://dev.mysql.com/doc/connectors/en/connector-j-usagenotes-spring-config-connpooling.html
Pooling of connections also alleviates problems such as collecting large amounts of sockets in the TIME_WAIT state. The difference is that DBCP will pool connections to the database instead of creating a new connection every time one is requested.
https://dev.mysql.com/doc/ndbapi/en/ndb-start-mysql-db-object-names.html
This section discusses mapping of MySQL database objects to the NDB API. Databases and schemas are not represented by objects as such in the NDB API. Instead, they are modelled as attributes of Table and Index objects. The value of the database ...
https://dev.mysql.com/doc/internals/en/binary-log-structure-and-contents.html
The details about event structure have changed over time, which gives rise to different versions of the binary log format. The binary log is a set of files that contain information about data modifications made to a MySQL server instance. The log ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-fulltext_index-tables.html
Because the contents of INNODB_FT_BEING_DELETED typically have a short lifetime, this table has limited utility for monitoring or debugging. To avoid expensive index reorganization during DML operations, data for newly inserted rows remains in the ...INNODB_FT_BEING_DELETED: Provides a snapshot of the INNODB_FT_DELETED table; it is used only during an OPTIMIZE TABLE maintenance ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-logs-event-buffer.html
BUFFERED_EPOCHS_OVER_THRESHOLD: Whether the number of buffered epochs has exceeded the configured threshold. The report is generated every second until the number of buffered epochs goes below the threshold, which can be adjusted by setting the ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-metric-innodb-transactionactivity-category.html
Latest Foreign Key Error The latest foreign key error reported by SHOW ENGINE INNODB STATUS. Trx Id Counter2 The second 32bit internal transaction counter within InnoDB. Lists the InnoDB Transaction Activity metrics and provides a brief description ...