Gecko [ www.jdcpatala.org ]

Name	Size	Permission
all_sys_objects_exist.result	4.66 KB	-rw-r--r--
fn_extract_schema_from_file_na...	261 B	-rw-r--r--
fn_extract_table_from_file_nam...	256 B	-rw-r--r--
fn_format_bytes.result	993 B	-rw-r--r--
fn_format_path.result	1.04 KB	-rw-r--r--
fn_format_statement.result	627 B	-rw-r--r--
fn_format_time.result	1.45 KB	-rw-r--r--
fn_list_add.result	1 KB	-rw-r--r--
fn_list_drop.result	1.27 KB	-rw-r--r--
fn_ps_is_account_enabled.resul...	541 B	-rw-r--r--
fn_ps_is_consumer_enabled.resu...	1.94 KB	-rw-r--r--
fn_ps_is_instrument_default_en...	2.28 KB	-rw-r--r--
fn_ps_is_instrument_default_ti...	2.22 KB	-rw-r--r--
fn_ps_is_thread_instrumented.r...	558 B	-rw-r--r--
fn_ps_thread_account.result	370 B	-rw-r--r--
fn_ps_thread_id.result	273 B	-rw-r--r--
fn_ps_thread_trx_info.result	4.58 KB	-rw-r--r--
fn_quote_identifier.result	531 B	-rw-r--r--
fn_sys_get_config.result	294 B	-rw-r--r--
mysqldump.result	2.4 KB	-rw-r--r--
pr_create_synonym_db.result	1.66 KB	-rw-r--r--
pr_diagnostics.result	883 B	-rw-r--r--
pr_execute_prepared_stmt.resul...	674 B	-rw-r--r--
pr_ps_setup_reset_to_default.r...	2.58 KB	-rw-r--r--
pr_ps_setup_show_disabled.resu...	6.77 KB	-rw-r--r--
pr_ps_setup_show_disabled_cons...	612 B	-rw-r--r--
pr_ps_setup_show_disabled_inst...	1.75 KB	-rw-r--r--
pr_ps_setup_show_enabled.resul...	14.27 KB	-rw-r--r--
pr_ps_setup_show_enabled_consu...	751 B	-rw-r--r--
pr_ps_setup_show_enabled_instr...	5.8 KB	-rw-r--r--
pr_ps_trace_statement_digest.r...	1.28 KB	-rw-r--r--
pr_statement_performance_analy...	12.39 KB	-rw-r--r--
pr_table_exists.result	822 B	-rw-r--r--
t_sys_config.result	1.69 KB	-rw-r--r--
v_host_summary.result	1.06 KB	-rw-r--r--
v_host_summary_by_file_io.resu...	403 B	-rw-r--r--
v_host_summary_by_file_io_type...	586 B	-rw-r--r--
v_host_summary_by_stages.resul...	562 B	-rw-r--r--
v_host_summary_by_statement_la...	889 B	-rw-r--r--
v_host_summary_by_statement_ty...	998 B	-rw-r--r--
v_innodb_buffer_stats_by_schem...	658 B	-rw-r--r--
v_innodb_buffer_stats_by_table...	710 B	-rw-r--r--
v_innodb_lock_waits.result	2.23 KB	-rw-r--r--
v_io_by_thread_by_latency.resu...	794 B	-rw-r--r--
v_io_global_by_file_by_bytes.r...	821 B	-rw-r--r--
v_io_global_by_file_by_latency...	915 B	-rw-r--r--
v_io_global_by_wait_by_bytes.r...	1.12 KB	-rw-r--r--
v_io_global_by_wait_by_latency...	1.21 KB	-rw-r--r--
v_latest_file_io.result	495 B	-rw-r--r--
v_memory_by_host_by_current_by...	704 B	-rw-r--r--
v_memory_by_thread_by_current_...	794 B	-rw-r--r--
v_memory_by_user_by_current_by...	704 B	-rw-r--r--
v_memory_global_by_current_byt...	730 B	-rw-r--r--
v_memory_global_total.result	283 B	-rw-r--r--
v_metrics.result	202 B	-rw-r--r--
v_processlist.result	2.21 KB	-rw-r--r--
v_ps_check_lost_instrumentatio...	199 B	-rw-r--r--
v_ps_digest_95th_percentile_by...	718 B	-rw-r--r--
v_ps_digest_avg_latency_distri...	652 B	-rw-r--r--
v_ps_schema_table_statistics_i...	1.96 KB	-rw-r--r--
v_schema_auto_increment_column...	8.04 KB	-rw-r--r--
v_schema_index_statistics.resu...	1.06 KB	-rw-r--r--
v_schema_object_overview.resul...	189 B	-rw-r--r--
v_schema_redundant_indexes.res...	1.29 KB	-rw-r--r--
v_schema_table_lock_waits.resu...	2.73 KB	-rw-r--r--
v_schema_table_statistics.resu...	1.64 KB	-rw-r--r--
v_schema_table_statistics_with...	2.2 KB	-rw-r--r--
v_schema_tables_with_full_tabl...	2.2 KB	-rw-r--r--
v_schema_unused_indexes.result	213 B	-rw-r--r--
v_session.result	2.19 KB	-rw-r--r--
v_session_ssl_status.result	259 B	-rw-r--r--
v_statement_analysis.result	1.93 KB	-rw-r--r--
v_statements_with_errors_or_wa...	998 B	-rw-r--r--
v_statements_with_full_table_s...	4.18 KB	-rw-r--r--
v_statements_with_runtimes_in_...	1.45 KB	-rw-r--r--
v_statements_with_sorting.resu...	1.22 KB	-rw-r--r--
v_statements_with_temp_tables....	1.09 KB	-rw-r--r--
v_user_summary.result	1.06 KB	-rw-r--r--
v_user_summary_by_file_io.resu...	403 B	-rw-r--r--
v_user_summary_by_file_io_type...	574 B	-rw-r--r--
v_user_summary_by_stages.resul...	562 B	-rw-r--r--
v_user_summary_by_statement_la...	883 B	-rw-r--r--
v_user_summary_by_statement_ty...	998 B	-rw-r--r--
v_version.result	55 B	-rw-r--r--
v_wait_classes_global_by_avg_l...	681 B	-rw-r--r--
v_wait_classes_global_by_laten...	665 B	-rw-r--r--
v_waits_by_host_by_latency.res...	630 B	-rw-r--r--
v_waits_by_user_by_latency.res...	630 B	-rw-r--r--
v_waits_global_by_latency.resu...	572 B	-rw-r--r--
version_functions.result	222 B	-rw-r--r--

