Search Results
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/insert.html
| TABLE table_name | VALUES row_constructor_list } [ON DUPLICATE KEY UPDATE assignment_list] value: {expr | DEFAULT} value_list: value [, value] ... For the reasons for this, see Section 15.2.7.3, “INSERT DELAYED Statement”, Inserting into a ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo.html
This database contains a number of tables, each providing a different sort of data about NDB Cluster node status, resource usage, and operations. You can find more detailed information about each of these tables in the next several sections. ndbinfo ... ndbinfo is a database containing information specific to NDB ...
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 ...
https://dev.mysql.com/doc/refman/8.4/en/replica-logs-status.html
The connection metadata repository is written to the slave_master_info table in the mysql system schema, and the applier metadata repository is written to the slave_relay_log_info table in the mysql system schema. A warning message is issued if ...
https://dev.mysql.com/doc/refman/8.4/en/rewriter-query-rewrite-plugin-reference.html
Users communicate with the plugin by modifying the set of rules stored in this table. The plugin communicates information to users by setting the table's message column. Note The rules table is loaded into the plugin by the flush_rewrite_rules ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-capacity-options.html
--sleep=MS Command-Line Format --sleep=MS Type Numeric Default Value 0 Unit millisecond Specify the number in milliseconds to sleep after copying a certain amount of data from InnoDB tables. --skip-unused-pages Skip unused pages in tablespaces when ... These options limit the resources used by the backup process, in order to minimize backup overhead for busy or huge databases, or specify behaviors of the process when encountering resource ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/writing-information-schema-plugins.html
This section describes how to write a server-side INFORMATION_SCHEMA table plugin. To write an INFORMATION_SCHEMA table plugin, include the following header files in the plugin source file. #include <sql_class.h> #include <table.h> These header ...
https://dev.mysql.com/doc/connectors/en/connector-python-asyncio.html
References: [asyncio.gather]: https://docs.python.org/3/library/asyncio-task.html#asyncio.gather """ print("-------------------- ASYNCHRONOUS --------------------") # reset indent global indent indent = 0 clock = time.time() # `asyncio.gather()` ...