Search Results
https://dev.mysql.com/doc/refman/8.4/en/partitioning-handling-nulls.html
If you insert a row into a table partitioned by RANGE such that the column value used to determine the partition is NULL, the row is inserted into the lowest partition. DROP PARTITION, see Section 15.1.9, “ALTER TABLE Statement”.) NULL is also ... Partitioning in MySQL does nothing to disallow NULL as the value of a partitioning expression, whether it is a column value or the value of a user-supplied ...
https://dev.mysql.com/doc/ndbapi/en/overview-ndbinterpretedcode-using.html
The space required by each of these methods is shown in the following table: Table 1.1 NdbInterpretedCode methods used to load constant values into NdbInterpretedCode program registers, with required buffer and request message space. Method Buffer ... The next few sections provide information about performing different types of operations with NdbInterpretedCode methods, including resource ...
https://dev.mysql.com/doc/refman/8.4/en/implicit-commit.html
CREATE TABLE and DROP TABLE statements do not commit a transaction if the TEMPORARY keyword is used. (This does not apply to other operations on temporary tables such as ALTER TABLE and CREATE INDEX, which do cause a commit.) However, although no ...
https://dev.mysql.com/doc/relnotes/mysql-cluster/8.4/en/news-8-3-0.html
You can also obtain information about certificates used by cluster nodes by checking the ndbinfo certificates table. NDB Cluster APIs: An event buffer overflow in the NDB API could cause a timeout while waiting for DROP TABLE. ndbinfo Information ...
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/8.4/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/8.4/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/8.4/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/8.4/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/refman/8.4/en/identifier-case-sensitivity.html
Each table within a database corresponds to at least one file within the database directory (and possibly more, depending on the storage engine). Consequently, the case sensitivity of the underlying operating system plays a part in the case ... In ...