Search Results
https://dev.mysql.com/doc/internals/en/logging-transactions-rules-for-non-committing-statements.html
The preliminary rules above, together with the principles for logging format, have been used to construct the following rules. CALL statements are unrolled (see ???TODO: add section about unrolling???), so that each statement executed by the stored ...
https://dev.mysql.com/doc/internals/en/not-so-fast-path.html
If the servers default auth method doesn't match the clients or accounts auth method a extra round is needed as usual. server uses mysql_native_password as default: 4d 00 00 00 0a 35 2e 36 2e 37 2d 6c 6f 67 00 01 M....5.6.7-log.. 00 00 00 51 5f 5a ...
https://dev.mysql.com/doc/internals/en/optimizer-partition-pruning.html
Partitions that did not get into this set (that is, those that were pruned away) will not be accessed at all: this is how query execution is made faster. With non-transactional tables such as MyISAM, locks are placed on entire partitioned table. It ...
https://dev.mysql.com/doc/internals/en/transactions-life-cycle.html
It will be filled in again by the next statement, and emptied again at the next statement's end. When a new connection is established, thd->transaction members are initialized to an empty state. If a statement uses any tables, all affected engines ...
https://dev.mysql.com/doc/mysqld-version-reference/en/options-variables.html
The following table shows all the options and variables available in MySQL Server. Intr: The version or versions in which the item was introduced. Depr: The version or versions in which the item was deprecated. Removed: The version or versions in ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-cluster-metric-mysqlserver-dmlstatementactivity-category.html
Lists the DML Statement Activity metrics and provides a brief description of each. Table 8.4 DML Statement Activity Metrics NameDescriptionTarget Name Name of the OEM Target Call Procedure (Delta) The total number of CALL statements executed.
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-metric-mysqlserver-dmlstatementactivity-category.html
Lists the DML Statement Activity metrics and provides a brief description of each. Table 6.6 DML Statement Activity Metrics NameDescriptionCall Procedure (Delta) The total number of CALL statements executed. Dealloc SQL (Delta) The total number of ...
https://dev.mysql.com/doc/x-devapi-userguide/en/sql-crud-functions.html
The following SQL CRUD functions are available in X DevAPI. Table.insert() The Table.insert() method works like an INSERT statement in SQL. It is used to store data in a relational table in the database. The example assumes that the test schema ...
https://dev.mysql.com/doc/refman/8.4/en/blackhole-storage-engine.html
This results in the replica attempting to replay two insert log entries using the same value for the primary key column, and so replication fails. The BLACKHOLE storage engine acts as a “black hole” that accepts data but throws it away and does ...
https://dev.mysql.com/doc/refman/8.4/en/connection-control-plugin-installation.html
This section describes how to install the connection control plugins, CONNECTION_CONTROL and CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS. For general information about installing plugins, see Section 7.6.1, “Installing and Uninstalling Plugins”.