Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-error-summary-tables.html
The error summary tables have these indexes: events_errors_summary_by_account_by_error: Primary key on (USER, HOST, ERROR_NUMBER) events_errors_summary_by_host_by_error: Primary key on (HOST, ERROR_NUMBER) events_errors_summary_by_thread_by_error: ... The Performance Schema maintains summary tables for aggregating statistical information about server errors (and ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-memory-summary-tables.html
The memory summary tables have these indexes: memory_summary_by_account_by_event_name: Primary key on (USER, HOST, EVENT_NAME) memory_summary_by_host_by_event_name: Primary key on (HOST, EVENT_NAME) memory_summary_by_thread_by_event_name: Primary ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-stage-summary-tables.html
The stage summary tables have these indexes: events_stages_summary_by_account_by_event_name: Primary key on (USER, HOST, EVENT_NAME) events_stages_summary_by_host_by_event_name: Primary key on (HOST, EVENT_NAME) ... The Performance Schema maintains ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-statement-histogram-summary-tables.html
The statement histogram summary tables have these indexes: events_statements_histogram_by_digest: Unique index on (SCHEMA_NAME, DIGEST, BUCKET_NUMBER) events_statements_histogram_global: Primary key on (BUCKET_NUMBER) TRUNCATE TABLE is permitted for ... The Performance Schema maintains statement event summary tables that contain information about minimum, maximum, and average statement latency (see Section 29.12.20.3, “Statement Summary ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-transaction-summary-tables.html
The transaction summary tables have these indexes: events_transactions_summary_by_account_by_event_name: Primary key on (USER, HOST, EVENT_NAME) events_transactions_summary_by_host_by_event_name: Primary key on (HOST, EVENT_NAME) ... The Performance ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-wait-summary-tables.html
It has these effects: For summary tables not aggregated by account, host, or user, truncation resets the summary columns to zero rather than removing rows. For summary tables aggregated by account, host, or user, truncation removes rows for ... The ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-prepared-statement-data-structures.html
If the return value is MYSQL_DATA_TRUNCATED, *length indicates the nontruncated length of the parameter value. MySQL performs the proper conversion between signed and unsigned values in both directions, although a warning occurs if truncation ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/glossary.html
Includes not just SQL SELECT queries, but also DML statements such as INSERT, UPDATE, and DELETE, and DDL statements such as CREATE TABLE and TRUNCATE TABLE. These terms are commonly used in information about MySQL Enterprise Monitor. A access ...
https://dev.mysql.com/doc/heatwave/en/mys-hwgenai-vector-store-load.html
It can include the following parameters: chunkingoptions: JSON_OBJECT(chunkingkeyvalue[, chunkingkeyvalue]...) chunkingkeyvalue: { 'split_by', {'page'|'paragraph'|'sentence'|'document'|'recursive'} |'max', MaxValue |'by', {'characters'|'words'} ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-maintenance.html
This statement can be used to delete all rows from one or more partitions in much the same way that TRUNCATE TABLE deletes all rows from a table. A number of table and partition maintenance tasks can be carried out on partitioned tables using SQL ...