Search Results
https://dev.mysql.com/doc/internals/en/store-lock.html
*/ THR_LOCK_DATA **ha_archive::store_lock(THD *thd, THR_LOCK_DATA **to, enum thr_lock_type lock_type) { if (lock_type == TL_WRITE_DELAYED) delayed_insert= TRUE; else delayed_insert= FALSE; if (lock_type != TL_IGNORE && lock.type == TL_UNLOCK) { /* ...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 ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-9-2-0.html
(WL #16450) MySQL HeatWave now supports offloading the INSERT INTO SELECT queries to the secondary engine, even when the table being inserted into has triggers defined on it. This enables faster query execution and improved performance for workloads ...(WL #16546) MySQL HeatWave Bulk load, which is used for ingesting data into MySQL Server, now supports the following: Secondary indexes, which enable faster data loading and improved ...
https://dev.mysql.com/doc/refman/9.7/en/fulltext-stopwords.html
The stopword list is loaded and searched for full-text queries using the server character set and collation (the values of the character_set_server and collation_server system variables). False hits or misses might occur for stopword lookups if the ...
https://dev.mysql.com/doc/refman/9.7/en/mysqlbinlog-row-events.html
# at 218 #080828 15:03:08 server id 1 end_log_pos 258 Write_rows: table id 17 flags: STMT_END_F BINLOG ' fAS3SBMBAAAALAAAANoAAAAAABEAAAAAAAAABHRlc3QAAXQAAwMPCgIUAAQ= fAS3SBcBAAAAKAAAAAIBAAAQABEAAAAAAAEAA//8AQAAAAVhcHBsZQ== '/*!*/; ### INSERT INTO ...
https://dev.mysql.com/doc/c-api/9.7/en/mysql-real-escape-string.html
The string in the from argument is encoded to produce an escaped SQL string, taking into account the current character set of the connection. Return Values The length of the encoded string that is placed into the to argument, not including the ...
https://dev.mysql.com/doc/workbench/en/wb-develop-sql-editor-results.html
Note MySQL Workbench handles quoting and escaping for strings entered into the result grid, so adding quotes and proper escaping here is optional. Note It is possible to enter a function, or other expression, into a field. Export: Writes a result ...
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/refman/9.7/en/aggregate-functions.html
They are often used with a GROUP BY clause to group values into subsets. For a faster count, create a counter table and let your application update it according to the inserts and deletes it does. To specify a separator explicitly, use SEPARATOR ...
https://dev.mysql.com/doc/refman/9.7/en/charset-unicode-utf16.html
For example, since U+F8FF is the Apple Logo, this is legal: INSERT INTO t (utf16_column)VALUES (0xf8ff); /* legal */ Such characters cannot be expected to mean the same thing to everyone. Because utf16 supports surrogates and ucs2 does not, there is ... The utf16 character set is the ucs2 character set with an extension that enables encoding of supplementary characters: For a BMP character, utf16 and ucs2 have identical storage characteristics: same code values, same encoding, same ...
https://dev.mysql.com/doc/refman/9.7/en/create-table-secondary-indexes.html
There are additional write costs to consider when using a secondary index on a virtual column due to computation performed when materializing virtual column values in secondary index records during INSERT and UPDATE operations. A secondary index ...