Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-auto-indexing-execution.html
Columns with the following data types: BINARY VARBINARY TINYBLOB BLOB MEDIUMBLOB LONGBLOB JSON TEXT TINYTEXT MEDIUMTEXT LONGTEXT Autopilot Indexing does not make recommendations for the following: The creation of primary keys. Autopilot Indexing ...
https://dev.mysql.com/doc/refman/8.4/en/delete.html
If you use a multiple-table DELETE statement involving InnoDB tables for which there are foreign key constraints, the MySQL optimizer might process tables in an order that differs from that of their parent/child relationship. For MyISAM tables, you ... DELETE is a DML statement that removes rows from a ...
https://dev.mysql.com/doc/refman/8.4/en/grant.html
[WITH GRANT OPTION] [AS user [WITH ROLE DEFAULT | NONE | ALL | ALL EXCEPT role [, role ] ... ] ] } GRANT PROXY ON user_or_role TO user_or_role [, user_or_role] ... These syntax restrictions apply: GRANT cannot mix granting both privileges and roles ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-general-table-reference.html
The following table summarizes INFORMATION_SCHEMA general tables. For greater detail, see the individual table descriptions. Table 28.2 INFORMATION_SCHEMA General Tables Table Name Description ADMINISTRABLE_ROLE_AUTHORIZATIONS Grantable users or ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-tablestats-table.html
MODIFIED_COUNTER The number of rows modified by DML operations, such as INSERT, UPDATE, DELETE, and also cascade operations from foreign keys. CLUST_INDEX_SIZE The number of pages on disk that store the clustered index, which holds the InnoDB table ... The INNODB_TABLESTATS table provides a view of low-level status information about InnoDB ...
https://dev.mysql.com/doc/refman/8.4/en/keywords.html
Certain keywords, such as SELECT, DELETE, or BIGINT, are reserved and require special treatment for use as identifiers such as table and column names. Some keywords which are otherwise considered nonreserved are restricted from use as unquoted ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndb-innodb-workloads.html
NDB Cluster has a range of unique attributes that make it ideal to serve applications requiring high availability, fast failover, high throughput, and low latency. Due to its distributed architecture and multi-node implementation, NDB Cluster also ...
https://dev.mysql.com/doc/refman/8.4/en/optimize-character.html
If a table contains string columns such as name and address, but many queries do not retrieve those columns, consider splitting the string columns into a separate table and using join queries with a foreign key when necessary. When you use a ... For ...
https://dev.mysql.com/doc/refman/8.4/en/pluggable-storage-common-layer.html
Referential Integrity: The need to have the server enforce relational database referential integrity through DDL defined foreign keys. From a technical perspective, what are some of the unique supporting infrastructure components that are in a ... A ...
https://dev.mysql.com/doc/refman/8.4/en/select-optimization.html
Indexes are especially important for queries that reference different tables, using features such as joins and foreign keys. With efficient use of the InnoDB buffer pool, MyISAM key cache, and the MySQL query cache, repeated queries run faster ...