2022-05-20 01:30
| SQL |
Count
|
AvgTime(S)
|
AvgLockTime(S) |
ReturnRows |
ScanTotalRows |
Index Used Ratio |
DB |
| use cokdb100; SET timestamp=N; SELECT /*!N SQL_NO_CACHE */ * FROM `mail` |
1 |
1590.72 |
0.00 |
962853.00 |
962853.00 |
100.00% |
10.121.51.32->1 |
| SET timestamp=N; SELECT /*!N SQL_NO_CACHE */ * FROM `world_update_gridtype_tmp` |
1 |
1.58 |
0.00 |
1442400.00 |
1442401.00 |
100.00% |
10.121.51.32->257 |
| use cokdb100; SET timestamp=N; SELECT /*!N SQL_NO_CACHE */ * FROM `report` |
1 |
876.40 |
0.00 |
323358.00 |
323358.00 |
100.00% |
10.121.51.32->2 |
| SET timestamp=N; SELECT /*!N SQL_NO_CACHE */ * FROM `stat_login_2019_9` |
1 |
1.58 |
0.00 |
116040.00 |
116040.00 |
100.00% |
10.121.51.32->258 |
| use cokdb80; SET timestamp=N; SELECT /*!N SQL_NO_CACHE */ * FROM `mail` |
1 |
832.93 |
0.00 |
562737.00 |
562737.00 |
100.00% |
10.121.51.32->3 |
| use cokdb80; SET timestamp=N; SELECT /*!N SQL_NO_CACHE */ * FROM `gold_cost_record` |
1 |
715.15 |
0.00 |
10459800.00 |
10459832.00 |
100.00% |
10.121.51.32->4 |
| SET timestamp=N; SELECT /*!N SQL_NO_CACHE */ * FROM `stat_login_2021_1` |
1 |
1.55 |
0.00 |
65332.00 |
65332.00 |
100.00% |
10.121.51.32->260 |
| use cokdb80; SET timestamp=N; SELECT /*!N SQL_NO_CACHE */ * FROM `goods_cost_record_2018 ... |
1 |
377.76 |
0.00 |
6319930.00 |
6319929.00 |
100.00% |
10.121.51.32->5 |
| use cokdb100; SET timestamp=N; SELECT /*!N SQL_NO_CACHE */ * FROM `user_item` |
1 |
359.05 |
0.00 |
8153290.00 |
8153287.00 |
100.00% |
10.121.51.32->6 |
| SET timestamp=N; SELECT /*!N SQL_NO_CACHE */ * FROM `goods_cost_record_201812` |
1 |
352.56 |
0.00 |
5479570.00 |
5479574.00 |
100.00% |
10.121.51.32->7 |
详细SQL
use cokdb100; SET timestamp=N; SELECT /*!N SQL_NO_CACHE */ * FROM `mail`