Search Results
https://dev.mysql.com/doc/ndbapi/en/mccj-clusterj-session.html
Table 4.47 createQuery(QueryDefinition<T>) Parameter Description qd the query definition return the query instance 4.3.1.22.5 currentTransaction() public abstract Transaction currentTransaction(); Get the current com.mysql.clusterj.Transaction.
https://dev.mysql.com/doc/refman/9.7/en/innodb-information-schema-examples.html
This section describes the use of locking information as exposed by the Performance Schema data_locks and data_lock_waits tables. The tables that contain information about InnoDB transactions and data locks enable you to determine which transaction ...Identifying Blocking Transactions It is sometimes helpful to identify which transaction blocks ...
https://dev.mysql.com/doc/refman/9.7/en/optimizing-queries-myisam.html
Some general tips for speeding up queries on MyISAM tables: To help MySQL better optimize queries, use ANALYZE TABLE or run myisamchk --analyze on a table after it has been loaded with data. (For unique indexes, this is always 1.) MySQL uses this ...This updates a value for each index part that indicates the average number of rows that have the same ...
https://dev.mysql.com/doc/refman/9.7/en/partitioning-maintenance.html
A number of table and partition maintenance tasks can be carried out on partitioned tables using SQL statements intended for such purposes. Table maintenance of partitioned tables can be accomplished using the statements CHECK TABLE, OPTIMIZE ...
https://dev.mysql.com/doc/refman/9.7/en/upgrading-what-is-upgraded.html
Installing a new version of MySQL may require upgrading these parts of the existing installation: The mysql system schema, which contains tables that store information required by the MySQL server as it runs (see Section 7.3, “The mysql System ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-lakehouse.html
You can run the following routines as needed with no changes: ML_TRAIN ML_MODEL_LOAD ML_EXPLAIN ML_PREDICT_TABLE ML_EXPLAIN_TABLE ML_SCORE If you run ML_PREDICT_ROW or ML_EXPLAIN_ROW on data loaded from Object Storage, you cannot use a FROM clause.
https://dev.mysql.com/doc/refman/9.7/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 files are used only by ...Undo log file: Contains undo information required for rolling back ...
https://dev.mysql.com/doc/refman/9.7/en/partitioning-key.html
NDB Cluster uses MD5() for this purpose; for tables using other storage engines, the server employs its own internal hashing function. PARTITION BY KEY are similar to those for creating a table that is partitioned by hash. Any columns used as the ...
https://dev.mysql.com/doc/refman/9.7/en/ansi-diff-foreign-keys.html
The MATCH clause in the SQL standard controls how NULL values in a composite (multiple-column) foreign key are handled when comparing to a primary key in the referenced table. In that case, a (child table) row containing such a foreign key can be ...
https://dev.mysql.com/doc/workbench/en/wbcopytables.html
wbcopytables is a command-line utility included in MySQL Workbench that enables you to copy table data from a supported source database server to MySQL. wbcopytables can connect to the source database using either ODBC, the Python DBAPI, or the ...