Search Results
https://dev.mysql.com/doc/internals/en/starting-transaction-from-external-lock-method.html
MySQL calls [custom-engine.html#custom-engine-api-reference-external_lock handler::external_lock()] for every table it is going to use at the beginning of every statement. Note that because of pre-locking, all tables that can be potentially used ...
https://dev.mysql.com/doc/internals/en/wait-condition.html
If you are able to detect that the threads are in their blocked state by using SQL statements, then you can use this method. The remaining thread runs the statement(s) until the expected result is returned. In conn1 we use a SELECT statement that ...
https://dev.mysql.com/doc/relnotes/connector-cpp/en/news-8-0-6.html
Locks can be requested several times for a given find or select statement. (WL #10718) Boolean expressions used in queries and statements now support a variant of the IN operator for which the right hand side operand is any expression that evaluates ...An acquired lock is held until the end of the current ...
https://dev.mysql.com/doc/relnotes/connector-net/en/news-8-0-31.html
(Bug #107316, Bug #34189859) If an exception occurred during the execution of a SQL statement within a transaction, the subsequent transaction rollback produced a null reference exception, which could cause the Web server (IIS) process to halt ...
https://dev.mysql.com/doc/relnotes/connector-python/en/news-8-0-16.html
(WL #12864) For X DevAPI, performance for statements that are executed repeatedly (two or more times) is improved by using server-side prepared statements for the second and subsequent executions. Instead, the new values are passed to a new ...
https://dev.mysql.com/doc/relnotes/connector-python/en/news-9-3-0.html
(WL #16752) Bugs Fixed When executing a LOAD DATA LOCAL INFILE statement, Connector/Python now validates that the name of the client data file requested by the server (as part of the server's response) matches exactly the file name in the original ... Functionality Added or Changed Bugs Fixed Functionality Added or Changed Fixed the typing annotation of the close() function of MySQLConnectionAbstract and also made disconnect() an alias of close(), to improve clarity and consistency of the connection ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-compliance-replication-standard-rules.html
Turn on checksums by issuing a SET GLOBAL binlog_checksum = CRC32 statement. Turn on server verification of checksums by issuing a SET GLOBAL source_verify_checksum = ON statement. Turn on replica verification of checksums by issuing a SET GLOBAL ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-config-metric-insertdelayed-category.html
Table 7.17 Insert Delayed Configuration Metrics NameDescriptionInsert Limit After inserting delayed_insert_limit delayed rows, the INSERT DELAYED handler thread checks whether there are any SELECT statements pending. Insert Timeout How many seconds ... Lists the Insert Delayed configuration metrics and provides a brief description of ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-config-metric-security-category.html
Local Infile Enabled Whether LOCAL is supported for LOAD DATA INFILE statements. INTO OUTFILE statements to work only with files in that directory. Skip Show Database Enabled With this option, the SHOW DATABASES statement is permitted only to users ... Lists the Security configuration metrics and provides a brief description of ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-config-metric-tableconfiguration-category.html
Flush Enabled Whether to flush (synchronize) all changes to disk after each SQL statement. Lock Wait Timeout This timeout applies to all statements that use metadata locks. These include DML and DDL operations on tables, views, stored procedures, ...