Search Results
https://dev.mysql.com/doc/refman/9.7/en/grant.html
(Alternatively, if you have the UPDATE privilege for the grant tables in the mysql system schema, you can grant any account any privilege.) When the read_only system variable is enabled, GRANT additionally requires the CONNECTION_ADMIN privilege (or ...[WITH GRANT OPTION] [AS user [WITH ROLE DEFAULT | NONE | ALL | ALL EXCEPT role [, role ] ...
https://dev.mysql.com/doc/heatwave/en/mys-hwgenai-ml-rag-table.html
The ML_RAG_TABLE routine runs multiple retrieval-augmented generation (RAG) queries in a batch, in parallel. Note In versions older than MySQL 9.2.1, to alter an existing table or create a new table, MySQL requires you to set the ...The output ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-install-example-data.html
Working with database tables and data in NDB Cluster is not much different from doing so in standard MySQL. There are two key points to keep in mind: For a table to be replicated in the cluster, it must use the NDBCLUSTER storage engine. To specify ... Note The information in this section applies to NDB Cluster running on both Unix and Windows ...
https://dev.mysql.com/doc/refman/9.7/en/replication-options-replica.html
On the source and each replica, you must set the server_id system variable to establish a unique replication ID in the range from 1 to 232 − 1. To specify more than one database, use this option multiple times, once for each database; however, ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-persistent-stats.html
Optimizer statistics are persisted to disk when innodb_stats_persistent=ON or when individual tables are defined with STATS_PERSISTENT=1. Formerly, optimizer statistics were cleared when restarting the server and after some other types of ... The ...
https://dev.mysql.com/doc/refman/9.7/en/merge-storage-engine.html
The MERGE storage engine, also known as the MRG_MyISAM engine, is a collection of identical MyISAM tables that can be used as one. “Identical” means that all tables have identical column data types and index information. You cannot merge MyISAM ...However, if the user's privileges on t are subsequently revoked, the user can continue to access t by doing so ...
https://dev.mysql.com/doc/mysql-ai/9.7/en/mys-mysqlai-ml-explain-table.html
ML_EXPLAIN_TABLE explains predictions for an entire table of unlabeled data. We recommend limiting the input table to a maximum of 100 rows. If the input table has more than ten columns, limit it to ten rows. A call to ML_EXPLAIN_TABLE can include ...model_handle: Specifies the model handle or a session variable containing the model ...
https://dev.mysql.com/doc/mysql-ai/9.7/en/mys-mysqlai-ml-rag-table.html
The ML_RAG_TABLE routine runs multiple retrieval-augmented generation (RAG) queries in a batch, in parallel. This topic contains the following sections: ML_RAG_TABLE Syntax Syntax Examples See Also To learn about the privileges you need to run this ...The output generated for every input query is the same as the output generated by the ML_RAG ...
https://dev.mysql.com/doc/refman/9.7/en/myisam-repair.html
The discussion in this section describes how to use myisamchk on MyISAM tables (extensions .MYI and .MYD). You can also use the CHECK TABLE and REPAIR TABLE statements to check and repair MyISAM tables. See Section 15.7.3.2, “CHECK TABLE ...On ...
https://dev.mysql.com/doc/refman/9.7/en/replication-features-temptables.html
In MySQL 9.7, when binlog_format is set to ROW or MIXED, statements that exclusively use temporary tables are not logged on the source, and therefore the temporary tables are not replicated. Statements that involve a mix of temporary and ...They ...