Search Results
https://dev.mysql.com/doc/refman/8.4/en/sys-statement-performance-analyzer.html
Parameters in_action ENUM('snapshot', 'overall', 'delta', 'create_tmp', 'create_table', 'save', 'cleanup'): The action to take. The default is to make a snapshot of the current content of the Performance Schema events_statements_summary_by_digest ...
https://dev.mysql.com/doc/refman/8.4/en/multiple-key-caches.html
This feature enables you to assign different table indexes to different key caches. Where there are multiple key caches, the server must know which cache to use when processing queries for a given MyISAM table. By default, all MyISAM table indexes ... Note As of MySQL 8.4, the compound-part structured-variable syntax discussed here for referring to multiple MyISAM key caches is ...
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-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 ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-management-hash-key.html
Tables which are partitioned by hash or by key are very similar to one another with regard to making changes in a partitioning setup, and both differ in a number of ways from tables which have been partitioned by range or list. For that reason, ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-genai-generate-embeddings.html
You can pass the text string in the routine manually or use data from tables in your database. To embed multiple rows of text stored in a table in a single run, you can even run a batch query. Using this method, you can create vector embedding ...