Search Results
https://dev.mysql.com/doc/ndbapi/en/mccj-clusterj-session.html
Session extends AutoCloseable so it can be used in the try-with-resources pattern. This pattern allows the application to create a session in the try declaration and regardless of the outcome of the try/catch/finally block, clusterj will clean up ...
https://dev.mysql.com/doc/workbench/en/wb-connection-properties.html
When a connection is selected, it is highlighted and its properties are displayed in the properties palette. The following list describes them: caption: The name of the connection. By default, the name is the name of the foreign key and the property ...
https://dev.mysql.com/doc/internals/en/open.html
Synopsis virtual int open ( name, mode, test_if_locked); const char * name ; int mode ; uint test_if_locked ; Description This is the open method. For instance when a request comes in for a select on the table (tables are not open and closed for ...
https://dev.mysql.com/doc/heatwave/en/mys-hwgenai-nl-sql.html
The routine also runs the generated SQL statement and displays the result set. You can use this routine for generating and running SQL queries only for databases and tables that you have access to. The routine automatically detects these errors, and ...
https://dev.mysql.com/doc/refman/8.4/en/locking-functions.html
While held by one session, other sessions cannot obtain a lock of the same name. Returns 1 if the lock was obtained successfully, 0 if the attempt timed out (for example, because another client has previously locked the name), or NULL if an error ...
https://dev.mysql.com/doc/refman/8.4/en/merge-storage-engine.html
The MERGE storage engine, also known as the MRG_MyISAM engine, is a collection of identical MyISAM tables that can be used as one. “Identical” means that all tables have identical column data types and index information. You cannot merge MyISAM ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-mta.html
To use this functionality with NDB Cluster, it is necessary that the replica be configured to use multiple worker threads. To do this, set replica_parallel_workers to control the number of worker threads on the replica. MTA Configuration: Source If ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-indexes.html
Indexes are used to find rows with specific column values quickly. Without an index, MySQL must begin with the first row and then read through the entire table to find the relevant rows. If the table has an index for the columns in question, MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-selection.html
Explicit selection of partitions and subpartitions for rows matching a given WHERE condition is supported. Partition selection is similar to partition pruning, in that only specific partitions are checked for matches, but differs in two key ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-differing-tables.html
Source and target tables for replication do not have to be identical. A table on the source can have more or fewer columns than the replica's copy of the table. In addition, corresponding table columns on the source and the replica can use ...