| 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; |