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/relnotes/connector-python/en/news-8-0-31.html
Functionality Added or Changed Bugs Fixed Functionality Added or Changed Added support for Python 3.11. (WL #15156) Bugs Fixed The pure Python implementation unexpectedly delivered TEXT columns having binary (_bin) collations as byte objects. (Bug ...
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/account-names.html
MySQL account names consist of a user name and a host name, which enables creation of distinct accounts for users with the same user name who connect from different hosts. This section describes the syntax for account names, including special ...