Search Results
https://dev.mysql.com/doc/relnotes/mysql/9.7/en/news-9-2-0.html
(Bug #37273525, Bug #37785339) The files stream_cipher.h and stream_cipher.cc, used by mysys/, were located in sql/ but did not depend on any other server code in this directory; these files have now been moved into mysys/. (Bug #35020216) InnoDB: ...(Bug #37132323) This release adds the CREATE_SPATIAL_REFERENCE_SYSTEM privilege, which allows the user to execute any of the statements CREATE SPATIAL REFERENCE SYSTEM, CREATE OR REPLACE SPATIAL REFERENCE SYSTEM, and DROP SPATIAL REFERENCE ...
https://dev.mysql.com/doc/refman/9.7/en/analyze-table.html
This makes ANALYZE TABLE fast on InnoDB tables but not 100% accurate because it does not take all rows into account. If the estimated amount of data to be read into memory for histogram generation exceeds the limit defined by ...ANALYZE ...
https://dev.mysql.com/doc/refman/9.7/en/cursors.html
Cursors have these properties: Asensitive: The server may or may not make a copy of its result table Read only: Not updatable Nonscrollable: Can be traversed only in one direction and cannot skip rows Cursor declarations must appear before handler ...
https://dev.mysql.com/doc/refman/9.7/en/fulltext-search-ngram.html
Note MySQL also provides a MeCab full-text parser plugin for Japanese, which tokenizes documents into meaningful words. The ngram parser tokenizes a sequence of text into a contiguous sequence of n characters. For example, with a token size of 2, ...
https://dev.mysql.com/doc/relnotes/mysql/9.7/en/news-9-4-0.html
As a result, temporary table field references from previous executions were not cleared, leading to attempts to insert duplicate keys into temporary tables triggering the error Can't write; duplicate key in table. For users of MySQL Enterprise ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/mysql-shell-utilities-dump-instance-schema.html
MySQL Shell's instance dump utility util.dumpInstance() and schema dump utility util.dumpSchemas(), support the export of all schemas or a selected schema from an on-premise MySQL instance into an Oracle Cloud Infrastructure Object Storage bucket ...The table dump utility util.dumpTables() supports the same operations for a selection of tables or views from a ...
https://dev.mysql.com/doc/connectors/en/connector-net-tutorials-data-adapter.html
The MySqlDataAdapter object has two main methods: Fill which reads data into the Data Set, and Update, which writes data from the Data Set to the database. From this SELECT statement the Command Builder can work out the corresponding INSERT, UPDATE ... Previously, when using MySqlDataReader, the connection to the database was continually maintained unless explicitly ...
https://dev.mysql.com/doc/connector-net/en/connector-net-tutorials-data-adapter.html
The MySqlDataAdapter object has two main methods: Fill which reads data into the Data Set, and Update, which writes data from the Data Set to the database. From this SELECT statement the Command Builder can work out the corresponding INSERT, UPDATE ... Previously, when using MySqlDataReader, the connection to the database was continually maintained unless explicitly ...
https://dev.mysql.com/doc/internals/en/debug-sync-facility.html
When the signal thread notifies the wait thread, the signal name is copied into global list and the wait thread is signalled to wake up and proceed with further processing. This signal thread copies the signal name into a global list and broadcasts ... MySQL supports a Debug Sync Facility, which - in spite of the "debug" in its name - is completely independent from the DBUG facility (except that it uses DBUG to trace its operation, if DBUG is also configured in the ...
https://dev.mysql.com/doc/ndbapi/en/ndbapi-examples-common-files.html
After this operation, new_ref has a complete aRef to use in insertion and data_start has ptr from which data is to be written. */ allocate_in_bytes(column, new_ref, data_start, input.length(), error); if(error != Success) { return NULL; } /* Copy ...