Search Results
https://dev.mysql.com/doc/internals/en/prepared-stored-statement-execution.html
The execution plan created at prepare stage is not saved (see Section 17.2, “Preparation of a Prepared Statement”), and at execute we simply create a new set of JOINs and then prepare and optimize it. Such transformations absolutely must use the ... In order to call mysql_execute_command (the function that executes a statement) for a prepared statement and not damage its parse tree, we backup and restore the active Query_arena of ...
https://dev.mysql.com/doc/refman/8.4/en/firewall-usage.html
It also saves the value, causing it to carry over to subsequent server restarts. After the additional training, set the group profile back to PROTECTING mode: CALL mysql.sp_set_firewall_group_mode('fwgrp', 'PROTECTING'); The training account ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-data-encryption.html
Each time the master encryption key is rotated, all tablespace keys in the MySQL instance are re-encrypted and saved back to their respective tablespace headers. InnoDB then re-encrypts the tablespace key using the new master encryption key and ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-row-format.html
The row format of a table determines how its rows are physically stored, which in turn can affect the performance of queries and DML operations. As more rows fit into a single disk page, queries and index lookups can work faster, less cache memory ...The pages that make up each table are arranged in a tree data structure called a B-tree ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/glossary.html
An InnoDB tablespace that is already in compressed row format is not compressed a second time, but is, nevertheless, still saved as an .ibz file in the compressed backup. Typically used to service user queries, to minimize the query load on the ...
https://dev.mysql.com/doc/workbench/en/wb-develop-sql-editor-results.html
Save Value to File: Saves the value of a field to a file. The results area of the screen shows the results from executed statements. If the script contains multiple statements, a result subtab will be generated for each statemented that returned ...
https://dev.mysql.com/doc/refman/8.4/en/source-configuration-options.html
Compressing executable debug sections saves space at the cost of extra CPU time during the build process. Set WITH_ANT to the path of a directory where the Ant tarball or unpacked archive is saved. The CMake program provides a great deal of control ...
https://dev.mysql.com/doc/relnotes/connector-j/en/news-8-0-23.html
(WL #14207) Functionality Added or Changed Important Change: A new mechanism has been introduced for users to configure how time zone conversions should occur when time instants are saved to or retrieved from a server by Connector/J. Version 8.0.23 ...
https://dev.mysql.com/doc/connectors/en/connector-net-programming-blob-reading.html
After a file is loaded into the file table, we can use the MySqlDataReader class to retrieve it. The GetBytes method of the MySqlDataReader is used to load the BLOB into a byte array, which is then written to disk using a FileStream object. The ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-errors-error.html
As of 1.1.1, only the original message is saved in the Error.msg attribute. This exception is the base class for all other exceptions in the errors module. It can be used to catch all errors in a single except statement. errors.Error is internally ...