Search Results
https://dev.mysql.com/doc/refman/8.4/en/change-replication-source-to.html
If you are using statement-based replication and temporary tables, it is possible for a CHANGE REPLICATION SOURCE TO statement following a STOP REPLICA statement to leave behind temporary tables on the replica. You can avoid this in such cases by ...
https://dev.mysql.com/doc/refman/8.4/en/except.html
As with UNION and INTERSECT, either query block can make use of any of SELECT, TABLE, or VALUES. query_expression_body EXCEPT [ALL | DISTINCT] query_expression_body [EXCEPT [ALL | DISTINCT] query_expression_body] [...] query_expression_body: See ...
https://dev.mysql.com/doc/refman/8.4/en/mysqlimport.html
Invoke mysqlimport like this: mysqlimport [options] db_name textfile1 [textfile2 ...] For each text file named on the command line, mysqlimport strips any extension from the file name and uses the result to determine the name of the table into which ... The mysqlimport client provides a command-line interface to the LOAD DATA SQL ...
https://dev.mysql.com/doc/refman/8.4/en/optimizer-statistics.html
The column_statistics data dictionary table stores histogram statistics about column values, for use by the optimizer in constructing query execution plans. The column_statistics table has these characteristics: The table contains statistics for ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-consumer-filtering.html
For example, if you do not care about historical event information, disable the history consumers: UPDATE performance_schema.setup_consumers SET ENABLED = 'NO' WHERE NAME LIKE '%history%'; The consumer settings in the setup_consumers table form a ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-row-searches.html
When a replica using row-based replication format applies an UPDATE or DELETE operation, it must search the relevant table for the matching rows. The algorithm used to carry out this process uses one of the table's indexes to carry out the search ...Any index where the before-image of the row event does not contain all the columns of the ...
https://dev.mysql.com/doc/refman/8.4/en/sys-schema-object-index.html
The following tables list sys schema objects and provide a short description of each one.
https://dev.mysql.com/doc/refman/8.4/en/uninstall-plugin.html
It requires the DELETE privilege for the mysql.plugin system table because it removes the row from that table that registers the plugin. plugin_name must be the name of some plugin that is listed in the mysql.plugin table. The server executes the ...
https://dev.mysql.com/doc/heatwave-aws/en/mysql-server-plugins-components.html
The log contents can include information such as when clients connected and disconnected, what actions they performed while connected, and which databases and tables they accessed. Plugins and Components 3.1.2.6 Plugins and Components The following ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-summarize-content.html
To Run Batch Queries, add the natural-language queries to a column in a new or existing table. However, there are concerns about job displacement due to its increasing capabilities."} | Run Batch Queries To run multiple summarization queries in ...