虚拟500个用户同时对数据库进行插入操作，每个用户循环插入30条数据。该怎么设计呢

bustersword · 发表于 2011-5-1 16:31:58

本帖最后由 bustersword 于 2011-5-5 09:47 编辑

我的脚本是单用户登陆系统并插入2张图片，然后注销，
然后我迭代插入的action15次。什么参数化，关联，搞好后，我就放到controller中了，虚拟500个用户，直接运行- -
然后结果就是数据库了只进入了1000多条数据，理论上应该有15000条数据的.......我感觉是时间太紧凑了，用户之间的操作，来不及响应？
我也设置thinktime的，难道没用么？
大大们给点帮助，谢谢了，第一次用loadrunner测试系统.....实在没办法老大突然叫测性能，我了个去，叫我一个开发的做测试，还好以前摸过loadrunner，不过也只是鸡毛蒜皮，实在没办法，求助大大们，帮帮忙

以上的丢失，我通过改写脚本，不会出现这么大量的丢失了，是我脚本每写好的原因，现在的问题是我下面遇到的。。。请大家看接下去回答的部分，需要翻页，真不好意思 19楼往下

zhongmiao88 · 发表于 2011-5-2 08:06:06

脚本在那台负载机上可以成功运行

andyfly_001 · 发表于 2011-5-2 11:26:12

看楼主的情况要么是连接超时，要么是写操作有错误，看日志就明了。

bustersword · 发表于 2011-5-2 15:46:28

我想问，怎样的脚本在control中运行，才能合理，测出系统的性能

bustersword · 发表于 2011-5-2 15:48:12

我的脚本是没问题的，少量用户执行，也行，就是500用户- -......

herryshell · 发表于 2011-5-2 17:08:32

看你的描述,我决得你现在是单用户执行了15次同样的操作
而不是每个用户执行一次操作后注销.

msnshow · 发表于 2011-5-2 17:33:06

这个得一步步的来查原因，可能原因太多

bustersword · 发表于 2011-5-2 17:45:58

明天去公司，把脚本给给位看看，还有什么执行结果，再研究研究

bustersword · 发表于 2011-5-3 13:41:17

我又来了，今天我用50个用户跑了一遍，成功导入1500条数据

Maximum Running Vusers:	50
Total Throughput (bytes):[/url]	633,007,167
Average Throughput (bytes/second):[/url]	831,810
Total Hits:[/url]	19,750
Average Hits per Second:[/url]	25.953	View HTTP Responses Summary[/url]

Transaction Summary

Transactions:[/url]

Total Passed: 3,950

Total Failed: 0

Total Stopped: 0

Average Response Time[/url]

Transaction Name	Minimum	Average	Maximum	Std. Deviation	90 Percent	Pass	Fail	Stop
Action_Transaction	5.434	13.573	22.149	2.397	16.441	750	0	0
inputend	0.106	1.809	5.202	1.348	3.622	750	0	0
inputselect	1.445	4.439	7.542	1.154	5.692	750	0	0
login	2.531	2.732	3.124	0.156	2.986	50	0	0
loginout	0.001	0.072	1.971	0.295	0.026	50	0	0
save1	0.165	2.181	5.591	1.316	4	750	0	0
save2	0.185	1.68	5.805	0.945	2.914	750	0	0
vuser_end_Transaction	0.001	0.072	1.971	0.295	0.026	50	0	0
vuser_init_Transaction	4.212	4.642	5.199	0.249	4.923	50	0	0

HTTP Responses Summary

HTTP Responses	Total	Per second
HTTP_200	18,950	24.901
HTTP_302	800	1.051

save1与save2 就是保存数据的transaction

然后我用100个用户跑的时候，又出问题了，只插入了2731条数据，其实应该插入3000条，又丢失了.....

bustersword · 发表于 2011-5-3 13:43:20

cenario Name:	Scenario1
Results in Session:	d:\100users\res\res.lrr
Duration:	15 minutes and 43 seconds.

Statistics Summary

Maximum Running Vusers:	100
Total Throughput (bytes):	1,266,942,752
Average Throughput (bytes/second):	1,342,100
Total Hits:	39,500
Average Hits per Second:	41.843	View HTTP Responses Summary

Transaction Summary

Transactions:

Total Passed: 7,900

Total Failed: 0

Total Stopped: 0

Average Response Time

