Search Results
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-ml-model-metadata.html
The model_metadata column in the model catalog allows you to view detailed information on trained models. For example, you can view the algorithm used to train the model, the columns in the training table, and values for the model explanation. When ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-model-viewing.html
Before You Begin Review the following: Create a Machine Learning Model The Model Catalog View Details for Your Models The following example queries model_id, model_handle, and model_owner, train_table_name from the model catalog. mysql> SELECT ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-genai-overview.html
The GenAI feature of MySQL AI lets you communicate with unstructured data using natural-language queries. However, as this LLM is trained on public data, the responses to your queries are generated based on information available in the public data ...It uses a familiar SQL interface which makes it is easy to use for content generation, summarization, and retrieval-augmented generation ...
https://dev.mysql.com/doc/connectors/en/connector-j-usagenotes-statements.html
Statement objects allow you to execute basic SQL queries and retrieve the results through the ResultSet class, which is described later. To create a Statement instance, you call the createStatement() method on the Connection object you have ...
https://dev.mysql.com/doc/connectors/en/connector-j-usagenotes-troubleshooting.html
The issue will affect all queries, not just those from Connector/J. This section explains the symptoms and resolutions for the most commonly encountered issues with applications using MySQL Connector/J. Questions 3.14.1: When I try to connect to ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-usagenotes-apptips-microsoft.html
To address this issue, use the CONCAT() function in your queries. This means that some queries like SHOW PROCESSLIST do not work properly. The majority of Microsoft applications have been tested with Connector/ODBC, including Microsoft Office, ...
https://dev.mysql.com/doc/internals/en/optimizer-group-by-related-conditions.html
The optimizer transforms queries of the form SELECT DISTINCT column1 FROM Table1; to SELECT column1 FROM Table1 GROUP BY column1; if and only if both of these conditions are true: The GROUP BY can be done with an index. Because DISTINCT is not ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-connections-pages-locking.html
InnoDB Row Lock Waits Displays the InnoDB locks transactions are waiting for. Table 3.2 InnoDB Row Lock Waits Dashboard Name Description Waiting Lock ID The ID of the waiting lock. Blocking Lock ID The ID of the lock that is blocking the waiting ...
https://dev.mysql.com/doc/relnotes/mysql-monitor/8.0/en/news-8-0-14.html
Important It is not possible to upgrade to MySQL Enterprise Monitor 8.0.14 from versions preceding MySQL Enterprise Monitor 3.4. To upgrade an older version, it is recommended you first upgrade to MySQL Enterprise Monitor 4.0 before running the ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/agent-advisors-reference.html
However, when the Query Analyzer is enabled, the Agent can use significantly more memory to monitor and analyze whatever queries you direct through it. In this case, the amount of memory used depends on the number of unique normalized queries, ...