Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-limitations-all.html
Unsupported Items MySQL HeatWave Lakehouse does not support the following: DML statements: INSERT UPDATE DELETE REPLACE The CREATE TABLESPACE statement. The following options for the CREATE TABLE statement: AUTOEXTEND_SIZE AVG_ROW_LENGTH CHECKSUM ...
https://dev.mysql.com/doc/refman/8.4/en/proxy-users.html
For example: GRANT PROXY ON 'proxied_user' TO 'proxy_user'; The statement creates a row in the mysql.proxies_priv grant table. As an alternative to proxy users, DBAs may find that roles provide a suitable way to map users onto specific sets of named ...The plugin that authenticates a given connection may request that the connecting (external) user be treated as a different user for privilege-checking ...
https://dev.mysql.com/doc/internals/en/files-in-innodb-sources.html
memory object creation The data dictionary (known in some circles as the catalog) has the metadata information about objects in the database --- column sizes, table names, and the like. My-Comments For example: "\ha (HASHING) File Name What Name ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-optimization.html
To see whether a given Performance Schema table has indexes and what they are, use SHOW INDEX or SHOW CREATE TABLE: mysql> SHOW INDEX FROM performance_schema.accounts\G *************************** 1. row *************************** Table: accounts ... Applications that monitor databases may make frequent use of Performance Schema ...For example, include a WHERE clause that ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-1.html
It was removed due to a critical issue that could stop the server from restarting following the creation of a very large number of tables (8001 or more). InnoDB: For tables created with an index on a column that was too wide for the redundant row ...
https://dev.mysql.com/doc/refman/8.4/en/ansi-diff-foreign-keys.html
row *************************** Table: shirt Create Table: CREATE TABLE `shirt` ( `id` smallint(5) unsigned NOT NULL auto_increment, `style` enum('t-shirt','polo','dress') NOT NULL, `color` enum('red','blue','orange','white','black') NOT NULL, ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-supported-file-formats.html
When creating a table with the the VECTOR data type, you can provide the model to use in the ENGINE_ATTRIBUTE for either the column or table. If you are on a version earlier than MySQL 9.4.0, you must use CREATE TABLE and set ENGINE to lakehouse, ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-standard-monitor.html
The contents include the statement that failed as well as information about the constraint that failed and the referenced and referencing tables. The Lock Monitor is the same as the Standard Monitor except that it includes additional lock ...
https://dev.mysql.com/doc/refman/8.4/en/index-condition-pushdown-optimization.html
Index Condition Pushdown (ICP) is an optimization for the case where MySQL retrieves rows from a table using an index. Without ICP, the storage engine traverses the index to locate rows in the base table and returns them to the MySQL server which ...With ICP enabled, and if parts of the WHERE condition can be evaluated by using only columns from the index, the MySQL server pushes this part of the WHERE condition down to the storage ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-limitations-limits.html
Memory consumed when data is inserted into an NDB table is not automatically recovered when deleted, as it is with other storage engines. Instead, the following rules hold true: A DELETE statement on an NDB table makes the memory formerly used by ...