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_enabled.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 NOT LIKE 'memory/performance_schema/%'
       AND NAME NOT LIKE 'stage/innodb/%'
       AND NAME NOT LIKE 'statement/com/%'
       AND 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\_%'
    OR NAME LIKE '%con\_%'
    OR NAME LIKE '%signal_handler%';
CALL sys.ps_setup_show_enabled(FALSE, FALSE);
performance_schema_enabled
1
enabled_users
'%'@'%'
'foo'@'localhost'
object_type	objects	enabled	timed
EVENT	%.%	YES	YES
FUNCTION	%.%	YES	YES
PROCEDURE	%.%	YES	YES
TABLE	%.%	YES	YES
TRIGGER	%.%	YES	YES
enabled_consumers
events_stages_current
events_stages_history
events_statements_current
events_statements_history
events_transactions_current
events_transactions_history
events_waits_current
events_waits_history
global_instrumentation
statements_digest
thread_instrumentation
CALL sys.ps_setup_show_enabled(TRUE, FALSE);
performance_schema_enabled
1
enabled_users
'%'@'%'
'foo'@'localhost'
object_type	objects	enabled	timed
EVENT	%.%	YES	YES
FUNCTION	%.%	YES	YES
PROCEDURE	%.%	YES	YES
TABLE	%.%	YES	YES
TRIGGER	%.%	YES	YES
enabled_consumers
events_stages_current
events_stages_history
events_statements_current
events_statements_history
events_transactions_current
events_transactions_history
events_waits_current
events_waits_history
global_instrumentation
statements_digest
thread_instrumentation
enabled_instruments	timed
idle	YES
memory/performance_schema/accounts	NO
memory/performance_schema/cond_class	NO
memory/performance_schema/cond_instances	NO
memory/performance_schema/events_stages_history	NO
memory/performance_schema/events_stages_history_long	NO
memory/performance_schema/events_stages_summary_by_account_by_event_name	NO
memory/performance_schema/events_stages_summary_by_host_by_event_name	NO
memory/performance_schema/events_stages_summary_by_thread_by_event_name	NO
memory/performance_schema/events_stages_summary_by_user_by_event_name	NO
memory/performance_schema/events_stages_summary_global_by_event_name	NO
memory/performance_schema/events_statements_current	NO
memory/performance_schema/events_statements_current.sqltext	NO
memory/performance_schema/events_statements_current.tokens	NO
memory/performance_schema/events_statements_history	NO
memory/performance_schema/events_statements_history.sqltext	NO
memory/performance_schema/events_statements_history.tokens	NO
memory/performance_schema/events_statements_history_long	NO
memory/performance_schema/events_statements_history_long.sqltext	NO
memory/performance_schema/events_statements_history_long.tokens	NO
memory/performance_schema/events_statements_summary_by_account_by_event_name	NO
memory/performance_schema/events_statements_summary_by_digest	NO
memory/performance_schema/events_statements_summary_by_digest.tokens	NO
memory/performance_schema/events_statements_summary_by_host_by_event_name	NO
memory/performance_schema/events_statements_summary_by_program	NO
memory/performance_schema/events_statements_summary_by_thread_by_event_name	NO
memory/performance_schema/events_statements_summary_by_user_by_event_name	NO
memory/performance_schema/events_statements_summary_global_by_event_name	NO
memory/performance_schema/events_transactions_history	NO
memory/performance_schema/events_transactions_history_long	NO
memory/performance_schema/events_transactions_summary_by_account_by_event_name	NO
memory/performance_schema/events_transactions_summary_by_host_by_event_name	NO
memory/performance_schema/events_transactions_summary_by_thread_by_event_name	NO
memory/performance_schema/events_transactions_summary_by_user_by_event_name	NO
memory/performance_schema/events_waits_history	NO
memory/performance_schema/events_waits_history_long	NO
memory/performance_schema/events_waits_summary_by_account_by_event_name	NO
memory/performance_schema/events_waits_summary_by_host_by_event_name	NO
memory/performance_schema/events_waits_summary_by_thread_by_event_name	NO
memory/performance_schema/events_waits_summary_by_user_by_event_name	NO
memory/performance_schema/file_class	NO
memory/performance_schema/file_handle	NO
memory/performance_schema/file_instances	NO
memory/performance_schema/hosts	NO
memory/performance_schema/memory_class	NO
memory/performance_schema/memory_summary_by_account_by_event_name	NO
memory/performance_schema/memory_summary_by_host_by_event_name	NO
memory/performance_schema/memory_summary_by_thread_by_event_name	NO
memory/performance_schema/memory_summary_by_user_by_event_name	NO
memory/performance_schema/memory_summary_global_by_event_name	NO
memory/performance_schema/metadata_locks	NO
memory/performance_schema/mutex_class	NO
memory/performance_schema/mutex_instances	NO
memory/performance_schema/prepared_statements_instances	NO
memory/performance_schema/rwlock_class	NO
memory/performance_schema/rwlock_instances	NO
memory/performance_schema/scalable_buffer	NO
memory/performance_schema/session_connect_attrs	NO
memory/performance_schema/setup_actors	NO
memory/performance_schema/setup_objects	NO
memory/performance_schema/socket_class	NO
memory/performance_schema/socket_instances	NO
memory/performance_schema/stage_class	NO
memory/performance_schema/statement_class	NO
memory/performance_schema/table_handles	NO
memory/performance_schema/table_io_waits_summary_by_index_usage	NO
memory/performance_schema/table_lock_waits_summary_by_table	NO
memory/performance_schema/table_shares	NO
memory/performance_schema/threads	NO
memory/performance_schema/thread_class	NO
memory/performance_schema/users	NO
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_enabled(FALSE, TRUE);
performance_schema_enabled
1
enabled_users
'%'@'%'
'foo'@'localhost'
object_type	objects	enabled	timed
EVENT	%.%	YES	YES
FUNCTION	%.%	YES	YES
PROCEDURE	%.%	YES	YES
TABLE	%.%	YES	YES
TRIGGER	%.%	YES	YES
enabled_consumers
events_stages_current
events_stages_history
events_statements_current
events_statements_history
events_transactions_current
events_transactions_history
events_waits_current
events_waits_history
global_instrumentation
statements_digest
thread_instrumentation
enabled_threads	thread_type
innodb/buf_dump_thread	BACKGROUND
innodb/dict_stats_thread	BACKGROUND
innodb/io_ibuf_thread	BACKGROUND
innodb/io_log_thread	BACKGROUND
innodb/io_read_thread	BACKGROUND
innodb/io_read_thread	BACKGROUND
innodb/io_write_thread	BACKGROUND
innodb/io_write_thread	BACKGROUND
innodb/page_cleaner_thread	BACKGROUND
root@localhost	FOREGROUND
sql/compress_gtid_table	FOREGROUND
sql/main	BACKGROUND
sql/thread_timer_notifier	BACKGROUND
CALL sys.ps_setup_show_enabled(TRUE, TRUE);
performance_schema_enabled
1
enabled_users
'%'@'%'
'foo'@'localhost'
object_type	objects	enabled	timed
EVENT	%.%	YES	YES
FUNCTION	%.%	YES	YES
PROCEDURE	%.%	YES	YES
TABLE	%.%	YES	YES
TRIGGER	%.%	YES	YES
enabled_consumers
events_stages_current
events_stages_history
events_statements_current
events_statements_history
events_transactions_current
events_transactions_history
events_waits_current
events_waits_history
global_instrumentation
statements_digest
thread_instrumentation
enabled_threads	thread_type
innodb/buf_dump_thread	BACKGROUND
innodb/dict_stats_thread	BACKGROUND
innodb/io_ibuf_thread	BACKGROUND
innodb/io_log_thread	BACKGROUND
innodb/io_read_thread	BACKGROUND
innodb/io_read_thread	BACKGROUND
innodb/io_write_thread	BACKGROUND
innodb/io_write_thread	BACKGROUND
innodb/page_cleaner_thread	BACKGROUND
root@localhost	FOREGROUND
sql/compress_gtid_table	FOREGROUND
sql/main	BACKGROUND
sql/thread_timer_notifier	BACKGROUND
enabled_instruments	timed
idle	YES
memory/performance_schema/accounts	NO
memory/performance_schema/cond_class	NO
memory/performance_schema/cond_instances	NO
memory/performance_schema/events_stages_history	NO
memory/performance_schema/events_stages_history_long	NO
memory/performance_schema/events_stages_summary_by_account_by_event_name	NO
memory/performance_schema/events_stages_summary_by_host_by_event_name	NO
memory/performance_schema/events_stages_summary_by_thread_by_event_name	NO
memory/performance_schema/events_stages_summary_by_user_by_event_name	NO
memory/performance_schema/events_stages_summary_global_by_event_name	NO
memory/performance_schema/events_statements_current	NO
memory/performance_schema/events_statements_current.sqltext	NO
memory/performance_schema/events_statements_current.tokens	NO
memory/performance_schema/events_statements_history	NO
memory/performance_schema/events_statements_history.sqltext	NO
memory/performance_schema/events_statements_history.tokens	NO
memory/performance_schema/events_statements_history_long	NO
memory/performance_schema/events_statements_history_long.sqltext	NO
memory/performance_schema/events_statements_history_long.tokens	NO
memory/performance_schema/events_statements_summary_by_account_by_event_name	NO
memory/performance_schema/events_statements_summary_by_digest	NO
memory/performance_schema/events_statements_summary_by_digest.tokens	NO
memory/performance_schema/events_statements_summary_by_host_by_event_name	NO
memory/performance_schema/events_statements_summary_by_program	NO
memory/performance_schema/events_statements_summary_by_thread_by_event_name	NO
memory/performance_schema/events_statements_summary_by_user_by_event_name	NO
memory/performance_schema/events_statements_summary_global_by_event_name	NO
memory/performance_schema/events_transactions_history	NO
memory/performance_schema/events_transactions_history_long	NO
memory/performance_schema/events_transactions_summary_by_account_by_event_name	NO
memory/performance_schema/events_transactions_summary_by_host_by_event_name	NO
memory/performance_schema/events_transactions_summary_by_thread_by_event_name	NO
memory/performance_schema/events_transactions_summary_by_user_by_event_name	NO
memory/performance_schema/events_waits_history	NO
memory/performance_schema/events_waits_history_long	NO
memory/performance_schema/events_waits_summary_by_account_by_event_name	NO
memory/performance_schema/events_waits_summary_by_host_by_event_name	NO
memory/performance_schema/events_waits_summary_by_thread_by_event_name	NO
memory/performance_schema/events_waits_summary_by_user_by_event_name	NO
memory/performance_schema/file_class	NO
memory/performance_schema/file_handle	NO
memory/performance_schema/file_instances	NO
memory/performance_schema/hosts	NO
memory/performance_schema/memory_class	NO
memory/performance_schema/memory_summary_by_account_by_event_name	NO
memory/performance_schema/memory_summary_by_host_by_event_name	NO
memory/performance_schema/memory_summary_by_thread_by_event_name	NO
memory/performance_schema/memory_summary_by_user_by_event_name	NO
memory/performance_schema/memory_summary_global_by_event_name	NO
memory/performance_schema/metadata_locks	NO
memory/performance_schema/mutex_class	NO
memory/performance_schema/mutex_instances	NO
memory/performance_schema/prepared_statements_instances	NO
memory/performance_schema/rwlock_class	NO
memory/performance_schema/rwlock_instances	NO
memory/performance_schema/scalable_buffer	NO
memory/performance_schema/session_connect_attrs	NO
memory/performance_schema/setup_actors	NO
memory/performance_schema/setup_objects	NO
memory/performance_schema/socket_class	NO
memory/performance_schema/socket_instances	NO
memory/performance_schema/stage_class	NO
memory/performance_schema/statement_class	NO
memory/performance_schema/table_handles	NO
memory/performance_schema/table_io_waits_summary_by_index_usage	NO
memory/performance_schema/table_lock_waits_summary_by_table	NO
memory/performance_schema/table_shares	NO
memory/performance_schema/threads	NO
memory/performance_schema/thread_class	NO
memory/performance_schema/users	NO
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_enabled.result