| 1 |
# User@Host: [SQL_SLAVE] @ [] |
| 2 |
# Query_time: 0.000001 Lock_time: 0.000000 Rows_sent: 1 Rows_examined: 1 |
| 3 |
# QC_Hit: No Full_scan: Yes Full_join: No Tmp_table: Yes Tmp_table_on_disk: No |
| 4 |
# Filesort: Yes Filesort_on_disk: No Merge_passes: 0 |
| 5 |
# No InnoDB statistics available for this query |
| 6 |
use db1; |
| 7 |
select * from t where id in (1,2,3); |
| 8 |
# User@Host: [SQL_SLAVE] @ [] |
| 9 |
# Query_time: 0.000512 Lock_time: 0.000000 Rows_sent: 2 Rows_examined: 2 |
| 10 |
# QC_Hit: No Full_scan: No Full_join: No Tmp_table: Yes Tmp_table_on_disk: No |
| 11 |
# Filesort: Yes Filesort_on_disk: No Merge_passes: 0 |
| 12 |
# No InnoDB statistics available for this query |
| 13 |
select * from t where id in (100,200,300); |
| 14 |
# User@Host: [SQL_SLAVE] @ [] |
| 15 |
# Query_time: 0.000530 Lock_time: 0.000000 Rows_sent: 3 Rows_examined: 3 |
| 16 |
# QC_Hit: No Full_scan: No Full_join: No Tmp_table: No Tmp_table_on_disk: No |
| 17 |
# Filesort: Yes Filesort_on_disk: No Merge_passes: 0 |
| 18 |
# No InnoDB statistics available for this query |
| 19 |
select * from t where id in (1000,2000,3000); |
| 20 |
# User@Host: [SQL_SLAVE] @ [] |
| 21 |
# Query_time: 0.900001 Lock_time: 0.000000 Rows_sent: 4 Rows_examined: 4 |
| 22 |
# QC_Hit: No Full_scan: No Full_join: No Tmp_table: No Tmp_table_on_disk: No |
| 23 |
# Filesort: Yes Filesort_on_disk: No Merge_passes: 0 |
| 24 |
select * from t where id in (10000,20000,30000); |