Search Results
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-performance-monitoring.html
MySQL AI lets you offload vector-based tables to the MySQL AI Engine for accelerated processing of queries that uses at least one of the vector functions. The MySQL Performance Schema collects statistics on the usage of the AI engine and different ...Use SQL queries to access this data and check the system status and ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-mysqlai-ml-embed-row.html
This topic contains the following sections: ML_EMBED_ROW Syntax Syntax Examples See Also ML_EMBED_ROW Syntax mysql> SELECT sys.ML_EMBED_ROW('Text'[, options]); options: JSON_OBJECT(keyvalue[, keyvalue] ...) keyvalue: { 'model_id', {'ModelID'} ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-mysqlai-ml-rag.html
This column can be of any data type supported by MySQL. Syntax Examples Retrieving context and generating output: mysql> CALL sys.ML_RAG("What is AutoML",@output,@options); Where, @options is set to specify the vector store table to use using ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/preface.html
See the MySQL AI License Information User Manual for licensing information, including licensing information relating to third-party software that may be included in this MySQL AI release. Trademark Notice Oracle, Java, MySQL, and NetSuite are ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-configuration-variables.html
Different settings work best for servers with light, predictable loads, versus servers that are running near full capacity all the time, or that experience spikes of high activity. See Section 17.16, “InnoDB Integration with MySQL Performance ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-component-scheduler-tasks-table.html
For example, the audit_log server plugin utilizes the scheduler component to run a regular, recurring flush of its memory cache: mysql> select * from performance_schema.component_scheduler_tasks\G *************************** 1. Does a periodic ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-transaction-tables.html
For additional information about configuring event collection, see Section 29.3, “Performance Schema Startup Configuration”, and Section 29.4, “Performance Schema Runtime Configuration”. Transaction Boundaries In MySQL Server, transactions ...Within the event hierarchy, wait events nest within stage events, which nest within statement events, which nest within transaction ...
https://dev.mysql.com/doc/refman/8.4/en/select-optimization.html
With efficient use of the InnoDB buffer pool, MyISAM key cache, and the MySQL query cache, repeated queries run faster because the results are retrieved from memory the second and subsequent times. Tuning these statements is a top priority, whether ... Queries, in the form of SELECT statements, perform all the lookup operations in the ...
https://dev.mysql.com/doc/connectors/en/connector-j-usagenotes-known-issues-limitations.html
The following are some known issues and limitations for MySQL Connector/J: When Connector/J retrieves timestamps for a daylight saving time (DST) switch day using the getTimeStamp() method on the result set, some of the returned values might be ...
https://dev.mysql.com/doc/ndbapi/en/mccj-clusterj-clusterjtableexception.html
ClusterJTableException also provides methods for reporting the name of the table used in the search, and the elapsed time spent attempting to get the table. Commonly, a Cluster/J application may expect a table to exist, but have to wait some ...