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/mysql-monitor/8.0/en/performance-advisors-ref.html
This advisor has no configurable thresholds and is used to populate the graphs and tables of the Database File I/O report. Excessive Disk Temporary Table Usage Detected If the space required to build a temporary table exceeds either tmp_table_size ...For optimal performance, transactions that move through the binary log should be contained within the binary log ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-debugging-queries.html
Enable MySQL Optimizer Trace If a query fails to offload and you cannot identify the reason, enable tracing and query the INFORMATION_SCHEMA.OPTIMIZER_TRACE table to debug the query. row *************************** id: 1 select_type: SIMPLE table: ... This topic describes how to debug queries that fail to offload to MySQL HeatWave for ...
https://dev.mysql.com/doc/refman/8.4/en/create-trigger.html
A trigger is a named database object that is associated with a table, and that activates when a particular event occurs for the table. The trigger becomes associated with the table named tbl_name, which must refer to a permanent table. You cannot ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-statistics-estimation.html
Optimizer statistics are not persisted to disk when innodb_stats_persistent=OFF or when individual tables are created or altered with STATS_PERSISTENT=0. Optimizer Statistics Updates Non-persistent optimizer statistics are updated when: Running ...
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/performance-schema-statement-digests.html
The copy of the normalized statement digest is stored in the appropriate Performance Schema tables, along with the SHA-256 hash value computed from the original normalized statement. Statement Digests in the Performance Schema In the Performance ...
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/relnotes/mysql-cluster/8.4/en/news-8-4-0.html
(Bug #35997178) The unused INFORMATION_SCHEMA.TABLESPACES table, deprecated in MySQL 8.0.22, has now been removed. The Information Schema FILES table provides tablespace-related information for NDB tables. (WL #14065) ndbinfo Information Database ...