Search Results
https://dev.mysql.com/doc/refman/8.4/en/time-zone-support.html
This section describes the time zone settings maintained by MySQL, how to load the system tables required for named time support, how to stay current with time zone changes, and how to enable leap-second support. Time Zone Variables Populating the ...Time zone offsets are also supported for inserted datetime values; see Section 13.2.2, “The DATE, DATETIME, and TIMESTAMP Types”, for more ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-import.html
db_name is the name of the database where the table into which to import the data is found; file_name is the name of the CSV file from which to read the data; this must include the path to this file if it is not in the current directory. The name of ... ndb_import imports CSV-formatted data, such as that produced by mysqldump --tab, directly into NDB using the NDB ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-index-stat.html
ndb_index_stat provides per-fragment statistical information about indexes on NDB tables. sampleCount can be compared with the cardinality of SHOW INDEX or INFORMATION_SCHEMA.STATISTICS, although the latter two provide a view of the table as a ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-transactions.html
In general, you should avoid transactions that update both transactional and nontransactional tables in a replication environment. You should also avoid using any statement that accesses both transactional (or temporary) and nontransactional tables ...The server uses these rules for binary logging: If the initial statements in a transaction are nontransactional, they are written to the binary log ...
https://dev.mysql.com/doc/refman/8.4/en/data-type-defaults.html
Examples: CREATE TABLE t1 ( i INT DEFAULT -1, c VARCHAR(10) DEFAULT '', price DOUBLE(16,2) DEFAULT 0.00 ); SERIAL DEFAULT VALUE is a special case. An expression default value for one column can refer to other table columns, with the exception that ... Data type specifications can have explicit or implicit default ...
https://dev.mysql.com/doc/internals/en/files-in-innodb-sources.html
My-Comments For example: "\ha (HASHING) File Name What Name Stands For Size Comment Inside File --------- -------------------- ------ ------------------- ha0ha.c Hashing/Hashing 8,145 Hash table with external chains Comments about hashing will be ...
https://dev.mysql.com/doc/refman/8.4/en/data-dictionary-information-schema.html
In particular, for each INFORMATION_SCHEMA table that is a view on data dictionary tables: The server no longer must create a temporary table for each query of the INFORMATION_SCHEMA table. When the underlying data dictionary tables store values ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-locking.html
Intention Locks InnoDB supports multiple granularity locking which permits coexistence of row locks and table locks. WRITE takes an exclusive lock (an X lock) on the specified table. Intention locks are table-level locks that indicate which type of ...Shared and Exclusive Locks Intention Locks Record Locks Gap Locks Next-Key Locks Insert Intention Locks AUTO-INC Locks Predicate Locks for Spatial Indexes Shared and Exclusive Locks InnoDB implements standard row-level locking where there are two types of locks, shared (S) locks and exclusive (X) ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-info.html
Methods of obtaining such information include the following: Using the SHOW CREATE TABLE statement to view the partitioning clauses used in creating a partitioned table. Using the SHOW TABLE STATUS statement to determine whether a table is ... This ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-management.html
There are a number of ways using SQL statements to modify partitioned tables; it is possible to add, drop, redefine, merge, or split existing partitions using the partitioning extensions to the ALTER TABLE statement. There are also ways to obtain ...For a discussion of managing HASH and KEY partitions, see Section 26.3.2, “Management of HASH and KEY ...