Search Results
https://dev.mysql.com/doc/workbench/en/wb-develop-object-management-inspector.html
The Schema Inspector and Table Inspector each include the ability to analyze and repair tables, and also view table metrics. It allows you to perform maintenance tasks on tables such as ANALYZE, OPTIMIZE, CHECK, and CHECKSUM TABLE. Figure 8.23 ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-mysqlai-ml-embed-table.html
The ML_EMBED_TABLE routine runs multiple embedding generations in a batch, in parallel. This topic contains the following sections: ML_EMBED_TABLE Syntax Syntax Examples See Also To learn about the privileges you need to run this routine, see ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-0.html
(WL #16221) Microsoft Windows: Third party DLL files on which MySQL plugins depend are located, when installed, in the same directory as the MySQL executables. The default Windows behavior is to look for dependences in the same directory as the ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-maintenance-schedule.html
It is a good idea to perform table checks on a regular basis rather than waiting for problems to occur. One way to check and repair MyISAM tables is with the CHECK TABLE and REPAIR TABLE statements. It is also a good idea to enable automatic MyISAM ...The -s option (short for --silent) causes myisamchk to run in silent mode, printing messages only when errors ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-operations-per-fragment.html
The operations_per_fragment table provides information about the operations performed on individual fragments and fragment replicas, as well as about some of the results from these operations. This currently has the following formats: Base table: ...The syntax just shown for fully qualified object names is an internal interface which is subject to change in future ...
https://dev.mysql.com/doc/refman/8.4/en/sys-schema-table-statistics.html
By default, rows are sorted by descending total wait time (tables with most contention first). The schema_table_statistics and x$schema_table_statistics views have these columns: table_schema The schema that contains the table. total_latency The ...
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/mysql-ai/9.4/en/mys-mysqlai-ml-generate-table.html
The ML_GENERATE_TABLE routine runs multiple text generation or summarization queries in a batch, in parallel. This topic contains the following sections: ML_GENERATE_TABLE Syntax Syntax Examples See Also To learn about the privileges you need to ...
https://dev.mysql.com/doc/refman/8.4/en/federated-create.html
To create a FEDERATED table you should follow these steps: Create the table on the remote server. Alternatively, make a note of the table definition of an existing table, perhaps using the SHOW CREATE TABLE statement. Create the table on the local ...The optimization occurs because the query sent to the remote server includes the contents of the WHERE clause and is sent to the remote server and subsequently executed ...
https://dev.mysql.com/doc/refman/8.4/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, ...