Search Results
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-programs-ndb-blob-tool.html
This tool can be used to check for and remove orphaned BLOB column parts from NDB tables, as well as to generate a file listing any orphaned parts. It is sometimes useful in diagnosing and repairing corrupted or damaged NDB tables containing BLOB ...These options cause ndb_blob_tool to check for orphaned BLOB parts, remove any orphaned BLOB parts, and generate a dump file listing orphaned BLOB parts, respectively, and are described in more detail later in this ...
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.7/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/heatwave/en/mys-hw-lakehouse-loading-data-resource-principal.html
Review the following examples to see the different ways to use resource principals to specify files when creating external tables manually. This topic contains the following sections: Before You Begin Resource Principals Parameters Resource ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/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/9.7/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.7/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/9.7/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 ...