Transaction Name	Minimum	Average	Maximum	Std. Deviation	90 Percent	Pass	Fail	Stop
Action_Transaction	7.856	25.777	47.044	7.197	35.107	1,500	0	0
inputend	0.004	4.024	8.974	2.16	6.758	1,500	0	0
inputselect	2.686	8.805	14.418	2.104	11.092	1,500	0	0
login	0.073	1.751	3.094	0.636	2.482	100	0	0
loginout	0.001	0.657	2.266	0.785	2.053	100	0	0
save1	0.176	3.252	10.304	2.28	6.487	1,500	0	0
save2	0.131	2.93	18.142	2.258	5.399	1,500	0	0
vuser_end_Transaction	0.002	0.657	2.266	0.785	2.053	100	0	0
vuser_init_Transaction	0.316	1.964	3.409	0.679	2.691	100	0	0

HTTP Responses Summary

HTTP Responses	Total	Per second
HTTP_200	37,900	40.148
HTTP_302	1,600	1.695

Filters: (do not Include Think Time)

下面是个别Vuser的log,这两个用户有处理同一张图片，但是数据库里只记录了test71的数据

Start auto log messages stack.
vuser_init.c(53): Registering web_url("WebResource.axd") was successful
vuser_init.c(61): Registering web_url("logo_cn.png") was successful
vuser_init.c(69): web_concurrent_end was successful, 130304 body bytes, 800 header bytes
vuser_init.c(71): Notify: Transaction "login" started.
vuser_init.c(73): lr_think_time: 3.00 seconds.
vuser_init.c(75): Redirecting "http://192.169.10.12/impweb/index.aspx" (redirection depth=0)
vuser_init.c(75): To location "http://192.169.10.12/impweb/Main/Main.aspx"
vuser_init.c(75): web_submit_data("index.aspx") was successful, 1182 body bytes, 478 header bytes
vuser_init.c(92): Error: 登录用户名---> test1
End auto log messages stack.

Start auto log messages stack - Iteration 1.
Action.c(198): Registering web_reg_save_param was successful
Action.c(203): Registering web_reg_save_param was successful
Action.c(209): Registering web_reg_save_param was successful
Action.c(215): Registering web_reg_save_param was successful
Action.c(223): Redirecting "http://192.169.10.12/impweb/DataInput/DataIInputSelect.aspx" (redirection depth=0)
Action.c(223): To location "http://192.169.10.12/impweb/DataInput/DataInput_Model_1_Horizontal.aspx"
Action.c(223): web_submit_data("DataIInputSelect.aspx_5") was successful, 76050 body bytes, 509 header bytes
Action.c(244): Error: 组别---> 001
Action.c(245): Error: 第一张图片名 : 1001_a_001_001.jpg
Action.c(246): Error: 用户名: test1
Action.c(247): Error: 第一次录入剩余图片数  : 1045
End auto log messages stack.

Start auto log messages stack - Iteration 1.
Action.c(315): web_convert_param was successful
Action.c(321): Resource "http://192.169.10.12/impweb/BusinessCardPicture/test0414/test0414/test0429/1001_a_001_001.jpg" is in the cache already and will not be downloaded again
Action.c(335): Registering web_reg_save_param was successful
Action.c(341): Registering web_reg_save_param was successful
Action.c(348): Registering web_reg_save_param was successful
Action.c(354): web_submit_data("DataInput_Model_1_Horizontal.aspx_2") was successful, 12792 body bytes, 223 header bytes
Action.c(383): Error: 第二张图片名 : 1356_b_001_001.jpg
Action.c(385): Error: 第二次录入图片剩余数  : 1041
End auto log messages stack.

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

bustersword · 发表于 2011-5-3 13:43:26

Start auto log messages stack.
vuser_init.c(53): Registering web_url("WebResource.axd") was successful
vuser_init.c(61): Registering web_url("logo_cn.png") was successful
vuser_init.c(69): web_concurrent_end was successful, 130304 body bytes, 800 header bytes
vuser_init.c(71): Notify: Transaction "login" started.
vuser_init.c(73): lr_think_time: 3.00 seconds.
vuser_init.c(75): Redirecting "http://192.169.10.12/impweb/index.aspx" (redirection depth=0)
vuser_init.c(75): To location "http://192.169.10.12/impweb/Main/Main.aspx"
vuser_init.c(75): web_submit_data("index.aspx") was successful, 1182 body bytes, 478 header bytes
vuser_init.c(92): Error: 登录用户名---> test71
End auto log messages stack.

