Search Results
https://dev.mysql.com/doc/refman/8.4/en/partitioning-pruning.html
Some queries using BETWEEN in the WHERE clause can also take advantage of partition pruning. The optimization known as partition pruning is based on a relatively simple concept which can be described as “Do not scan partitions where there can be ...
https://dev.mysql.com/doc/refman/8.4/en/password-logging.html
Passwords can be written as plain text in SQL statements such as CREATE USER, GRANT and SET PASSWORD. If such statements are logged by the MySQL server as written, passwords in them become visible to anyone with access to the logs. Statement ...
https://dev.mysql.com/doc/refman/8.4/en/revoke.html
[IGNORE UNKNOWN USER] REVOKE [IF EXISTS] ALL [PRIVILEGES], GRANT OPTION FROM user_or_role [, user_or_role] ... [IGNORE UNKNOWN USER] REVOKE [IF EXISTS] PROXY ON user_or_role FROM user_or_role [, user_or_role] ... [IGNORE UNKNOWN USER] REVOKE [IF ...
https://dev.mysql.com/doc/refman/8.4/en/subquery-materialization.html
The optimizer uses materialization to enable more efficient subquery processing. Materialization speeds up query execution by generating a subquery result as a temporary table, normally in memory. The first time MySQL needs the subquery result, it ...
https://dev.mysql.com/doc/refman/8.4/en/upgrade-prerequisites.html
You can use the following queries to check for schema and table names containing uppercase characters: mysql> select TABLE_NAME, if(sha(TABLE_NAME) !=sha(lower(TABLE_NAME)),'Yes','No') as UpperCase from information_schema.tables; If ... Before ...
https://dev.mysql.com/doc/refman/8.4/en/user-resources.html
The following statement changes the query limit for francis to 100: mysql> ALTER USER 'francis'@'localhost' WITH MAX_QUERIES_PER_HOUR 100; The statement modifies only the limit value specified and leaves the account otherwise unchanged. Similarly, ... One means of restricting client use of MySQL server resources is to set the global max_user_connections system variable to a nonzero ...
https://dev.mysql.com/doc/refman/8.4/en/xml-functions.html
Table 14.16 XML Functions Name Description ExtractValue() Extract a value from an XML string using XPath notation UpdateXML() Return replaced XML fragment This section discusses XML and related functionality in MySQL. Note It is possible to obtain ...
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 ...