Search Results
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-metrics-table.html
(The _RESET columns act like the lap counter on a stopwatch: you can measure the activity during some time interval, while the cumulative figures are still available in COUNT, MAX_COUNT, and so on.) MAX_COUNT_RESET The maximum counter value since it ...row *************************** NAME: dml_inserts SUBSYSTEM: dml COUNT: 3 MAX_COUNT: 3 MIN_COUNT: NULL AVG_COUNT: 0.046153846153846156 COUNT_RESET: 3 MAX_COUNT_RESET: 3 MIN_COUNT_RESET: NULL AVG_COUNT_RESET: NULL TIME_ENABLED: 2014-12-04 14:18:28 TIME_DISABLED: NULL TIME_ELAPSED: 65 TIME_RESET: NULL STATUS: enabled TYPE: status_counter COMMENT: Number of rows inserted Notes You must have the PROCESS privilege to query this ...
https://dev.mysql.com/doc/refman/8.4/en/switchable-optimizations.html
The amount of memory used for hashing by this optimization can be controlled using the set_operations_buffer_size system variable; increasing this generally results in faster execution times for statements using these operations. This variable has ...Its value is a set of flags, each of which has a value of on or off to indicate whether the corresponding optimizer behavior is enabled or ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-consistent-read.html
A consistent read means that InnoDB uses multi-versioning to present to a query a snapshot of the database at a point in time. The query sees the changes made by transactions that committed before that point in time, and no changes made by later or ...The exception to this rule is that the query sees the changes made by earlier statements within the same ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-hash.html
You should also keep in mind that this expression is evaluated each time a row is inserted or updated (or possibly deleted); this means that very complex expressions may give rise to performance issues, particularly when performing operations (such ... Partitioning by HASH is used primarily to ensure an even distribution of data among a predetermined number of ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-ml-model-metadata.html
training_time: number The time in seconds taken to train the model. It also records any error messages that occur during model training. Error: Either training was canceled or an error occurred during training. build_timestamp: number A timestamp ...
https://dev.mysql.com/doc/refman/8.4/en/pluggable-authentication.html
The server then authenticates the client, determining from the account row which authentication plugin applies to the client: If the server cannot find the plugin, an error occurs and the connection attempt is rejected. Use cases for this plugin ...
https://dev.mysql.com/doc/workbench/en/wb-migration-install-odbc-drivers.html
Typically you need to provide a name for the data source (the DSN), in addition to the database server IP, port, username, and sometimes the database the user has access to. For each RDBMS, you need its corresponding ODBC driver, which must also be ...
https://dev.mysql.com/doc/internals/en/delete-row.html
Synopsis virtual int delete_row ( buf); const byte * buf ; Description This is the delete_row method. buf will contain a copy of the row to be deleted. The server will call this right after the current row has been called (from either a previous ...
https://dev.mysql.com/doc/internals/en/handler-instantiation.html
The first method call your storage engine needs to support is the call for a new handler instance. Before the handlerton is defined in the storage engine source file, a method header for the instantiation method must be defined. Here is an example ...
https://dev.mysql.com/doc/refman/8.4/en/replication-mode-change-online-enable-gtids.html
The following procedure can be paused at any time and later resumed where it was, or reversed by jumping to the corresponding step of Section 19.1.4.3, “Disabling GTID Transactions Online”, the online procedure to disable GTIDs. On each server, ... This section describes how to enable GTID transactions, and optionally auto-positioning, on servers that are already online and using anonymous ...