Start auto log messages stack - Iteration 1.
Action.c(198): Registering web_reg_save_param was successful
Action.c(203): Registering web_reg_save_param was successful
Action.c(209): Registering web_reg_save_param was successful
Action.c(215): Registering web_reg_save_param was successful
Action.c(223): Redirecting "http://192.169.10.12/impweb/DataInput/DataIInputSelect.aspx" (redirection depth=0)
Action.c(223): To location "http://192.169.10.12/impweb/DataInput/DataInput_Model_1_Horizontal.aspx"
Action.c(223): web_submit_data("DataIInputSelect.aspx_5") was successful, 76055 body bytes, 509 header bytes
Action.c(244): Error: 组别---> 001
Action.c(245): Error: 第一张图片名 : 1001_a_001_001.jpg
Action.c(246): Error: 用户名: test71
Action.c(247): Error: 第一次录入剩余图片数  : 1046
End auto log messages stack.

Start auto log messages stack - Iteration 1.
Action.c(315): web_convert_param was successful
Action.c(321): Resource "http://192.169.10.12/impweb/BusinessCardPicture/test0414/test0414/test0429/1001_a_001_001.jpg" is in the cache already and will not be downloaded again
Action.c(335): Registering web_reg_save_param was successful
Action.c(341): Registering web_reg_save_param was successful
Action.c(348): Registering web_reg_save_param was successful
Action.c(354): web_submit_data("DataInput_Model_1_Horizontal.aspx_2") was successful, 12792 body bytes, 223 header bytes
Action.c(383): Error: 第二张图片名 : 1002_b_001_001.jpg
Action.c(385): Error: 第二次录入图片剩余数  : 1043
End auto log messages stack.

阿星爱美酒 · 发表于 2011-5-3 14:56:26

强悍。。。学习中！

bustersword · 发表于 2011-5-3 15:33:59

求助.......................
为什么用户一多，就丢失数据了............

jsqyue · 发表于 2011-5-3 16:29:39

看看中间件的配置，另外，loadrunner上没有报错吗？
你把测试场景重新设置一下看看，比如1s登陆2个vuser
我估计时中间件压力太大了，vuser少的时候还可以登陆，多的时候就shut down了，另外，把插入图片的脚本前设置下思考时间

hongliangqing · 发表于 2011-5-3 16:47:04

明白了吗？帽子

soarsky629 · 发表于 2011-5-3 17:32:44

我觉得thinktime是一种可能，还有可能是不是迭代次数太多了……？？

dionysus · 发表于 2011-5-3 23:23:59

监控下应用服务器和数据库吧

jj_ljw · 发表于 2011-5-4 09:11:18

如果500人全部执行成功，可能是你数据库接收速度跟不上吧

bustersword · 发表于 2011-5-4 14:58:39

我今天又重新写了下脚本下面是执行的结果

50Vuser *15条数据
一次性加载50VUuser

Analysis Summary

Period: 04-05-2011 11:59:14 - 04-05-2011 12:01:54

Scenario Name:	Scenario1
Results in Session:	d:\res\res\res.lrr
Duration:	2 minutes and 40 seconds.

Statistics Summary

Maximum Running Vusers:	50
Total Throughput (bytes):	86,699,121
Average Throughput (bytes/second):	538,504
Total Hits:	5,750
Average Hits per Second:	35.714	View HTTP Responses Summary

Transaction Summary

Transactions:

Total Passed: 1,800

Total Failed: 0

Total Stopped: 0

Average Response Time

Transaction Name	Minimum	Average	Maximum	Std. Deviation	90 Percent	Pass	Fail	Stop
Action_Transaction	3.789	8.68	13.499	2.334	11.486	50	0	0
login	0.113	1.341	2.131	0.648	2.062	50	0	0
loginout	0.002	0.003	0.038	0.005	0.002	50	0	0
outInput	0.108	0.187	0.257	0.035	0.237	50	0	0
save1	0.167	2.481	6.21	1.406	4.168	50	0	0
save2	0.154	0.552	4.965	0.432	0.953	700	0	0
SavePicSingle_Transaction	0.154	0.553	4.966	0.432	0.953	700	0	0
startInput	0.902	5.123	6.399	1.092	6.265	50	0	0
vuser_end_Transaction	0.11	0.19	0.262	0.036	0.24	50	0	0
vuser_init_Transaction	0.128	1.367	2.202	0.651	2.099	50	0	0
file:///C:/Documents%20and%20Settings/Administrator/%E6%A1%8C%E9%9D%A2/15%E4%B9%9850%E7%94%A8%E6%88%B7-%E7%BB%93%E6%9E%9C%E5%88%86%E6%9E%90-2011-5-4/15%E4%B9%9850%E7%94%A8%E6%88%B7-%E7%BB%93%E6%9E%9C%E5%88%86%E6%9E%90-2011-5-4/dot_trans.gif

