Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-persistent-stats.html
The persistent optimizer statistics feature improves plan stability by storing statistics to disk and making them persistent across server restarts so that the optimizer is more likely to make consistent choices each time for a given query.
https://dev.mysql.com/doc/refman/8.4/en/join.html
MySQL supports the following JOIN syntax for the table_references part of SELECT statements and multiple-table DELETE and UPDATE statements: table_references: escaped_table_reference [, escaped_table_reference] ... index_hint: { USE {INDEX|KEY} ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-disk-data-objects.html
NDB Cluster Disk Data storage is implemented using the following objects: Tablespace: Acts as containers for other Disk Data objects. A tablespace contains one or more data files and one or more undo log file groups. Undo log file: Contains undo ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-prepared-statement-data-structures.html
Prepared statements use several data structures: To obtain a statement handler, pass a MYSQL connection handler to mysql_stmt_init(), which returns a pointer to a MYSQL_STMT data structure. To specify the statement to prepare, pass the MYSQL_STMT ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-options.html
int mysql_options(MYSQL *mysql, enum mysql_option option, const void *arg) Description Can be used to set extra connect options and affect behavior for a connection. This function may be called multiple times to set several options. The option ...
https://dev.mysql.com/doc/refman/8.4/en/alter-table-examples.html
For NDB tables, it is also possible to change the storage type used for a table or column. row *************************** Table: t1 Create Table: CREATE TABLE `t2` ( `c1` int(11) DEFAULT NULL ) /*!50100 TABLESPACE ts_1 STORAGE DISK */ ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-prepared-call-statements.html
This section describes prepared-statement support in the C API for stored procedures executed using CALL statements: Stored procedures executed using prepared CALL statements can be used in the following ways: A stored procedure can produce any ...
https://dev.mysql.com/doc/connectors/en/connector-python-asyncio.html
Installing Connector/Python also installs the mysql.connector.aio package that integrates asyncio with the connector to allow integrating asynchronous MySQL interactions with an application. Functions included in the asyncio API must be used to ...
https://dev.mysql.com/doc/connector-python/en/connector-python-asyncio.html
Installing Connector/Python also installs the mysql.connector.aio package that integrates asyncio with the connector to allow integrating asynchronous MySQL interactions with an application. Functions included in the asyncio API must be used to ...
https://dev.mysql.com/doc/ndbapi/en/mccj-clusterj-sessionfactory.html
Actual connections to the database are managed in a global connection pool, and may be shared by several session factories; each connection will be closed when the last session factory using it is closed. 4.3.1.23.3 currentState() public abstract ...