Search Results
https://dev.mysql.com/doc/refman/9.7/en/innodb-buffer-pool.html
When InnoDB reads a page into the buffer pool, it initially inserts it at the midpoint (the head of the old sublist). For efficiency of high-volume read operations, the buffer pool is divided into pages that can potentially hold multiple rows. This ... The buffer pool is an area in main memory where InnoDB caches table and index data as it is ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-lakehouse.html
Use ML_PREDICT_ROW and ML_EXPLAIN_ROW with Lakehouse Data To avoid using the FROM clause, you can insert the data to predict and explain directly into a JSON object. mysql> CALL sys.ML_MODEL_LOAD(@bank_model, NULL); Insert the data to predict and ...
https://dev.mysql.com/doc/connectors/en/connector-j-connp-props-performance-extensions.html
Default Value 0 Since Version 3.1.9 dontCheckOnDuplicateKeyUpdateInSQL Stops checking if every INSERT statement contains the "ON DUPLICATE KEY UPDATE" clause. 'Statement.getGeneratedKeys()', for statements that are rewritten only works when the ...
https://dev.mysql.com/doc/internals/en/implementing-store-lock-method.html
Before adding the lock into the table lock handler mysqld calls store lock with the requested locks. Allow concurrent insert */ TL_READ_NO_INSERT, /* READ, Don't allow concurrent insert */ TL_WRITE_ALLOW_WRITE, /* Write lock, but allow other threads ... The [custom-engine.html#custom-engine-api-reference-store_lock store_lock()] method is called before any reading or writing is ...
https://dev.mysql.com/doc/internals/en/user-level-locks.html
send INSERT INTO t1 VALUES (1); --connection conn1 # Wait in background until the insert times out and releases the # user level lock. SELECT GET_LOCK("mysqltest1", 10); # INSERT must wait in background for the SQL lock on t1 to go away. 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/relnotes/heatwave/en/news-8-0-24.html
SELECT statements where the SELECT query is offloaded to MySQL HeatWave and the result set is inserted into a table on the MySQL Database Service instance. For example, the following query, where L_LINESTATUS is a VARLEN-encoded string column, can ... Functionality Added or Changed Comparison of different temporal type values is now ...
https://dev.mysql.com/doc/connector-j/en/connector-j-connp-props-performance-extensions.html
Default Value 0 Since Version 3.1.9 dontCheckOnDuplicateKeyUpdateInSQL Stops checking if every INSERT statement contains the "ON DUPLICATE KEY UPDATE" clause. 'Statement.getGeneratedKeys()', for statements that are rewritten only works when the ...
https://dev.mysql.com/doc/relnotes/connector-j/en/news-9-1-0.html
(Bug #113509, Bug #36154975) After using executeBatch() to insert rows into a table and adding more rows with executeUpdate(), getGeneratedKeys() returned the wrong keys for the inserted rows. (Bug #36936407) When using PreparedStatements, negative ... Version 9.1.0 is a new GA release of MySQL ...
https://dev.mysql.com/doc/refman/9.7/en/binary-log.html
Within an uncommitted transaction, all updates (UPDATE, DELETE, or INSERT) that change transactional tables such as InnoDB tables are cached until a COMMIT statement is received by the server. If you are using the binary log and row based logging, ... The binary log contains “events” that describe database changes such as table creation operations or changes to table ...
https://dev.mysql.com/doc/refman/9.7/en/comparison-operators.html
For details, including the return value after a multiple-row insert, see Section 14.15, “Information Functions”. If no AUTO_INCREMENT value was successfully inserted, the SELECT statement returns no row. Table 14.4 Comparison Operators Name ...