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 |
| 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 |
| 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 |
| 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 |
| use cokdb80; SET timestamp=N; SELECT /*!N SQL_NO_CACHE */ * FROM `goods_cost_record_2019 ... |
1 |
347.86 |
0.00 |
4952100.00 |
4952101.00 |
100.00% |
10.121.51.32->8 |
| SET timestamp=N; SELECT /*!N SQL_NO_CACHE */ * FROM `goods_cost_record_201901` |
1 |
345.58 |
0.00 |
5529420.00 |
5529419.00 |
100.00% |
10.121.51.32->9 |
| use cokdb80; SET timestamp=N; SELECT /*!N SQL_NO_CACHE */ * FROM `goods_cost_record_2018 ... |
1 |
342.20 |
0.00 |
6156340.00 |
6156338.00 |
100.00% |
10.121.51.32->10 |
详细SQL
use cokdb100; SET timestamp=N; SELECT /*!N SQL_NO_CACHE */ * FROM `mail`