HTTP Responses Summary

HTTP Responses	Total	Per second
HTTP_200	5,650	35.093
HTTP_302	100	0.621
file:///C:/Documents%20and%20Settings/Administrator/%E6%A1%8C%E9%9D%A2/15%E4%B9%9850%E7%94%A8%E6%88%B7-%E7%BB%93%E6%9E%9C%E5%88%86%E6%9E%90-2011-5-4/15%E4%B9%9850%E7%94%A8%E6%88%B7-%E7%BB%93%E6%9E%9C%E5%88%86%E6%9E%90-2011-5-4/dot_trans.gif

file:///C:/Documents%20and%20Settings/Administrator/%E6%A1%8C%E9%9D%A2/15%E4%B9%9850%E7%94%A8%E6%88%B7-%E7%BB%93%E6%9E%9C%E5%88%86%E6%9E%90-2011-5-4/15%E4%B9%9850%E7%94%A8%E6%88%B7-%E7%BB%93%E6%9E%9C%E5%88%86%E6%9E%90-2011-5-4/dot_trans.gif

Filters: (do not Include Think Time)

bustersword · 发表于 2011-5-4 15:00:54

80Vuser*15条数据一次性加载80Vuser

Analysis Summary

Period: 04-05-2011 13:14:16 - 04-05-2011 13:18:32

Scenario Name:	Scenario1
Results in Session:	d:\res\res\res.lrr
Duration:	4 minutes and 16 seconds.

Statistics Summary

Maximum Running Vusers:	80
Total Throughput (bytes):	138,615,393
Average Throughput (bytes/second):	539,360
Total Hits:	9,198
Average Hits per Second:	35.79	View HTTP Responses Summary

Transaction Summary

Transactions:

Total Passed: 2,876

Total Failed: 4

Total Stopped: 0

Average Response Time

Transaction Name	Minimum	Average	Maximum	Std. Deviation	90 Percent	Pass	Fail	Stop
Action_Transaction	7.771	16.744	36.374	5.227	22.539	80	0	0
login	0.069	1.188	2.539	0.655	2.07	80	0	0
loginout	0.001	0.002	0.006	0.001	0.002	80	0	0
outInput	0.004	0.213	0.846	0.089	0.267	80	0	0
save1	1.732	4.734	21.745	3.141	6.622	80	0	0
save2	0.15	1.784	25.136	2.32	3.128	1,118	2	0
SavePicSingle_Transaction	0.15	1.784	25.136	2.32	3.128	1,118	2	0
startInput	0.796	8.564	11.796	2.481	10.253	80	0	0
vuser_end_Transaction	0.006	0.215	0.848	0.089	0.27	80	0	0
vuser_init_Transaction	0.285	1.368	2.565	0.573	2.111	80	0	0
file:///C:/Documents%20and%20Settings/Administrator/%E6%A1%8C%E9%9D%A2/15%E4%B9%9880%E7%94%A8%E6%88%B7-%E7%BB%93%E6%9E%9C%E5%88%86%E6%9E%90-2011-5-4/15%E4%B9%9880%E7%94%A8%E6%88%B7-%E7%BB%93%E6%9E%9C%E5%88%86%E6%9E%90-2011-5-4/dot_trans.gif

HTTP Responses Summary

HTTP Responses	Total	Per second
HTTP_200	9,038	35.167
HTTP_302	160	0.623
file:///C:/Documents%20and%20Settings/Administrator/%E6%A1%8C%E9%9D%A2/15%E4%B9%9880%E7%94%A8%E6%88%B7-%E7%BB%93%E6%9E%9C%E5%88%86%E6%9E%90-2011-5-4/15%E4%B9%9880%E7%94%A8%E6%88%B7-%E7%BB%93%E6%9E%9C%E5%88%86%E6%9E%90-2011-5-4/dot_trans.gif

file:///C:/Documents%20and%20Settings/Administrator/%E6%A1%8C%E9%9D%A2/15%E4%B9%9880%E7%94%A8%E6%88%B7-%E7%BB%93%E6%9E%9C%E5%88%86%E6%9E%90-2011-5-4/15%E4%B9%9880%E7%94%A8%E6%88%B7-%E7%BB%93%E6%9E%9C%E5%88%86%E6%9E%90-2011-5-4/dot_trans.gif

Filters: (do not Include Think Time)

		自动登录	找回密码
密码			(注-册)加入51Testing

[原创] 虚拟500个用户同时对数据库进行插入操作，每个用户循环插入30条数据。该怎么设计呢

相关帖子

站长推荐 /1