Search Results
https://dev.mysql.com/doc/connectors/en/connector-j-reference-implementation-notes.html
Because of this, use the corresponding PreparedStatement.setBlob() or ResultSet.updateBlob() (in the case of updatable result sets) methods to save changes back to the database. PreparedStatement Two variants of prepared statements are implemented ... MySQL Connector/J, as a rigorous implementation of the JDBC API, passes all of the tests in the publicly available version of Oracle's JDBC compliance test ...
https://dev.mysql.com/doc/internals/en/determining-logging-format.html
For each statement, we must determine the logging format: row or statement. At parse time, it is detected if the statement is unsafe to log in statement format (that is, requires row format). THD::decide_logging_format() determines the logging ...
https://dev.mysql.com/doc/connector-j/en/connector-j-reference-implementation-notes.html
Because of this, use the corresponding PreparedStatement.setBlob() or ResultSet.updateBlob() (in the case of updatable result sets) methods to save changes back to the database. PreparedStatement Two variants of prepared statements are implemented ... MySQL Connector/J, as a rigorous implementation of the JDBC API, passes all of the tests in the publicly available version of Oracle's JDBC compliance test ...
https://dev.mysql.com/doc/refman/8.4/en/general-thread-states.html
Sorting result For a SELECT statement, this is similar to Creating sort index, but for nontemporary tables. checking permissions The thread is checking whether the server has the required privileges to execute the statement. copy to tmp table The ...
https://dev.mysql.com/doc/ndbapi/en/ndb-ndbindexscanoperation.html
NdbIndexScanOperation Class Overview NdbIndexScanOperation::BoundType NdbIndexScanOperation::end_of_bound() NdbIndexScanOperation::getDescending() NdbIndexScanOperation::get_range_no() NdbIndexScanOperation::getSorted() ...Description This type is ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-optimization.html
To write queries for these tables most efficiently, take advantage of their indexes. For example, include a WHERE clause that restricts retrieved rows based on comparison to specific values in an indexed column. Performance Schema indexes give the ... Applications that monitor databases may make frequent use of Performance Schema ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-monitoring.html
Stage Instruments Performance Schema stage events track steps that occur during the statement-execution process. When a clone operation is initiated, the different statement types tracked by clone statement instruments may be executed in parallel.
https://dev.mysql.com/doc/refman/8.4/en/thread-pool-tuning.html
In addition, the value of the thread_pool_stall_limit system variable determines the handling of blocked and long-running statements. If a long-running statement were permitted to block a thread group, all other connections assigned to the group ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-storage-engine.html
Table 18.2 MyISAM Storage Engine Features Feature Support B-tree indexes Yes Backup/point-in-time recovery (Implemented in the server, rather than in the storage engine.) Yes Cluster database support No Clustered indexes No Compressed data Yes ...
https://dev.mysql.com/doc/refman/8.4/en/alter-table-partition-operations.html
This clause always begins with PARTITION BY, and follows the same syntax and other rules as apply to the partition_options clause for CREATE TABLE (for more detailed information, see Section 15.1.20, “CREATE TABLE Statement”), and can also be ...