Search Results
https://dev.mysql.com/doc/refman/8.4/en/order-by-optimization.html
Whether the optimizer actually does so depends on whether reading the index is more efficient than a table scan if columns not in the index must also be read. In that case, scanning an entire index and looking up table rows to find columns not in ...
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 ...
MySQL 8.4 Reference Manual :: 19.2.1.3 Determination of Safe and Unsafe Statements in Binary Logging
https://dev.mysql.com/doc/refman/8.4/en/replication-rbr-safe-unsafe.html
Trigger or stored program updates a table having an AUTO_INCREMENT column. In addition, an INSERT into a table that has a composite primary key containing an AUTO_INCREMENT column that is not the first column of this composite key is unsafe. ON ...
https://dev.mysql.com/doc/internals/en/frm-file-format.html
Regardless of the storage engine you choose, every MySQL table you create is represented on disk by a .frm file that describes the table's format (that is, the table definition). The file bears the same name as the table, with an .frm extension. | ...
https://dev.mysql.com/doc/internals/en/tracing-example.html
"rest_of_plan": [ { "database": "test", "table": "alias2", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "PRIMARY", "records": 1, "cost": 20.2, "chosen": true We choose ref access on the primary key of alias2.
https://dev.mysql.com/doc/x-devapi-userguide/en/dynamic-sql.html
This is true for working with collections and for working with relational tables. A quoting function exists to escape SQL names and identifiers. Session.quoteName() escapes the identifier given in accordance to the settings of the current ...
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/heatwave/en/mys-hwgenai-hw-chat.html
If set, the routine searches for vector store tables in this schema. This parameter cannot be used in combination with the tables parameter. vector_store_columns: optional parameter which specifies column names for finding relevant vector and ...
https://dev.mysql.com/doc/refman/8.4/en/extensions-to-ansi.html
Be warned that if you use them, your code is most likely not portable to other SQL servers. For example, MySQL Server recognizes the STRAIGHT_JOIN keyword in the following statement, but other servers should not: SELECT /*! STRAIGHT_JOIN */ col1 ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-locking-reads.html
However, FOR SHARE supports OF table_name, NOWAIT, and SKIP LOCKED options. FOR SHARE statements do not acquire read locks on MySQL grant tables. FOR UPDATE requires the SELECT privilege and at least one of the DELETE, LOCK TABLES, or UPDATE ... If ...