Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-stage-summary-tables.html
The Performance Schema maintains tables for collecting current and recent stage events, and aggregates that information in summary tables. Section 29.12.5, “Performance Schema Stage Event Tables” describes the events on which stage summaries ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-transaction-summary-tables.html
The Performance Schema maintains tables for collecting current and recent transaction events, and aggregates that information in summary tables. Section 29.12.7, “Performance Schema Transaction Tables” describes the events on which transaction ...Example transaction event summary information: mysql> SELECT * FROM performance_schema.events_transactions_summary_global_by_event_name LIMIT 1\G *************************** ...
https://dev.mysql.com/doc/refman/8.4/en/log-destinations.html
To display the current structure of the log tables, use these statements: SHOW CREATE TABLE mysql.general_log; SHOW CREATE TABLE mysql.slow_log; Log contents are accessible through SQL statements. CREATE TABLE, ALTER TABLE, and DROP TABLE are valid ...Possible destinations for log entries are log files or the general_log and slow_log tables in the mysql system ... MySQL Server provides flexible ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-performance-page-tables-rows.html
Temporary Tables Graphs the number of temporary tables created, and the number of temporary tables converted to disk-based tables. The Global Table/Row Statistics dashboard displays information on the table and row activity on the monitored server.
https://dev.mysql.com/doc/refman/8.4/en/corrupted-myisam-tables.html
Even though the MyISAM table format is very reliable (all changes to a table made by an SQL statement are written before the statement returns), you can still get corrupted tables if any of the following events occur: The mysqld process is killed ...An unexpected computer shutdown occurs (for example, the computer is turned ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-install-example-data.html
To specify this, use the ENGINE=NDBCLUSTER or ENGINE=NDB option when creating the table: CREATE TABLE tbl_name (col_name column_definitions) ENGINE=NDBCLUSTER; Alternatively, for an existing table that uses a different storage engine, use ALTER ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-ml-explain-table.html
ML_EXPLAIN_TABLE explains predictions for an entire table of unlabeled data. Depending on your MySQL version, we recommend the following: Before MySQL 9.4.1, use the batch_size option to limit operations to batches of 10 to 100 rows by splitting ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-prepared-statements-instances-table.html
Instrument Server Command statement/com/Prepare COM_STMT_PREPARE statement/com/Execute COM_STMT_EXECUTE statement/sql/prepare_sql SQLCOM_PREPARE statement/sql/execute_sql SQLCOM_EXECUTE The Performance Schema manages the contents of the ...This is ... The Performance Schema provides instrumentation for prepared statements, for which there are two protocols: The binary ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-table-distribution-status.html
The table_distribution_status table provides information about the progress of table distribution for NDB tables. is_reorg_ongoing Whether the table is currently being reorganized (1 if true) .
https://dev.mysql.com/doc/refman/8.4/en/information-schema-general-table-reference.html
The following table summarizes INFORMATION_SCHEMA general tables. For greater detail, see the individual table descriptions. Table 28.2 INFORMATION_SCHEMA General Tables Table Name Description ADMINISTRABLE_ROLE_AUTHORIZATIONS Grantable users or ...