Search Results
https://dev.mysql.com/doc/refman/8.4/en/sys-statements-with-temp-tables.html
These views list normalized statements that have used temporary tables. By default, rows are sorted by descending number of on-disk temporary tables used and descending number of in-memory temporary tables used. The statements_with_temp_tables and ...db The default database for the statement, or NULL if there is ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-attribute-tables-ndbd.html
DefaultHashMapSize: Set size (in buckets) to use for table hash maps. DiskDataUsingSameDisk: Set to false if Disk Data tablespaces are located on separate physical disks. LateAlloc: Allocate memory after connection to management server has been ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-loading-data-par.html
To review all syntax options for loading external files, see Lakehouse External Table Syntax. CREATE TABLE Statement Depending on the version of MySQL you are using, use the appropriate CREATE TABLE statement. As of MySQL 9.4.0, you can use the ...
https://dev.mysql.com/doc/refman/8.4/en/sql-mode.html
When working with InnoDB tables, consider also the innodb_strict_mode system variable. Setting the SQL Mode The default SQL mode in MySQL 8.4 includes these modes: ONLY_FULL_GROUP_BY, STRICT_TRANS_TABLES, NO_ZERO_IN_DATE, NO_ZERO_DATE, ... The MySQL ...
https://dev.mysql.com/doc/ndbapi/en/ndb-event.html
Event Class Overview Event::addEventColumn() Event::addEventColumns() Event::addTableEvent() Event Constructor Event::EventDurability Event::EventReport Event::getDurability() Event::getEventColumn() Event::getName() Event::getNoOfEventColumns() ...
https://dev.mysql.com/doc/internals/en/getting-index-information.html
It is preferable for storage engines that support indexing to read the index information provided during a CREATE TABLE operation and store it for future use. The reasoning behind this is that the index information is most readily available during ...The key parts define the field associated with the key part, whether the key should be packed, and the data type and length of the index ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-metric-sysschema-tablemetadatalockwaiters-category.html
Lists the Sys Schema Table Metadata Lock Waits metrics and provides a brief description of each. Table 6.41 Sys Schema Table Metadata Lock Waits Metrics NameDescriptionBlocking Account The account of the session that is blocking the current ...
https://dev.mysql.com/doc/refman/8.4/en/binary-log-mysql-database.html
The contents of the grant tables in the mysql database can be modified directly (for example, with INSERT or DELETE) or indirectly (for example, with GRANT or CREATE USER). Statements that affect mysql database tables are written to the binary log ...Statements that change the mysql database indirectly are logged as statements regardless of the value of ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-config-params.html
The config_params table is a static table which provides the names and internal ID numbers of and other information about NDB Cluster configuration parameters. This table can also be used in conjunction with the config_values table for obtaining ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-dictionary-columns.html
The table provides NDB dictionary information about columns of NDB tables.