Search Results
https://dev.mysql.com/doc/refman/8.4/en/subquery-materialization.html
The optimizer uses materialization to enable more efficient subquery processing. Materialization speeds up query execution by generating a subquery result as a temporary table, normally in memory. The first time MySQL needs the subquery result, it ...
https://dev.mysql.com/doc/refman/8.4/en/table-size-limit.html
The effective maximum table size for MySQL databases is usually determined by operating system constraints on file sizes, not by MySQL internal limits. For up-to-date information operating system file size limits, refer to the documentation ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-4.html
Account Management Notes C API Notes Character Set Support Compilation Notes Component Notes Firewall Notes Installation Notes Optimizer Notes Performance Schema Notes Functionality Added or Changed Bugs Fixed Account Management Notes The database ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-restore-cluster.html
Stop the cluster using stop cluster, then restart it using start cluster with the --initial option, which causes the data node file systems to be cleared. Following this, you can restore the cluster from the desired backup using restore cluster.
https://dev.mysql.com/doc/c-api/8.4/en/c-api-introduction.html
The C API provides low-level access to the MySQL client/server protocol and enables C programs to access database contents. The C API code is distributed with MySQL and implemented in the libmysqlclient library. Most other client APIs use the ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-prepared-statement-type-conversions.html
Prepared statements transmit data between the client and server using C language variables on the client side that correspond to SQL values on the server side. If there is a mismatch between the C variable type on the client side and the ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-stmt-bind-named-param.html
bool mysql_stmt_bind_named_param(MYSQL_STMT *stmt, MYSQL_BIND *binds, unsigned n_params, const char **names) Description mysql_stmt_bind_named_param() sets up unnamed and named (query attributes) bind parameters for prepared statements. This ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-stmt-fetch.html
int mysql_stmt_fetch(MYSQL_STMT *stmt) Description mysql_stmt_fetch() returns the next row in the result set. It can be called only while the result set exists; that is, after a call to mysql_stmt_execute() for a statement such as SELECT that ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-stmt-send-long-data.html
bool mysql_stmt_send_long_data(MYSQL_STMT *stmt, unsigned int parameter_number, const char *data, unsigned long length) Description Enables an application to send parameter data to the server in pieces (or “chunks”). It can be called multiple ...
https://dev.mysql.com/doc/relnotes/connector-j/en/news-8-0-26.html
Version 8.0.26 is the latest General Availability release of the 8.0 series of MySQL Connector/J. It is suitable for use with MySQL Server versions 8.0, 5.7, and 5.6. It supports the Java Database Connectivity (JDBC) 4.2 API, and implements the X ...