Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-quick-start.html
The Performance Schema is implemented as a storage engine, so you can see it listed in the output from the Information Schema ENGINES table or the SHOW ENGINES statement: mysql> SELECT * FROM INFORMATION_SCHEMA.ENGINES WHERE ... This section briefly ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-binary-log.html
In a normal shutdown, the set of GTIDs from the current binary log file is saved in the mysql.gtid_executed table. Following an abnormal shutdown where this did not happen, during recovery the GTIDs are added to the table from the binary log file, ... Startup Options Used with Binary Logging System Variables Used with Binary Logging You can use the mysqld options and system variables that are described in this section to affect the operation of the binary log as well as to control which statements are written to the binary ...
https://dev.mysql.com/doc/ndbapi/en/ndb-ndbtransaction.html
Types NdbTransaction defines 2 public types as shown in the following table: Table 2.67 NdbTransaction class types and descriptions Name Description CommitStatusType() Describes the transaction's commit status ExecType() Determines whether the ...A ...
https://dev.mysql.com/doc/refman/8.4/en/information-functions.html
For example, BENCHMARK(10, (SELECT * FROM t)) fails if the table t has more than one column or more than one row. The former involves the parser, optimizer, table locking, and runtime evaluation N times each. mysql> SELECT COERCIBILITY('abc' COLLATE ...It may be used to time how quickly MySQL processes the ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-supported-file-formats.html
Parquet Delta lake tables (as of MySQL 9.5.0) Supported File Formats for Unstructured Data A Vector store can ingest files from the following unstructured formats: PPT, TXT, HTML, DOC, and PDF. Parquet File Format Review the following about Parquet ... Review the various file formats supported for loading structured, semi-structured, and unstructured data in MySQL HeatWave from different ...
https://dev.mysql.com/doc/refman/8.4/en/cost-model.html
These estimates are stored in the server_cost and engine_cost tables in the mysql system database and are configurable at any time. The intent of these tables is to make it possible to easily adjust the cost estimates that the optimizer uses when it ... To generate execution plans, the optimizer uses a cost model that is based on estimates of the cost of various operations that occur during query ...
https://dev.mysql.com/doc/internals/en/event-data-for-specific-event-types.html
How come statements with a nonzero error code can exist in the binary log? This is mainly due to the use of nontransactional tables within transactions. SELECT fails after inserting 1000 rows into a MyISAM table (for example, with a duplicate-key ...
https://dev.mysql.com/doc/heatwave/en/mys-hwgenai-ml-retrieve-schema-metadata.html
Retrieves the most relevant tables to a given natural-language statement and ranks them in the order of their relevance. ML_RETRIEVE_SCHEMA_METADATA Syntax mysql> CALL sys.ML_RETRIEVE_SCHEMA_METADATA("NaturalLanguageStatement", @output, options); ...The output generated by the routine can be used to enhance large language model (LLM) prompts, NL_SQL workflows, and retrieval-augmented generation (RAG)-based ...
https://dev.mysql.com/doc/ndbapi/en/ndb-ndboperation.html
Enumeration values Possible values are shown, along with descriptions, in the following table: Table 2.51 NdbOperation::AbortOption type values and descriptions Name Description AbortOnError A failed operation causes the transaction to abort. When ...Beginning with NDB 8.0.30, NdbOperation supports an interpreted code API similar to that implemented by ...
https://dev.mysql.com/doc/refman/8.4/en/data-size.html
Design your tables to minimize their space on the disk. Smaller tables normally require less main memory while their contents are being actively processed during query execution. Any space reduction for table data also results in smaller indexes ...