Search Results
https://dev.mysql.com/doc/refman/8.4/en/using-spatial-indexes.html
The optimizer investigates whether available spatial indexes can be involved in the search for queries that use a function such as MBRContains() or MBRWithin() in the WHERE clause. The following query finds all objects that are in the given ...
https://dev.mysql.com/doc/refman/8.4/en/window-function-optimization.html
Window functions affect the strategies the optimizer considers: Derived table merging for a subquery is disabled if the subquery has window functions. Semijoins are not applicable to window function optimization because semijoins apply to ...
https://dev.mysql.com/doc/refman/8.4/en/x-plugin-system-monitoring.html
For general X Plugin monitoring, use the status variables that it exposes. For information specifically about monitoring the effects of message compression, see Monitoring Connection Compression for X Plugin. Monitoring SQL Generated by X Plugin ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/restore.partial.html
Table-Level Recovery (TLR) allows selected tables (or schemas) to be restored from a backup (be it a full backup, a partial backup, or a backup created using transportable tablespaces (TTS)) using the --include-tables and --exclude-tables options.
https://dev.mysql.com/doc/c-api/8.4/en/c-api-prepared-statement-interface-usage.html
To prepare and execute a statement, an application follows these steps: Create a prepared statement handler with mysql_stmt_init(). To prepare the statement on the server, call mysql_stmt_prepare() and pass it a string containing the SQL statement.
https://dev.mysql.com/doc/extending-mysql/8.4/en/writing-full-text-plugins.html
MySQL supports server-side full-text parser plugins with MyISAM and InnoDB. For introductory information about full-text parser plugins, see Full-Text Parser Plugins. A full-text parser plugin can be used to replace or modify the built-in full-text ...
https://dev.mysql.com/doc/mysql-router/9.4/en/mysql-router-conf-options.html
When started, MySQL Router reads a list of configuration files that together make up the configuration of the router. MySQL Router reads options from configuration files that closely resemble the traditional INI file format, with sections and ...
https://dev.mysql.com/doc/mysql-router/9.4/en/mysql-router-deploying-sandbox.html
Test a MySQL Router installation by setting up a Router sandbox with InnoDB Cluster. In this case, Router acts as an intermediate node redirecting client connections to a list of servers. If one server fails, clients are redirected to the next ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-read-replicas-creating.html
Create Read Replicas using addReplicaInstance(): Cluster.addReplicaInstance(instance, [options]) Examples Default Read Replica Defining a Replication Source for the Read Replica Defining the Recovery Method for Read Replicas Certificate-based ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-aml-explanations-ml-explain-row.html
ML_EXPLAIN_ROW explains predictions for one or more rows of unlabeled data. The following example trains a dataset with the classification machine learning task. mysql> CALL sys.ML_TRAIN('census_data.census_train', 'revenue', JSON_OBJECT('task', ...