Search Results
https://dev.mysql.com/doc/connector-python/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()` ...
https://dev.mysql.com/doc/refman/8.4/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/8.4/en/replication-gtids-concepts.html
The mysql.gtid_executed system table is used to preserve the assigned GTIDs of all the transactions applied on a MySQL server, except those that are stored in a currently active binary log file. uuid: hhhhhhhh-hhhh-hhhh-hhhh-hhhhhhhhhhhh h: ... A ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-backup-optimistic.html
Optimistic backup is a feature for improving performance for backing up and restoring huge databases in which only a small number of tables are modified frequently. And because those tables are not expected to be changed before the backup is ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-storage-engine.html
Table 18.2 MyISAM Storage Engine Features Feature Support B-tree indexes Yes Backup/point-in-time recovery (Implemented in the server, rather than in the storage engine.) Yes Cluster database support No Clustered indexes No Compressed data Yes ...
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/refman/8.4/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/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/mysql-monitor/8.0/en/mem-qanal-config-ui.html
Notices: Filters on the notices, enabling you to filter the list to show only the queries that did not raise a notice, indicated a full table scan, or indicated that a bad index was used. The database name might be blank, or might not match the ...
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 ...