Search Results
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/mysql-em-plugin/en/myoem-config-metric-connectionbuffers-category.html
Table 7.8 Connection Buffers Configuration Metrics NameDescriptionBulk Insert Buffer Size Limits the size (in bytes) of the special tree-like cache MyISAM uses to make bulk inserts faster for INSERT ... Lists the Connection Buffers configuration ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-metric-innodb-rowactivity-category.html
Rows Inserted (Delta) The number of rows inserted into InnoDB tables. Rows Inserted Per Sec (Delta) The number of rows inserted per second by InnoDB. Lists the InnoDB Row Activity metrics and provides a brief description of each. Table 6.15 InnoDB ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-metric-sysschema-tablestatistics-category.html
Insert Latency The total wait time of timed insert IO events for the table. Lists the Sys Schema Table Statistics metrics and provides a brief description of each. Table 6.42 Sys Schema Table Statistics Metrics NameDescriptionDelete Latency The ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-performance-page-per-table-stats.html
Insert Latency The total wait time of timed insert I/O events for the table. Rows Inserted The total number of rows inserted into the table. By default, rows are sorted by descending total wait time (tables with most contention first). Table 5.10 ...