Search Results
https://dev.mysql.com/doc/internals/en/creating-tables.html
Once a handler is instanced, the first operation that will likely be required is the creation of a table. Your storage engine must implement the [custom-engine.html#custom-engine-api-reference-create create()] virtual method: virtual int ...
https://dev.mysql.com/doc/internals/en/implementing-external-lock-method.html
The [custom-engine.html#custom-engine-api-reference-external_lock external_lock()] method is called at the start of a statement or when a LOCK TABLES statement is issued. Examples of using external_lock() can be found in the sql/ha_innodb.cc file, ...
https://dev.mysql.com/doc/internals/en/implementing-rnd-next-method.html
After the table is initialized, the MySQL server will call the handler's [custom-engine.html#custom-engine-api-reference-rnd_next rnd_next()] method once for every row to be scanned until the server's search condition is satisfied or an end of file ...
https://dev.mysql.com/doc/internals/en/preparing-for-index-use.html
The [custom-engine.html#custom-engine-api-reference-index_init index_init()] method is called before an index is used to allow the storage engine to perform any necessary preparation or optimization: int ha_foo::index_init(uint keynr, bool sorted) ...
https://dev.mysql.com/doc/internals/en/starting-transaction-from-start-stmt-call.html
The first method call that can start a transaction is the [custom-engine.html#custom-engine-transactions-starting-start-stmt start_stmt()] method. It holds state relevant data for the current client, such as identity, network connection and other ...
https://dev.mysql.com/doc/internals/en/support-for-delete.html
For non-indexed storage engines the parameter can be ignored, but transactional storage engines may need to store the deleted data for rollback purposes. The following example is from the CSV storage engine: int ha_tina::delete_row(const byte * buf) ...
https://dev.mysql.com/doc/internals/en/support-for-insert.html
Once you have read support in your storage engine, the next feature to implement is support for INSERT statements. With INSERT support in place, your storage engine can handle WORM (write once, read many) applications such as logging and archiving ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-genai-vector-store-load.html
This section describes how to generate vector embeddings for files or folders, and load the embeddings into a vector store table. The following sections in this topic describe how to ingest files into a vector store: Before You Begin Ingesting ...
https://dev.mysql.com/doc/workbench/en/wb-migration-database-postgresql-typemapping.html
The following table shows the mapping between PostgreSQL (source) data types and MySQL data types. Table 10.3 Type mapping Source Type MySQL Type Comment INT INT SMALLINT SMALLINT BIGINT BIGINT SERIAL INT Sets AUTO_INCREMENT in its table definition. BIT BIT BOOLEAN TINYINT(1) REAL FLOAT DOUBLE PRECISION DOUBLE NUMERIC DECIMAL DECIMAL DECIMAL MONEY DECIMAL(19,2) CHAR CHAR/LONGTEXT Depending on its ...
https://dev.mysql.com/doc/connectors/en/connector-j-source-replica-replication-connection.html
This section describe a number of features of Connector/J's support for replication-aware deployments. Such Connection objects report they are read-only, and isSourceConnection() returns false for them. The Connection tests for available source ...