Search Results
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-buffer-page-lru-table.html
The INNODB_BUFFER_PAGE_LRU table provides information about the pages in the InnoDB buffer pool; in particular, how they are ordered in the LRU list that determines which pages to evict from the buffer pool when it becomes full. The ...It has ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-memory-summary-tables.html
Memory summary tables do not contain timing information because memory events are not timed. Example memory event summary information: mysql> SELECT * FROM performance_schema.memory_summary_global_by_event_name WHERE EVENT_NAME = ...Operation counts ...
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/show-tables.html
SHOW [EXTENDED] [FULL] TABLES [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW TABLES lists the non-TEMPORARY tables in a given database. The LIKE clause, if present, indicates which table names to match. Matching performed by the LIKE ...
https://dev.mysql.com/doc/workbench/en/wb-using-table-tool.html
Tables can also be added to an EER Diagram using the table tool on the vertical toolbar. Make sure that the EER Diagram tab is selected, then right-click the table icon on the vertical toolbar. Clicking the mouse on this icon changes the mouse ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-performance-page-tables-rows.html
The Global Table/Row Statistics dashboard displays information on the table and row activity on the monitored server. Table 5.9 Tables / Rows Performance Page Regions NameDescriptionOpened Tables Graphs the number of cached frm files and the total ...Row Reads Graphs the average of rows read via indexes per second and the rows read via ...
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/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 ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-events-statements-current-table.html
The table stores one row per thread showing the current status of the thread's most recent monitored statement event, so there is no system variable for configuring the table size. Of the tables that contain statement event rows, ...The THREAD_ID ...