Code Editor : pr_ps_setup_show_disabled.result

INSERT INTO performance_schema.setup_actors
VALUES ('localhost', 'foo', '%', 'YES', 'YES'),
('localhost', 'bar', '%', 'NO', 'NO');
UPDATE performance_schema.setup_instruments
SET ENABLED = 'NO'
 WHERE NAME LIKE 'stage/innodb/%'
       OR NAME LIKE 'statement/com/%'
       OR NAME = 'idle';
UPDATE performance_schema.setup_consumers
SET ENABLED = 'NO'
 WHERE NAME LIKE '%\_history\_long';
UPDATE performance_schema.threads SET INSTRUMENTED = 'NO' WHERE NAME LIKE 'thread/innodb/srv\_%';
CALL sys.ps_setup_show_disabled(FALSE, FALSE);
performance_schema_enabled
1
disabled_users
'bar'@'localhost'
object_type	objects	enabled	timed
EVENT	information_schema.%	NO	NO
EVENT	mysql.%	NO	NO
EVENT	performance_schema.%	NO	NO
FUNCTION	information_schema.%	NO	NO
FUNCTION	mysql.%	NO	NO
FUNCTION	performance_schema.%	NO	NO
PROCEDURE	information_schema.%	NO	NO
PROCEDURE	mysql.%	NO	NO
PROCEDURE	performance_schema.%	NO	NO
TABLE	information_schema.%	NO	NO
TABLE	mysql.%	NO	NO
TABLE	performance_schema.%	NO	NO
TRIGGER	information_schema.%	NO	NO
TRIGGER	mysql.%	NO	NO
TRIGGER	performance_schema.%	NO	NO
disabled_consumers
events_stages_history_long
events_statements_history_long
events_transactions_history_long
events_waits_history_long
CALL sys.ps_setup_show_disabled(TRUE, FALSE);
performance_schema_enabled
1
disabled_users
'bar'@'localhost'
object_type	objects	enabled	timed
EVENT	information_schema.%	NO	NO
EVENT	mysql.%	NO	NO
EVENT	performance_schema.%	NO	NO
FUNCTION	information_schema.%	NO	NO
FUNCTION	mysql.%	NO	NO
FUNCTION	performance_schema.%	NO	NO
PROCEDURE	information_schema.%	NO	NO
PROCEDURE	mysql.%	NO	NO
PROCEDURE	performance_schema.%	NO	NO
TABLE	information_schema.%	NO	NO
TABLE	mysql.%	NO	NO
TABLE	performance_schema.%	NO	NO
TRIGGER	information_schema.%	NO	NO
TRIGGER	mysql.%	NO	NO
TRIGGER	performance_schema.%	NO	NO
disabled_consumers
events_stages_history_long
events_statements_history_long
events_transactions_history_long
events_waits_history_long
disabled_instruments	timed
idle	YES
stage/innodb/alter table (end)	YES
stage/innodb/alter table (flush)	YES
stage/innodb/alter table (insert)	YES
stage/innodb/alter table (log apply index)	YES
stage/innodb/alter table (log apply table)	YES
stage/innodb/alter table (merge sort)	YES
stage/innodb/alter table (read PK and internal sort)	YES
stage/innodb/buffer pool load	YES
statement/com/Binlog Dump	YES
statement/com/Binlog Dump GTID	YES
statement/com/Change user	YES
statement/com/Close stmt	YES
statement/com/Connect	YES
statement/com/Connect Out	YES
statement/com/Create DB	YES
statement/com/Daemon	YES
statement/com/Debug	YES
statement/com/Delayed insert	YES
statement/com/Drop DB	YES
statement/com/Error	YES
statement/com/Execute	YES
statement/com/Fetch	YES
statement/com/Field List	YES
statement/com/Init DB	YES
statement/com/Kill	YES
statement/com/Long Data	YES
statement/com/Ping	YES
statement/com/Prepare	YES
statement/com/Processlist	YES
statement/com/Quit	YES
statement/com/Refresh	YES
statement/com/Register Slave	YES
statement/com/Reset Connection	YES
statement/com/Reset stmt	YES
statement/com/Set option	YES
statement/com/Shutdown	YES
statement/com/Sleep	YES
statement/com/Statistics	YES
statement/com/Table Dump	YES
statement/com/Time	YES
CALL sys.ps_setup_show_disabled(FALSE, TRUE);
performance_schema_enabled
1
disabled_users
'bar'@'localhost'
object_type	objects	enabled	timed
EVENT	information_schema.%	NO	NO
EVENT	mysql.%	NO	NO
EVENT	performance_schema.%	NO	NO
FUNCTION	information_schema.%	NO	NO
FUNCTION	mysql.%	NO	NO
FUNCTION	performance_schema.%	NO	NO
PROCEDURE	information_schema.%	NO	NO
PROCEDURE	mysql.%	NO	NO
PROCEDURE	performance_schema.%	NO	NO
TABLE	information_schema.%	NO	NO
TABLE	mysql.%	NO	NO
TABLE	performance_schema.%	NO	NO
TRIGGER	information_schema.%	NO	NO
TRIGGER	mysql.%	NO	NO
TRIGGER	performance_schema.%	NO	NO
disabled_consumers
events_stages_history_long
events_statements_history_long
events_transactions_history_long
events_waits_history_long
disabled_threads	thread_type
innodb/srv_error_monitor_thread	BACKGROUND
innodb/srv_lock_timeout_thread	BACKGROUND
innodb/srv_master_thread	BACKGROUND
innodb/srv_monitor_thread	BACKGROUND
innodb/srv_purge_thread	BACKGROUND
innodb/srv_worker_thread	BACKGROUND
innodb/srv_worker_thread	BACKGROUND
innodb/srv_worker_thread	BACKGROUND
CALL sys.ps_setup_show_disabled(TRUE, TRUE);
performance_schema_enabled
1
disabled_users
'bar'@'localhost'
object_type	objects	enabled	timed
EVENT	information_schema.%	NO	NO
EVENT	mysql.%	NO	NO
EVENT	performance_schema.%	NO	NO
FUNCTION	information_schema.%	NO	NO
FUNCTION	mysql.%	NO	NO
FUNCTION	performance_schema.%	NO	NO
PROCEDURE	information_schema.%	NO	NO
PROCEDURE	mysql.%	NO	NO
PROCEDURE	performance_schema.%	NO	NO
TABLE	information_schema.%	NO	NO
TABLE	mysql.%	NO	NO
TABLE	performance_schema.%	NO	NO
TRIGGER	information_schema.%	NO	NO
TRIGGER	mysql.%	NO	NO
TRIGGER	performance_schema.%	NO	NO
disabled_consumers
events_stages_history_long
events_statements_history_long
events_transactions_history_long
events_waits_history_long
disabled_threads	thread_type
innodb/srv_error_monitor_thread	BACKGROUND
innodb/srv_lock_timeout_thread	BACKGROUND
innodb/srv_master_thread	BACKGROUND
innodb/srv_monitor_thread	BACKGROUND
innodb/srv_purge_thread	BACKGROUND
innodb/srv_worker_thread	BACKGROUND
innodb/srv_worker_thread	BACKGROUND
innodb/srv_worker_thread	BACKGROUND
disabled_instruments	timed
idle	YES
stage/innodb/alter table (end)	YES
stage/innodb/alter table (flush)	YES
stage/innodb/alter table (insert)	YES
stage/innodb/alter table (log apply index)	YES
stage/innodb/alter table (log apply table)	YES
stage/innodb/alter table (merge sort)	YES
stage/innodb/alter table (read PK and internal sort)	YES
stage/innodb/buffer pool load	YES
statement/com/Binlog Dump	YES
statement/com/Binlog Dump GTID	YES
statement/com/Change user	YES
statement/com/Close stmt	YES
statement/com/Connect	YES
statement/com/Connect Out	YES
statement/com/Create DB	YES
statement/com/Daemon	YES
statement/com/Debug	YES
statement/com/Delayed insert	YES
statement/com/Drop DB	YES
statement/com/Error	YES
statement/com/Execute	YES
statement/com/Fetch	YES
statement/com/Field List	YES
statement/com/Init DB	YES
statement/com/Kill	YES
statement/com/Long Data	YES
statement/com/Ping	YES
statement/com/Prepare	YES
statement/com/Processlist	YES
statement/com/Quit	YES
statement/com/Refresh	YES
statement/com/Register Slave	YES
statement/com/Reset Connection	YES
statement/com/Reset stmt	YES
statement/com/Set option	YES
statement/com/Shutdown	YES
statement/com/Sleep	YES
statement/com/Statistics	YES
statement/com/Table Dump	YES
statement/com/Time	YES
UPDATE performance_schema.setup_instruments SET enabled = 'YES', timed = 'YES';
TRUNCATE TABLE performance_schema.setup_actors;
INSERT INTO performance_schema.setup_actors VALUES ('%', '%', '%', 'YES', 'YES');
UPDATE performance_schema.setup_consumers SET enabled = 'YES';
UPDATE performance_schema.threads SET instrumented = 'YES';

${this.title}

Code Editor : pr_ps_setup_show_disabled.result