SELECT * FROM `VIEWS`
|
TABLE_CATALOG | TABLE_SCHEMA | TABLE_NAME | VIEW_DEFINITION | CHECK_OPTION | IS_UPDATABLE | DEFINER | SECURITY_TYPE | CHARACTER_SET_CLIENT | COLLATION_CONNECTION | |
---|---|---|---|---|---|---|---|---|---|---|
def | INFS1200_RELEASE | MakeAverageKilometers |
|
NONE | NO | root@192.168.30.% | DEFINER | utf8mb4 | utf8mb4_unicode_ci | |
def | sakila | actor_info | NONE | NO | root@localhost | INVOKER | utf8mb4 | utf8mb4_0900_ai_ci | ||
def | sakila | customer_list | NONE | YES | root@localhost | DEFINER | utf8mb4 | utf8mb4_0900_ai_ci | ||
def | sakila | film_list | NONE | NO | root@localhost | DEFINER | utf8mb4 | utf8mb4_0900_ai_ci | ||
def | sakila | nicer_but_slower_film_list | NONE | NO | root@localhost | DEFINER | utf8mb4 | utf8mb4_0900_ai_ci | ||
def | sakila | sales_by_film_category | NONE | NO | root@localhost | DEFINER | utf8mb4 | utf8mb4_0900_ai_ci | ||
def | sakila | sales_by_store | NONE | NO | root@localhost | DEFINER | utf8mb4 | utf8mb4_0900_ai_ci | ||
def | sakila | staff_list | NONE | YES | root@localhost | DEFINER | utf8mb4 | utf8mb4_0900_ai_ci | ||
def | sys | host_summary |
|
NONE | NO | mysql.sys@localhost | INVOKER | utf8mb4 | utf8mb4_0900_ai_ci | |
def | sys | host_summary_by_file_io |
|
NONE | NO | mysql.sys@localhost | INVOKER | utf8mb4 | utf8mb4_0900_ai_ci | |
def | sys | host_summary_by_file_io_type |
|
NONE | YES | mysql.sys@localhost | INVOKER | utf8mb4 | utf8mb4_0900_ai_ci | |
def | sys | host_summary_by_stages |
|
NONE | YES | mysql.sys@localhost | INVOKER | utf8mb4 | utf8mb4_0900_ai_ci | |
def | sys | host_summary_by_statement_latency |
|
NONE | NO | mysql.sys@localhost | INVOKER | utf8mb4 | utf8mb4_0900_ai_ci | |
def | sys | host_summary_by_statement_type |
|
NONE | YES | mysql.sys@localhost | INVOKER | utf8mb4 | utf8mb4_0900_ai_ci | |
def | sys | innodb_buffer_stats_by_schema |
|
NONE | NO | mysql.sys@localhost | INVOKER | utf8mb4 | utf8mb4_0900_ai_ci | |
def | sys | innodb_buffer_stats_by_table |
|
NONE | NO | mysql.sys@localhost | INVOKER | utf8mb4 | utf8mb4_0900_ai_ci | |
def | sys | innodb_lock_waits |
|
NONE | NO | mysql.sys@localhost | INVOKER | utf8mb4 | utf8mb4_0900_ai_ci | |
def | sys | io_by_thread_by_latency |
|
NONE | NO | mysql.sys@localhost | INVOKER | utf8mb4 | utf8mb4_0900_ai_ci | |
def | sys | io_global_by_file_by_bytes |
|
NONE | YES | mysql.sys@localhost | INVOKER | utf8mb4 | utf8mb4_0900_ai_ci | |
def | sys | io_global_by_file_by_latency |
|
NONE | YES | mysql.sys@localhost | INVOKER | utf8mb4 | utf8mb4_0900_ai_ci | |
def | sys | io_global_by_wait_by_bytes |
|
NONE | YES | mysql.sys@localhost | INVOKER | utf8mb4 | utf8mb4_0900_ai_ci | |
def | sys | io_global_by_wait_by_latency |
|
NONE | YES | mysql.sys@localhost | INVOKER | utf8mb4 | utf8mb4_0900_ai_ci | |
def | sys | latest_file_io |
|
NONE | NO | mysql.sys@localhost | INVOKER | utf8mb4 | utf8mb4_0900_ai_ci | |
def | sys | memory_by_host_by_current_bytes |
|
NONE | NO | mysql.sys@localhost | INVOKER | utf8mb4 | utf8mb4_0900_ai_ci | |
def | sys | memory_by_thread_by_current_bytes |
|
NONE | NO | mysql.sys@localhost | INVOKER | utf8mb4 | utf8mb4_0900_ai_ci |
|