在执行一个大数据量并发查询每个查询为700W,6个并发同时查询,完成后进行另外7个查询,总数据量8KW,逐条查询1W条缓存写一次文件。数据大小8GB。
| STARTTIME | ENDTIME | COST |
程序1 | 13:20:44 | 13:33:20 | 13 |
程序2 | 13:20:44 | 13:36:38 | 16 |
程序3 | 13:20:44 | 13:36:43 | 16 |
程序4 | 13:20:44 | 13:36:51 | 16 |
程序5 | 13:20:44 | 13:36:42 | 16 |
程序6 | 13:20:44 | 13:36:50 | 16 |
程序7 | 13:37:44 | 13:55:18 | 18 |
程序8 | 13:37:44 | 13:55:06 | 18 |
程序9 | 13:37:44 | 13:55:26 | 18 |
程序10 | 13:37:44 | 13:55:28 | 18 |
程序11 | 13:37:44 | 13:55:25 | 18 |
程序12 | 13:37:44 | 13:55:26 | 18 |
程序13 | 13:37:44 | 13:42:46 | 5 |
Disk tps statistics | | | CPU: | User% | Sys% | Wait% | Idle% | CPU% |
Avg disk tps during an interval: | 2,820 | | Avg | 3.1 | 4.3 | 0.5 | 92.1 | 7.4 |
Max disk tps during an interval: | 25,357 | | Max | 27.3 | 50.8 | 7.3 | 99.8 | 78.1 |
Max disk tps interval time: | 13:21:40 | | Max:Avg | 8.8 | 11.8 | 15.3 | 1.1 | 10.5 |
Total number of Mbytes read: | 46,537 | | | | | | | |
Total number of Mbytes written: | 25,281 | | | | | | | |
Read/Write Ratio: | 1.8 | | | | | | | |
数据库NMON监控图如下,请教是那里的瓶颈。
收起