Search Results
https://dev.mysql.com/doc/refman/8.4/en/xa-states.html
For an ACTIVE XA transaction, issue the SQL statements that make up the transaction, and then issue an XA END statement. For an IDLE XA transaction, you can issue either an XA PREPARE statement or an XA COMMIT ... ONE PHASE statement: XA PREPARE ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-next-result.html
mysql_next_result() is used when you execute multiple statements specified as a single statement string, or when you use CALL statements to execute stored procedures, which can return multiple result sets. mysql_next_result() reads the next ... int ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-stmt-result-metadata.html
MYSQL_RES * mysql_stmt_result_metadata(MYSQL_STMT *stmt) Description mysql_stmt_result_metadata() is used to obtain result set metadata for a prepared statement. Its use requires that the statement when executed by mysql_stmt_execute() does produce ...The result set metadata returned by mysql_stmt_result_metadata() is in the form of a pointer to a MYSQL_RES structure that can be used to process the meta information such as number of fields and individual field ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-standard-monitor.html
Standard Monitor output is limited to 1MB when produced using the SHOW ENGINE INNODB STATUS statement. The contents include the statement that failed as well as information about the constraint that failed and the referenced and referencing tables.
https://dev.mysql.com/doc/refman/8.4/en/alter-table-examples.html
Column c1 uses disk-based storage, since this is the default for the table (determined by the table-level STORAGE DISK clause in the CREATE TABLE statement). For NDB tables, it is also possible to change the storage type used for a table or column.
https://dev.mysql.com/doc/refman/8.4/en/innodb-undo-tablespaces.html
Undo tablespaces contain undo logs, which are collections of records containing information about how to undo the latest change by a transaction to a clustered index record. Default undo tablespaces are created at initialization time to provide a ...A minimum of two undo tablespaces is required to support automated truncation of undo ...
https://dev.mysql.com/doc/refman/8.4/en/optimizer-issues.html
For the cases when MySQL does not do the "right" thing, tools that you have available to help MySQL are: Use the EXPLAIN statement to get information about how MySQL processes a query. To use it, just add the keyword EXPLAIN to the front of your ...
https://dev.mysql.com/doc/refman/8.4/en/federated-create-server.html
If you are creating a number of FEDERATED tables on the same server, or if you want to simplify the process of creating FEDERATED tables, you can use the CREATE SERVER statement to define the server connection parameters, just as you would with the ...If you specify only the connection name without a table name, the table name of the local table is used ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-stage-tables.html
The Performance Schema instruments stages, which are steps during the statement-execution process, such as parsing a statement, opening a table, or performing a filesort operation. Within the event hierarchy, wait events nest within stage events, ...Stages correspond to the thread states displayed by SHOW PROCESSLIST or that are visible in the Information Schema PROCESSLIST ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-buffer-pool-resize.html
Configuring InnoDB Buffer Pool Size Online The innodb_buffer_pool_size configuration option can be set dynamically using a SET statement, allowing you to resize the buffer pool without restarting the server. Status codes include: 0: No Resize ...