Search Results
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/ndbapi/en/ndb-ndbdictionary.html
This section provides information about the NdbDictionary class, which stores meta-information about NDB database objects, such as tables, columns, and indexes. NdbDictionary Class Overview NdbDictionary::AutoGrowSpecification ...While the ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-relnotes.html
MySQL 8.4.6 is a new release of the 8.4 LTS (Long Term Support) series, which focuses on security and bug fixes and are recommended for customers who prefer established behavior. MySQL 8.0.43 is a new release of the 8.0 BugFix series, which focuses ... Release Notes 23 Release Notes Release notes for MySQL HeatWave on AWS 2025-08-26: Data Storage Size Can Now Be Increased For Highly Available DB Systems You can now increase the data storage size of a highly available DB System ...
https://dev.mysql.com/doc/refman/8.4/en/alter-database.html
Encryption Option The ENCRYPTION option, defines the default database encryption, which is inherited by tables created in the database. The existing tables within it are part of the general mysql tablespace, which may be encrypted. All tables in the ...alter_option: { [DEFAULT] CHARACTER SET [=] charset_name | [DEFAULT] COLLATE [=] collation_name | [DEFAULT] ENCRYPTION [=] {'Y' | 'N'} | READ ONLY [=] {DEFAULT | 0 | 1} } ALTER DATABASE enables you to change the overall characteristics of a ...
https://dev.mysql.com/doc/refman/8.4/en/hash-joins.html
row *************************** id: 1 select_type: SIMPLE table: t1 partitions: NULL type: ALL possible_keys: NULL key: NULL key_len: NULL ref: NULL rows: 1 filtered: 100.00 Extra: NULL *************************** 2. row *************************** ...It is possible to control whether hash joins are employed using one of the BNL and NO_BNL optimizer hints, or by setting block_nested_loop=on or block_nested_loop=off as part of the setting for the optimizer_switch server system ...
https://dev.mysql.com/doc/refman/8.4/en/storage-engines.html
Storage engines are MySQL components that handle the SQL operations for different table types. InnoDB is the default and most general-purpose storage engine, and Oracle recommends using it for tables except for specialized use cases. (The CREATE ...
https://dev.mysql.com/doc/refman/8.4/en/known-issues.html
Even if you use lower_case_table_names=2 (which enables MySQL to remember the case used for databases and table names), MySQL does not remember the case used for database names for the function DATABASE() or within the various logs (on ... This ...
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/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 ...