Debian Codegraph @

mysql-test/suite/sysschema/r/v_schema_tables_with_full_table_scans.result

raw
1 DESC sys.schema_tables_with_full_table_scans;
2 Field Type Null Key Default Extra
3 object_schema varchar(64) YES NULL
4 object_name varchar(64) YES NULL
5 rows_full_scanned bigint unsigned NO NULL
6 latency varchar(11) YES NULL
7 SELECT * FROM sys.schema_tables_with_full_table_scans;
8 DESC sys.x$schema_tables_with_full_table_scans;
9 Field Type Null Key Default Extra
10 object_schema varchar(64) YES NULL
11 object_name varchar(64) YES NULL
12 rows_full_scanned bigint unsigned NO NULL
13 latency bigint unsigned NO NULL
14 SELECT * FROM sys.x$schema_tables_with_full_table_scans;
15 CREATE TABLE test.t (i BIGINT AUTO_INCREMENT PRIMARY KEY, j BIGINT) ENGINE = innodb;
16 INSERT INTO test.t (j) VALUES (1), (2), (3);
17 INSERT INTO test.t (j) (SELECT j*2 FROM test.t);
18 INSERT INTO test.t (j) (SELECT j*2 FROM test.t);
19 INSERT INTO test.t (j) (SELECT j*2 FROM test.t);
20 INSERT INTO test.t (j) (SELECT j*2 FROM test.t);
21 INSERT INTO test.t (j) (SELECT j*2 FROM test.t);
22 INSERT INTO test.t (j) (SELECT j*2 FROM test.t);
23 INSERT INTO test.t (j) (SELECT j*2 FROM test.t);
24 INSERT INTO test.t (j) (SELECT j*2 FROM test.t);
25 CALL sys.ps_truncate_all_tables(false);
26 summary
27 Truncated 49 tables
28 SELECT i, j, RAND() FROM test.t WHERE j = 12;
29 SELECT object_schema, object_name, rows_full_scanned FROM sys.schema_tables_with_full_table_scans;
30 object_schema object_name rows_full_scanned
31 test t 768
32 SELECT object_schema, object_name, rows_full_scanned FROM sys.x$schema_tables_with_full_table_scans;
33 object_schema object_name rows_full_scanned
34 test t 768
35 SELECT i, j, RAND() FROM test.t WHERE j = 12;
36 SELECT object_schema, object_name, rows_full_scanned FROM sys.schema_tables_with_full_table_scans;
37 object_schema object_name rows_full_scanned
38 test t 1536
39 SELECT object_schema, object_name, rows_full_scanned FROM sys.x$schema_tables_with_full_table_scans;
40 object_schema object_name rows_full_scanned
41 test t 1536
42 SELECT * FROM test.t WHERE i = 10;
43 i j
44 10 4
45 SELECT object_schema, object_name, rows_full_scanned FROM sys.schema_tables_with_full_table_scans;
46 object_schema object_name rows_full_scanned
47 test t 1536
48 SELECT object_schema, object_name, rows_full_scanned FROM sys.x$schema_tables_with_full_table_scans;
49 object_schema object_name rows_full_scanned
50 test t 1536
51 DROP TABLE test.t;