Search Results
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-acl-mysql-instances-permissions.html
If Server Group is set to Read-Only, or higher, it is impossible to set MySQL Instances to None. That is, if Server Group is set to Read-Only, or higher, MySQL Instances must be set to Read-Only at least. MySQL Instances: grants access to the data ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-generate-content.html
The following sections in this topic describe how to generate new text-based content using MySQL HeatWave GenAI: Before You Begin Generate Content Run Batch Queries What's Next Before You Begin Review the MySQL HeatWave GenAI requirements and ...If ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-partitioning.html
To use this feature, define data placement keys on the most frequently used JOIN keys and the keys of the longest running queries. Tip For data placement key recommendations, use MySQL HeatWave Autopilot Advisor after loading tables into MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/create-index.html
Subqueries, parameters, variables, stored functions, and loadable functions are not permitted. CREATE [UNIQUE | FULLTEXT | SPATIAL] INDEX index_name [index_type] ON tbl_name (key_part,...) [index_option] [algorithm_option | lock_option] ... This ...
https://dev.mysql.com/doc/refman/8.4/en/outer-join-simplification.html
At the parser stage, queries with right outer join operations are converted to equivalent queries containing only left join operations. Table expressions in the FROM clause of a query are simplified in many cases. When the optimizer evaluates plans ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/plugin-types.html
Searches are specified as before, with no changes needed for queries. The plugin API enables creation of plugins that implement several capabilities: Loadable functions (UDFs) Storage engines Full-text parsers Daemons INFORMATION_SCHEMA tables ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-genai-generate-content.html
The following sections in this topic describe how to generate new text-based content using the GenAI feature of MySQL AI: Before You Begin Generating Content Running Batch Queries What's Next Before You Begin Review the GenAI requirements and ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/performance-advisors-ref.html
Default frequency 00:01:00 Default auto-close enabled no Excessive Number of Long Running Processes Most applications and databases are designed to execute queries very quickly. If many queries are taking a long time to execute (more than a few ...
https://dev.mysql.com/doc/refman/8.4/en/explain.html
In practice, the DESCRIBE keyword is more often used to obtain information about table structure, whereas EXPLAIN is used to obtain a query execution plan (that is, an explanation of how MySQL would execute a query). The following discussion uses ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-syntax.html
Only run Advisor on multiple schemas if the queries access tables in multiple schemas. exclude_query: Defines the IDs of queries to exclude when Advisor analyzes query statistics. query_insights: Provides runtime information for successfully ...