Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-statement-tables.html
These tables store statement events: events_statements_current: The current statement event for each thread. prepared_statements_instances: Prepared statement instances and statistics The following sections describe the statement event tables. There ...Statement events occur at a high level of the event ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-ndb-sync-excluded-objects-table.html
This table provides information about NDB database objects which cannot be automatically synchronized between NDB Cluster's dictionary and the MySQL data dictionary. row *************************** SCHEMA_NAME: NULL NAME: ts1 TYPE: TABLESPACE ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-socket-summary-tables.html
These socket summary tables aggregate timer and byte count information for socket operations: socket_summary_by_event_name: Aggregate timer and byte count statistics generated by the wait/io/socket/* instruments for all socket I/O operations, per ...socket_summary_by_instance: Aggregate timer and byte count statistics generated by the wait/io/socket/* instruments for all socket I/O operations, per socket ...
https://dev.mysql.com/doc/x-devapi-userguide/en/collections-as-relational-tables.html
Applications that seek to store standard SQL columns with Documents can cast a collection to a table. In this case a collection can be fetched as a Table object with the Schema.getCollectionAsTable() function. From that moment on it is treated as a ...Document values can be accessed in SQL CRUD operations using the following syntax: doc->'$.field' doc->'$.field' is used to access the document top level ...
https://dev.mysql.com/doc/refman/8.4/en/charset-table.html
Every table has a table character set and a table collation. The CREATE TABLE and ALTER TABLE statements have optional clauses for specifying the table character set and collation: CREATE TABLE tbl_name (column_list) [[DEFAULT] CHARACTER SET ...If ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-tablespaces-table.html
The INNODB_TABLESPACES table provides metadata about InnoDB file-per-table, general, and undo tablespaces. For related usage information and examples, see Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”. Note The ...
https://dev.mysql.com/doc/refman/8.4/en/nontransactional-tables.html
If you receive the following message when trying to perform a ROLLBACK, it means that one or more of the tables you used in the transaction do not support transactions: Warning: Some non-transactional changed tables couldn't be rolled back These ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-statement-histogram-summary-tables.html
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 Tables”). Section 29.12.6, “Performance Schema ...To ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-progress-table-update.html
Rename the original mysql.backup_progress table to mysql.backup_progress_old, and the mysql.backup_progress_new table to mysql.backup_progress. Note If you are working with a multiprimary Group Replication setting, make sure these privileges are ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-autopilot-report-table.html
When Advisor or Auto Parallel Load run, they send detailed output to the heatwave_autopilot_report table in the sys schema. All versions prior to MySQL 8.0.32 use the heatwave_advisor_report and heatwave_load_report tables for reporting Autopilot ...