Search Results
https://dev.mysql.com/doc/internals/en/implementing-store-lock-method.html
Allow concurrent insert */ TL_READ_NO_INSERT, /* READ, Don't allow concurrent insert */ TL_WRITE_ALLOW_WRITE, /* Write lock, but allow other threads to read / write. The [custom-engine.html#custom-engine-api-reference-store_lock store_lock()] ...
https://dev.mysql.com/doc/internals/en/multi-resultset.html
In our case we inserted 2 rows, but only the affected_rows of the last INSERT statement is returned as part of the OK_Packet. 01 31 00 0c 3f 00 01 00 00 00 08 81 00 00 00 00 .1..?........... 05 00 00 03 fe 00 00 0a 00 02 00 00 04 01 31 05 ...
https://dev.mysql.com/doc/internals/en/store-lock.html
The idea with handler::store_lock() is the following: The statement decided which locks we should need for the table for updates/deletes/inserts we get WRITE locks, for SELECT... */ THR_LOCK_DATA **ha_archive::store_lock(THD *thd, THR_LOCK_DATA ...
https://dev.mysql.com/doc/internals/en/the-myi-file.html
A .MYI file for a MyISAM table contains the table's indexes. The .MYI file has two parts: the header information and the key values. So the next sub-sections will be "The .MYI Header" and "The .MYI Key Values". The .MYI Header A .MYI file begins ...
https://dev.mysql.com/doc/internals/en/user-level-locks.html
SELECT GET_LOCK("mysqltest1", 10); # INSERT must wait in background for the SQL lock on t1 to go away. send INSERT INTO t1 VALUES (1); --connection conn1 # Wait in background until the insert times out and releases the # user level lock. send SELECT ... User-level locks are controlled with the SQL functions GET_LOCK(str,timeout) IS_FREE_LOCK(str) IS_USED_LOCK(str) RELEASE_LOCK(str) They can be used at places where SQL statements accept SQL ...
https://dev.mysql.com/doc/ndbapi/en/ndb-ndboperation.html
When using insertTuple(), you may also define the search key with setValue(). NdbOperation::insertTuple() Description This method defines the NdbOperation to be an INSERT operation. To set a NULL value, use the following construct: ...Beginning with ...
https://dev.mysql.com/doc/relnotes/connector-python/en/news-8-0-32.html
(Bug #108733, Bug #34689812) The MySQLCursor.executemany() method failed to batch insert data because the regular expression (RE) sentinel did not detect batch cases correctly; this meant using a one-on-one insert instead, which led to poor ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/working-with-sql-result-sets.html
An SqlResult combines a result set produced by, for example, INSERT, and a data set, produced by, for example, SELECT in one. An SqlResult instance exports methods for accessing data and to retrieving the last inserted ID or number of affected rows.
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/working-with-sql-result-sets.html
An SqlResult combines a result set produced by, for example, INSERT, and a data set, produced by, for example, SELECT in one. An SqlResult instance exports methods for accessing data and to retrieving the last inserted ID or number of affected rows.
https://dev.mysql.com/doc/relnotes/heatwave/en/news-8-0-24.html
For example, the following query, where L_LINESTATUS is a VARLEN-encoded string column, can now be offloaded to MySQL HeatWave: SELECT COUNT(*) FROM lineitem WHERE L_LINESTATUS >= 1 and L_LINESTATUS <= 10; (Bug #31721399) MySQL HeatWave now supports ... Functionality Added or Changed Comparison of different temporal type values is now ...