SELECT * FROM `VIEW_TABLE_USAGE`
|
VIEW_CATALOG | VIEW_SCHEMA | VIEW_NAME | TABLE_CATALOG | TABLE_SCHEMA | TABLE_NAME | |
---|---|---|---|---|---|---|
def | sys | schema_auto_increment_columns | def | information_schema | COLUMNS | |
def | sys | schema_object_overview | def | information_schema | EVENTS | |
def | sys | innodb_buffer_stats_by_schema | def | information_schema | INNODB_BUFFER_PAGE | |
def | sys | x$innodb_buffer_stats_by_schema | def | information_schema | INNODB_BUFFER_PAGE | |
def | sys | innodb_buffer_stats_by_table | def | information_schema | INNODB_BUFFER_PAGE | |
def | sys | x$innodb_buffer_stats_by_table | def | information_schema | INNODB_BUFFER_PAGE | |
def | sys | metrics | def | information_schema | INNODB_METRICS | |
def | sys | innodb_lock_waits | def | information_schema | INNODB_TRX | |
def | sys | x$innodb_lock_waits | def | information_schema | INNODB_TRX | |
def | sys | latest_file_io | def | information_schema | PROCESSLIST | |
def | sys | x$latest_file_io | def | information_schema | PROCESSLIST | |
def | sys | schema_object_overview | def | information_schema | ROUTINES | |
def | sys | schema_object_overview | def | information_schema | STATISTICS | |
def | sys | x$schema_flattened_keys | def | information_schema | STATISTICS | |
def | sys | schema_unused_indexes | def | information_schema | STATISTICS | |
def | sys | schema_object_overview | def | information_schema | TABLES | |
def | sys | schema_auto_increment_columns | def | information_schema | TABLES | |
def | sys | schema_object_overview | def | information_schema | TRIGGERS | |
def | sys | user_summary | def | performance_schema | accounts | |
def | sys | x$user_summary | def | performance_schema | accounts | |
def | sys | host_summary | def | performance_schema | accounts | |
def | sys | x$host_summary | def | performance_schema | accounts | |
def | sys | innodb_lock_waits | def | performance_schema | data_lock_waits | |
def | sys | x$innodb_lock_waits | def | performance_schema | data_lock_waits | |
def | sys | innodb_lock_waits | def | performance_schema | data_locks |
|