mirror of
https://github.com/MariaDB/server.git
synced 2025-02-07 06:12:18 +01:00
70de4075a1
This is a follow-up for the initial MDEV-24486 commit. It renames the view sys.table_privileges to sys.privileges_by_table_by_level and adds some more tests displaying privilege levels GLOBAL and SCHEMA
163 lines
4.7 KiB
Text
163 lines
4.7 KiB
Text
USE sys;
|
|
SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'sys' ORDER BY TABLE_NAME;
|
|
TABLE_NAME
|
|
host_summary
|
|
host_summary_by_file_io
|
|
host_summary_by_file_io_type
|
|
host_summary_by_stages
|
|
host_summary_by_statement_latency
|
|
host_summary_by_statement_type
|
|
innodb_buffer_stats_by_schema
|
|
innodb_buffer_stats_by_table
|
|
innodb_lock_waits
|
|
io_by_thread_by_latency
|
|
io_global_by_file_by_bytes
|
|
io_global_by_file_by_latency
|
|
io_global_by_wait_by_bytes
|
|
io_global_by_wait_by_latency
|
|
latest_file_io
|
|
memory_by_host_by_current_bytes
|
|
memory_by_thread_by_current_bytes
|
|
memory_by_user_by_current_bytes
|
|
memory_global_by_current_bytes
|
|
memory_global_total
|
|
metrics
|
|
privileges_by_table_by_level
|
|
processlist
|
|
ps_check_lost_instrumentation
|
|
schema_auto_increment_columns
|
|
schema_index_statistics
|
|
schema_object_overview
|
|
schema_redundant_indexes
|
|
schema_tables_with_full_table_scans
|
|
schema_table_lock_waits
|
|
schema_table_statistics
|
|
schema_table_statistics_with_buffer
|
|
schema_unused_indexes
|
|
session
|
|
session_ssl_status
|
|
statements_with_errors_or_warnings
|
|
statements_with_full_table_scans
|
|
statements_with_runtimes_in_95th_percentile
|
|
statements_with_sorting
|
|
statements_with_temp_tables
|
|
statement_analysis
|
|
sys_config
|
|
user_summary
|
|
user_summary_by_file_io
|
|
user_summary_by_file_io_type
|
|
user_summary_by_stages
|
|
user_summary_by_statement_latency
|
|
user_summary_by_statement_type
|
|
version
|
|
waits_by_host_by_latency
|
|
waits_by_user_by_latency
|
|
waits_global_by_latency
|
|
wait_classes_global_by_avg_latency
|
|
wait_classes_global_by_latency
|
|
x$host_summary
|
|
x$host_summary_by_file_io
|
|
x$host_summary_by_file_io_type
|
|
x$host_summary_by_stages
|
|
x$host_summary_by_statement_latency
|
|
x$host_summary_by_statement_type
|
|
x$innodb_buffer_stats_by_schema
|
|
x$innodb_buffer_stats_by_table
|
|
x$innodb_lock_waits
|
|
x$io_by_thread_by_latency
|
|
x$io_global_by_file_by_bytes
|
|
x$io_global_by_file_by_latency
|
|
x$io_global_by_wait_by_bytes
|
|
x$io_global_by_wait_by_latency
|
|
x$latest_file_io
|
|
x$memory_by_host_by_current_bytes
|
|
x$memory_by_thread_by_current_bytes
|
|
x$memory_by_user_by_current_bytes
|
|
x$memory_global_by_current_bytes
|
|
x$memory_global_total
|
|
x$processlist
|
|
x$ps_digest_95th_percentile_by_avg_us
|
|
x$ps_digest_avg_latency_distribution
|
|
x$ps_schema_table_statistics_io
|
|
x$schema_flattened_keys
|
|
x$schema_index_statistics
|
|
x$schema_tables_with_full_table_scans
|
|
x$schema_table_lock_waits
|
|
x$schema_table_statistics
|
|
x$schema_table_statistics_with_buffer
|
|
x$session
|
|
x$statements_with_errors_or_warnings
|
|
x$statements_with_full_table_scans
|
|
x$statements_with_runtimes_in_95th_percentile
|
|
x$statements_with_sorting
|
|
x$statements_with_temp_tables
|
|
x$statement_analysis
|
|
x$user_summary
|
|
x$user_summary_by_file_io
|
|
x$user_summary_by_file_io_type
|
|
x$user_summary_by_stages
|
|
x$user_summary_by_statement_latency
|
|
x$user_summary_by_statement_type
|
|
x$waits_by_host_by_latency
|
|
x$waits_by_user_by_latency
|
|
x$waits_global_by_latency
|
|
x$wait_classes_global_by_avg_latency
|
|
x$wait_classes_global_by_latency
|
|
SELECT ROUTINE_NAME, ROUTINE_TYPE FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_SCHEMA = 'sys' ORDER BY ROUTINE_TYPE, ROUTINE_NAME;
|
|
ROUTINE_NAME ROUTINE_TYPE
|
|
extract_schema_from_file_name FUNCTION
|
|
extract_table_from_file_name FUNCTION
|
|
format_bytes FUNCTION
|
|
format_path FUNCTION
|
|
format_statement FUNCTION
|
|
format_time FUNCTION
|
|
list_add FUNCTION
|
|
list_drop FUNCTION
|
|
ps_is_account_enabled FUNCTION
|
|
ps_is_consumer_enabled FUNCTION
|
|
ps_is_instrument_default_enabled FUNCTION
|
|
ps_is_instrument_default_timed FUNCTION
|
|
ps_is_thread_instrumented FUNCTION
|
|
ps_thread_account FUNCTION
|
|
ps_thread_id FUNCTION
|
|
ps_thread_stack FUNCTION
|
|
ps_thread_trx_info FUNCTION
|
|
quote_identifier FUNCTION
|
|
sys_get_config FUNCTION
|
|
version_major FUNCTION
|
|
version_minor FUNCTION
|
|
version_patch FUNCTION
|
|
create_synonym_db PROCEDURE
|
|
diagnostics PROCEDURE
|
|
execute_prepared_stmt PROCEDURE
|
|
optimizer_switch_choice PROCEDURE
|
|
optimizer_switch_off PROCEDURE
|
|
optimizer_switch_on PROCEDURE
|
|
ps_setup_disable_background_threads PROCEDURE
|
|
ps_setup_disable_consumer PROCEDURE
|
|
ps_setup_disable_instrument PROCEDURE
|
|
ps_setup_disable_thread PROCEDURE
|
|
ps_setup_enable_background_threads PROCEDURE
|
|
ps_setup_enable_consumer PROCEDURE
|
|
ps_setup_enable_instrument PROCEDURE
|
|
ps_setup_enable_thread PROCEDURE
|
|
ps_setup_reload_saved PROCEDURE
|
|
ps_setup_reset_to_default PROCEDURE
|
|
ps_setup_save PROCEDURE
|
|
ps_setup_show_disabled PROCEDURE
|
|
ps_setup_show_disabled_consumers PROCEDURE
|
|
ps_setup_show_disabled_instruments PROCEDURE
|
|
ps_setup_show_enabled PROCEDURE
|
|
ps_setup_show_enabled_consumers PROCEDURE
|
|
ps_setup_show_enabled_instruments PROCEDURE
|
|
ps_statement_avg_latency_histogram PROCEDURE
|
|
ps_trace_statement_digest PROCEDURE
|
|
ps_trace_thread PROCEDURE
|
|
ps_truncate_all_tables PROCEDURE
|
|
statement_performance_analyzer PROCEDURE
|
|
table_exists PROCEDURE
|
|
SELECT TRIGGER_NAME FROM INFORMATION_SCHEMA.TRIGGERS WHERE TRIGGER_SCHEMA = 'sys' ORDER BY TRIGGER_NAME;
|
|
TRIGGER_NAME
|
|
SELECT sys_version FROM sys.version;
|
|
sys_version
|
|
1.5.2
|