Search Results
https://dev.mysql.com/doc/relnotes/mysql-cluster/8.4/en/news-8-3-0.html
(Bug #30930132) Online table reorganization inserts rows from existing table fragments into new table fragments; then, after committing the inserted rows, it deletes the original rows. (Bug #35857936) It was possible for ssl_write() to receive a ...
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/refman/8.4/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/8.4/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 ...
https://dev.mysql.com/doc/refman/8.4/en/grant-tables.html
Note Direct modification of grant tables using statements such as INSERT, UPDATE, or DELETE is discouraged and done at your own risk. The server reads the contents of the grant tables into memory when it starts. The mysql system database includes ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-ft-index-cache-table.html
The INNODB_FT_INDEX_CACHE table provides token information about newly inserted rows in a FULLTEXT index. The INNODB_FT_INDEX_CACHE table has these columns: WORD A word extracted from the text of a newly inserted row. Before querying it, set the ...