Search Results
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-trace-statement-digest.html
Traces all Performance Schema instrumentation for a specific statement digest. If you find a statement of interest within the Performance Schema events_statements_summary_by_digest table, specify its DIGEST column MD5 value to this procedure and ...
https://dev.mysql.com/doc/refman/8.4/en/use.html
USE db_name The USE statement tells MySQL to use the named database as the default (current) database for subsequent statements. This statement requires some privilege for the database or some object within it. The named database remains the ...The ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-nl-sql.html
GenAI lets you generate SQL queries from natural-language statements, making it easier for you to interact with your databases. This topic describes how to use the NL_SQL routine to generate and run SQL queries from natural-language statements. The ...This feature collects information on the schemas, tables, and columns that you have access to, and then uses a Large Language Model (LLM) to generate an SQL query for the question pertaining to your ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-like.html
LIKE to create an empty table based on the definition of another table, including any column attributes and indexes defined in the original table: CREATE TABLE new_tbl LIKE orig_tbl; The copy is created using the same version of the table storage ...
https://dev.mysql.com/doc/refman/8.4/en/uninstall-plugin.html
UNINSTALL PLUGIN plugin_name This statement removes an installed server plugin. For example, if a full-text parser plugin is associated with a FULLTEXT index on the table, uninstalling the plugin makes the table unusable. The table cannot even be ...It requires the DELETE privilege for the mysql.plugin system table because it removes the row from that table that registers the ...
https://dev.mysql.com/doc/refman/8.4/en/update-optimization.html
An update statement is optimized like a SELECT query with the additional overhead of a write. The speed of the write depends on the amount of data being updated and the number of indexes that are updated. Another way to get fast updates is to delay ...
https://dev.mysql.com/doc/refman/8.4/en/data-change-optimization.html
This section explains how to speed up data change statements: INSERT, UPDATE, and DELETE. Data analysis and reporting applications typically run data change operations that affect many rows at once, where the main considerations is the I/O to write ...Traditional OLTP applications and modern web applications typically do many small data change operations, where concurrency is ...
https://dev.mysql.com/doc/refman/8.4/en/repair-table-optimization.html
An alternative that avoids this problem is to use a separate key cache, assign to it the indexes from the table to be repaired, and deallocate it when the repair is complete. REPAIR TABLE for MyISAM tables is similar to using myisamchk for repair ...
https://dev.mysql.com/doc/refman/8.4/en/alter-function.html
ALTER FUNCTION func_name [characteristic ...] characteristic: { COMMENT 'string' | LANGUAGE SQL | { CONTAINS SQL | NO SQL | READS SQL DATA | MODIFIES SQL DATA } | SQL SECURITY { DEFINER | INVOKER } } This statement can be used to change the ...
https://dev.mysql.com/doc/refman/8.4/en/alter-resource-group.html
These attributes are specified the same way as described for CREATE RESOURCE GROUP (see Section 15.7.2.2, “CREATE RESOURCE GROUP Statement”). It determines statement behavior if the resource group has any threads assigned to it: If FORCE is not ... ALTER RESOURCE GROUP group_name [VCPU [=] vcpu_spec [, vcpu_spec] ...] [THREAD_PRIORITY [=] N] [ENABLE|DISABLE [FORCE]] vcpu_spec: {N | M - N} ALTER RESOURCE GROUP is used for resource group management (see Section 7.1.16, “Resource ...