100萬條insert
Wed Jul 31 11:59:37 CST 2013
real176m36.179s
user39m53.910s
sys72m1.159s
Wed Jul 31 14:56:13 CST 2013
Wed Jul 31 11:58:12 CST 2013
real176m42.198s
user39m57.748s
sys71m58.955s
Wed Jul 31 14:54:54 CST 2013
每10秒資料量統計
Wed Jul 31 16:24:53 CST 2013
+----------+
| COUNT(*) |
| 4327206 |
Wed Jul 31 16:25:05 CST 2013
| 4328224 |
Wed Jul 31 16:25:17 CST 2013
| 4329228 |
Wed Jul 31 16:25:29 CST 2013
| 4330226 |
Wed Jul 31 16:25:41 CST 2013
小結：基本每用戶端1秒鐘 100左右insert，帶寬對稱1Mbit左右。伺服器入口帶寬成倍增加，一般為兩倍,大約3MBIT左右。
下面是10萬條insert結果
Wed Jul 31 16:45:39 CST 2013
real16m29.286s
user4m57.208s
sys4m8.031s
Wed Jul 31 17:02:08 CST 2013
Thu Aug 1 09:23:15 CST 2013
real 13m33.383s
user 3m54.704s
sys 3m10.448s
Thu Aug 1 09:36:48 CST 2013
Thu Aug 1 09:21:21 CST 2013
real 13m31.438s
user 3m53.810s
sys 3m11.548s
Thu Aug 1 09:34:53 CST 2013
Thu Aug 1 09:29:03 CST 2013
real 19m8.365s
user 7m22.172s
sys 4m32.839s
Thu Aug 1 09:48:11 CST 2013
壓力情況表
兩台測試用戶端：while true;do vmstat 2 5 ;mpstat 2 5;done
procs -----------memory---------- ---swap-- -----io---- --system-- -----cpu-----
r b swpd free buff cache si so bi bo in cs us sy id wa st
2 0 49648 1210540 284676 8921788 0 0 23 35 2 2 0 0 99 0 0
3 0 49648 1210336 284676 8921788 0 0 0 0 8846 3942 4 33 63 0 0
3 0 49648 1209764 284676 8921788 0 0 0 10 8635 3919 3 35 62 0 0
2 0 49648 1209896 284676 8921788 0 0 0 0 11129 6148 8 22 70 0 0
1 0 49648 1209764 284676 8921788 0 0 0 0 13129 8114 13 9 78 0 0
Linux 2.6.32-279.el6.x86_64 (cecgw-zs-cdb02) 08/01/2013 _x86_64_ (8 CPU)
10:21:02 AM CPU %usr %nice %sys %iowait %irq %soft %steal %guest %idle
10:21:04 AM all 13.22 0.00 9.02 0.00 0.00 0.63 0.00 0.00 77.13
10:21:06 AM all 13.10 0.00 8.94 0.00 0.00 0.57 0.00 0.00 77.39
10:21:08 AM all 12.98 0.00 8.59 0.00 0.00 0.56 0.00 0.00 77.87
10:21:10 AM all 6.42 0.00 26.16 0.00 0.00 0.19 0.00 0.00 67.23
10:21:12 AM all 3.21 0.00 34.63 0.00 0.00 0.06 0.00 0.00 62.09
Average: all 9.79 0.00 17.46 0.00 0.00 0.40 0.00 0.00 72.35
3 0 0 832400 1841052 10815416 0 0 62 19 3 1 0 0 99 0 0
2 0 0 835968 1841052 10815416 0 0 0 0 10204 5442 16 10 74 0 0
2 0 0 833364 1841052 10815416 0 0 0 0 10008 5458 16 10 75 0 0
3 0 0 834612 1841052 10815416 0 0 0 0 9964 5359 16 9 75 0 0
3 0 0 834356 1841052 10815416 0 0 0 14 9780 5182 15 9 75 0 0
Linux 2.6.32-220.el6.x86_64 (istore37) 08/01/2013 _x86_64_ (8 CPU)
10:21:57 AM CPU %usr %nice %sys %iowait %irq %soft %steal %guest %idle
10:21:59 AM all 15.38 0.00 8.75 0.00 0.00 0.56 0.00 0.00 75.31
10:22:01 AM all 16.02 0.00 9.60 0.00 0.00 0.62 0.00 0.00 73.75
10:22:03 AM all 15.88 0.00 9.19 0.00 0.00 0.50 0.00 0.00 74.42
10:22:05 AM all 15.47 0.00 8.61 0.00 0.00 0.50 0.00 0.00 75.42
10:22:07 AM all 15.61 0.00 8.77 0.00 0.00 0.62 0.00 0.00 75.00
Average: all 15.67 0.00 8.98 0.00 0.00 0.56 0.00 0.00 74.78
資料庫節點
1 0 0 8962316 305916 4769264 0 0 0 9 0 2 0 0 100 0 0
0 0 0 8961680 305916 4769588 0 0 0 276 23557 21797 3 3 94 0 0
0 0 0 8958392 305924 4770632 0 0 0 1654 23825 22217 3 3 94 0 0
0 0 0 8958176 305924 4770964 0 0 0 274 22406 20981 4 3 93 0 0
0 0 0 8958424 305924 4771092 0 0 0 164 10994 9878 2 2 97 0 0
Linux 2.6.32-279.el6.x86_64 (cecgw-zs-cdb05) 08/01/2013 _x86_64_ (8 CPU)
10:23:09 AM CPU %usr %nice %sys %iowait %irq %soft %steal %guest %idle
10:23:11 AM all 1.65 0.00 1.65 0.00 0.00 0.06 0.00 0.00 96.65
10:23:13 AM all 2.73 0.00 2.35 0.00 0.00 0.06 0.00 0.00 94.86
10:23:15 AM all 3.58 0.00 2.62 0.06 0.00 0.13 0.00 0.00 93.60
10:23:17 AM all 2.86 0.00 2.29 0.00 0.00 0.06 0.00 0.00 94.79
10:23:19 AM all 3.18 0.00 2.42 0.00 0.00 0.06 0.00 0.00 94.34
Average: all 2.80 0.00 2.26 0.01 0.00 0.08 0.00 0.00 94.85
1 0 0 651212 241232 13468068 0 0 0 8 1 1 0 0 100 0 0
0 0 0 651444 241248 13468220 0 0 0 116 7003 6014 1 1 98 0 0
0 0 0 650576 241288 13468684 0 0 0 742 6749 5949 1 1 98 0 0
0 0 0 650320 241320 13468816 0 0 0 136 6978 5984 1 1 98 0 0
0 0 0 650320 241344 13468952 0 0 0 142 6851 5931 1 1 97 0 0
Linux 2.6.32-279.el6.x86_64 (cecgw-zs-cdb03) 08/01/2013 _x86_64_ (8 CPU)
10:24:09 AM CPU %usr %nice %sys %iowait %irq %soft %steal %guest %idle
10:24:11 AM all 1.19 0.00 1.32 0.00 0.00 0.00 0.00 0.00 97.48
10:24:13 AM all 1.26 0.00 1.20 0.00 0.00 0.00 0.00 0.00 97.54
10:24:15 AM all 1.20 0.00 1.13 0.00 0.00 0.00 0.00 0.00 97.67
10:24:17 AM all 1.20 0.00 1.13 0.00 0.00 0.00 0.00 0.00 97.67
10:24:19 AM all 1.26 0.00 0.95 0.00 0.00 0.06 0.00 0.00 97.73
Average: all 1.22 0.00 1.15 0.00 0.00 0.01 0.00 0.00 97.62
0 0 0 9347628 307172 4585272 0 0 0 2 2 1 0 0 100 0 0
1 0 0 9346876 307172 4585756 0 0 2 172 16008 15852 2 2 95 0 0
0 0 0 9346504 307172 4586384 0 0 2 164 15564 15546 2 2 96 0 0
0 0 0 9346132 307172 4586724 0 0 4 162 15514 15356 2 2 96 0 0
2 0 0 9345636 307172 4587260 0 0 2 184 17856 17446 3 2 95 0 0
Linux 2.6.32-358.6.2.el6.x86_64 (cecgw-zs-cdb04) 08/01/2013 _x86_64_ (8 CPU)
10:24:45 AM CPU %usr %nice %sys %iowait %irq %soft %steal %guest %idle
10:24:47 AM all 0.82 0.00 0.75 0.31 0.00 0.06 0.00 0.00 98.05
10:24:49 AM all 0.56 0.00 0.56 0.00 0.00 0.00 0.00 0.00 98.87
10:24:51 AM all 0.82 0.00 0.88 0.00 0.00 0.06 0.00 0.00 98.24
10:24:53 AM all 2.53 0.00 2.15 0.00 0.00 0.06 0.00 0.00 95.25
10:24:55 AM all 2.41 0.00 2.09 0.06 0.00 0.13 0.00 0.00 95.31
Average: all 1.42 0.00 1.29 0.08 0.00 0.06 0.00 0.00 97.15
入口節點壓力表
3 0 14256 5128404 288900 5596416 0 0 24 39 0 3 0 1 98 0 0
3 0 14256 5127216 288900 5596916 0 0 0 14 53299 81562 12 12 76 0 0
2 0 14256 5126576 288900 5597416 0 0 0 0 51953 79514 12 12 76 0 0
1 0 14256 5126940 288900 5597912 0 0 0 8 54769 82998 12 13 75 0 0
1 0 14256 5126424 288900 5598408 0 0 0 18 53335 81130 12 12 76 0 0
Linux 2.6.32-279.el6.x86_64 (cecgw-zs-cdb01) 08/01/2013 _x86_64_ (8 CPU)
10:26:09 AM CPU %usr %nice %sys %iowait %irq %soft %steal %guest %idle
10:26:11 AM all 12.29 0.00 9.29 0.00 0.06 3.25 0.00 0.00 75.11
10:26:13 AM all 8.59 0.00 5.79 0.00 0.00 2.10 0.00 0.00 83.52
10:26:15 AM all 7.81 0.00 5.33 0.00 0.00 1.97 0.00 0.00 84.89
10:26:17 AM all 11.64 0.00 8.44 0.00 0.00 3.64 0.00 0.00 76.28
10:26:19 AM all 11.96 0.00 9.02 0.00 0.00 3.32 0.00 0.00 75.70
Average: all 10.45 0.00 7.57 0.00 0.01 2.85 0.00 0.00 79.11
本文轉自 jxwpx 51CTO部落格，原文連結：http://blog.51cto.com/jxwpx/1261610，如需轉載請自行聯系原作者
![【MySQL資料庫】資料庫索引事務1.索引2.事務[圖]](data:image/gif;base64,R0lGODlhAQABAIAAAP///wAAACwAAAAAAQABAAACAkQBADs=)