Search Results
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-trx-table.html
The INNODB_TRX table provides information about every transaction currently executing inside InnoDB, including whether the transaction is waiting for a lock, when the transaction started, and the SQL statement the transaction is executing, if any.
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-virtual-table.html
The INNODB_VIRTUAL table provides metadata about InnoDB virtual generated columns and columns upon which virtual generated columns are based. A row appears in the INNODB_VIRTUAL table for each column upon which a virtual generated column is based.
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-show-tables.html
ndb_show_tables displays a list of all NDB database objects in the cluster. By default, this includes not only both user-created tables and NDB system tables, but NDB-specific indexes, internal triggers, and NDB Cluster Disk Data objects as well.
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-error-summary-tables.html
The Performance Schema maintains summary tables for aggregating statistical information about server errors (and warnings). Each error summary table has three columns that identify the error: ERROR_NUMBER is the numeric error value. For example, if ...For a list of server errors, see Server Error Message ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-events-stages-current-table.html
The table stores one row per thread showing the current status of the thread's most recent monitored stage event, so there is no system variable for configuring the table size. Of the tables that contain stage event rows, events_stages_current is ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-setup-actors-table.html
The setup_actors table contains information that determines whether to enable monitoring and historical event logging for new foreground server threads (threads associated with client connections). This table has a maximum size of 100 rows by ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-setup-instruments-table.html
The setup_instruments table lists classes of instrumented objects for which events can be collected: mysql> SELECT * FROM performance_schema.setup_instruments\G *************************** 1. row *************************** NAME: ...row ...
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/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 ...