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 : v_schema_tables_with_full_table_scans.result

DESC sys.schema_tables_with_full_table_scans;
Field	Type	Null	Key	Default	Extra
object_schema	varchar(64)	YES		NULL	
object_name	varchar(64)	YES		NULL	
rows_full_scanned	bigint(20) unsigned	NO		NULL	
latency	text	YES		NULL	
SELECT * FROM sys.schema_tables_with_full_table_scans;
DESC sys.x$schema_tables_with_full_table_scans;
Field	Type	Null	Key	Default	Extra
object_schema	varchar(64)	YES		NULL	
object_name	varchar(64)	YES		NULL	
rows_full_scanned	bigint(20) unsigned	NO		NULL	
latency	bigint(20) unsigned	NO		NULL	
SELECT * FROM sys.x$schema_tables_with_full_table_scans;
CREATE TABLE test.t (i BIGINT AUTO_INCREMENT PRIMARY KEY, j BIGINT) ENGINE = innodb;
INSERT INTO test.t (j) VALUES (1), (2), (3);
INSERT INTO test.t (j) (SELECT j*2 FROM test.t);
INSERT INTO test.t (j) (SELECT j*2 FROM test.t);
INSERT INTO test.t (j) (SELECT j*2 FROM test.t);
INSERT INTO test.t (j) (SELECT j*2 FROM test.t);
INSERT INTO test.t (j) (SELECT j*2 FROM test.t);
INSERT INTO test.t (j) (SELECT j*2 FROM test.t);
INSERT INTO test.t (j) (SELECT j*2 FROM test.t);
INSERT INTO test.t (j) (SELECT j*2 FROM test.t);
CALL sys.ps_truncate_all_tables(false);
summary
Truncated 44 tables
SELECT i, j, RAND() FROM test.t WHERE j = 12;
SELECT object_schema, object_name, rows_full_scanned FROM sys.schema_tables_with_full_table_scans;
object_schema	object_name	rows_full_scanned
test	t	768
SELECT object_schema, object_name, rows_full_scanned FROM sys.x$schema_tables_with_full_table_scans;
object_schema	object_name	rows_full_scanned
test	t	768
SELECT i, j, RAND() FROM test.t WHERE j = 12;
SELECT object_schema, object_name, rows_full_scanned FROM sys.schema_tables_with_full_table_scans;
object_schema	object_name	rows_full_scanned
test	t	1536
SELECT object_schema, object_name, rows_full_scanned FROM sys.x$schema_tables_with_full_table_scans;
object_schema	object_name	rows_full_scanned
test	t	1536
SELECT * FROM test.t WHERE i = 10;
i	j
10	4
SELECT object_schema, object_name, rows_full_scanned FROM sys.schema_tables_with_full_table_scans;
object_schema	object_name	rows_full_scanned
test	t	1536
SELECT object_schema, object_name, rows_full_scanned FROM sys.x$schema_tables_with_full_table_scans;
object_schema	object_name	rows_full_scanned
test	t	1536
DROP TABLE test.t;

${this.title}

Code Editor : v_schema_tables_with_full_table_scans.result