Re: JDBC test script error" The result of 'TestRunner()' is not callable"

Marc Holden <[email protected]> Thu, 15 Oct 2015 11:26:33 +0000
Newsgroups gmane.comp.java.grinder.user
Message-ID <CADV_OVV6V+vZ1mP81Ws6i2_sNU=hVnL9Y8Q+7WAAUxS=k6Um-g@mail.gmail.com>
--===============5749321411287806026==
Content-Type: multipart/alternative; boundary=001a113eee3c10a7f5052222f4c4

--001a113eee3c10a7f5052222f4c4
Content-Type: text/plain; charset=UTF-8

Hi Gang,

You can probably squeeze out a few more TPS by adding some sleep statements
between 10 and 50ms.  Make sure you are monitoring the CPU and memory usage
of the agent box as well as the cpu, memory, iops of the db server as
well.  It is very possible that your agent box is becoming resource
starved.  If you have room on the agent, it is more than likely as Gary
said...

On Thu, Oct 15, 2015 at 5:26 AM Gary Mulder <[email protected]> wrote:

> On 15 October 2015 at 10:02, Gang Yan <[email protected]> wrote:
>
>
>> Tests                   Errors          Mean Test       Test Time     TPS
>>
>>
>>                                                  Time (ms)
>>    Standard
>>
>>                                                  Deviation
>>
>>
>>                                                     (ms)
>>
>>
>>
>>
>> Test 1       1000         0            23.87             30.77
>>      3.31          "JDBC Test Result_Multi-Threads"
>>
>> Test 2       1000         0            17.95            27.38
>>      3.31          "JDBC Test Result_Multi-Threads"
>>
>>
>>
>> Totals       2000         0            20.91            29.27
>>     6.61
>>
>>
>>
>> Have any suggest  for improve TPS value ?
>>
>
> Buy a faster DB? You're probably testing the disk I/O on the DB server.
>
> Regards,
> Gary
>
> ------------------------------------------------------------------------------
> _______________________________________________
> grinder-use mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/grinder-use
>

--001a113eee3c10a7f5052222f4c4
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: base64

PGRpdiBkaXI9Imx0ciI+SGkgR2FuZyw8ZGl2Pjxicj48L2Rpdj48ZGl2PllvdSBjYW4gcHJvYmFi
bHkgc3F1ZWV6ZSBvdXQgYSBmZXcgbW9yZSBUUFMgYnkgYWRkaW5nIHNvbWUgc2xlZXAgc3RhdGVt
ZW50cyBiZXR3ZWVuIDEwIGFuZCA1MG1zLsKgIE1ha2Ugc3VyZSB5b3UgYXJlIG1vbml0b3Jpbmcg
dGhlIENQVSBhbmQgbWVtb3J5IHVzYWdlIG9mIHRoZSBhZ2VudCBib3ggYXMgd2VsbCBhcyB0aGUg
Y3B1LCBtZW1vcnksIGlvcHMgb2YgdGhlIGRiIHNlcnZlciBhcyB3ZWxsLsKgIEl0IGlzIHZlcnkg
cG9zc2libGUgdGhhdCB5b3VyIGFnZW50IGJveCBpcyBiZWNvbWluZyByZXNvdXJjZSBzdGFydmVk
LsKgIElmIHlvdSBoYXZlIHJvb20gb24gdGhlIGFnZW50LCBpdCBpcyBtb3JlIHRoYW4gbGlrZWx5
IGFzIEdhcnkgc2FpZC4uLiDCoMKgPC9kaXY+PC9kaXY+PGJyPjxkaXYgY2xhc3M9ImdtYWlsX3F1
b3RlIj48ZGl2IGRpcj0ibHRyIj5PbiBUaHUsIE9jdCAxNSwgMjAxNSBhdCA1OjI2IEFNIEdhcnkg
TXVsZGVyICZsdDs8YSBocmVmPSJtYWlsdG86Zmx5aW5na2l3aWd1eUBnbWFpbC5jb20iPmZseWlu
Z2tpd2lndXlAZ21haWwuY29tPC9hPiZndDsgd3JvdGU6PGJyPjwvZGl2PjxibG9ja3F1b3RlIGNs
YXNzPSJnbWFpbF9xdW90ZSIgc3R5bGU9Im1hcmdpbjowIDAgMCAuOGV4O2JvcmRlci1sZWZ0OjFw
eCAjY2NjIHNvbGlkO3BhZGRpbmctbGVmdDoxZXgiPjxkaXYgZGlyPSJsdHIiPjxkaXYgY2xhc3M9
ImdtYWlsX2V4dHJhIj48ZGl2IGNsYXNzPSJnbWFpbF9xdW90ZSI+T24gMTUgT2N0b2JlciAyMDE1
IGF0IDEwOjAyLCBHYW5nIFlhbiA8c3BhbiBkaXI9Imx0ciI+Jmx0OzxhIGhyZWY9Im1haWx0bzp5
YW4uZ2FuZ0BvcmFjbGUuY29tIiB0YXJnZXQ9Il9ibGFuayI+eWFuLmdhbmdAb3JhY2xlLmNvbTwv
YT4mZ3Q7PC9zcGFuPiB3cm90ZTo8YnI+PGRpdj7CoDwvZGl2PjxibG9ja3F1b3RlIGNsYXNzPSJn
bWFpbF9xdW90ZSIgc3R5bGU9Im1hcmdpbjowIDAgMCAuOGV4O2JvcmRlci1sZWZ0OjFweCAjY2Nj
IHNvbGlkO3BhZGRpbmctbGVmdDoxZXgiPjxkaXYgbGFuZz0iWkgtQ04iIGxpbms9ImJsdWUiIHZs
aW5rPSJwdXJwbGUiPjxwIGNsYXNzPSJNc29Ob3JtYWwiPlRlc3RzwqDCoMKgwqDCoMKgwqAgwqDC
oMKgwqDCoMKgwqDCoMKgwqDCoEVycm9yc8KgwqDCoMKgIMKgwqDCoMKgwqBNZWFuIFRlc3TCoMKg
wqDCoMKgIMKgVGVzdCBUaW1lwqDCoMKgwqAgVFBTIMKgIMKgIMKgIMKgwqA8YnI+PC9wPjxwPjxz
cGFuIGxhbmc9IkVOLVVTIj7CoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKg
wqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDC
oFRpbWUgKG1zKcKgwqDCoMKgIMKgwqDCoFN0YW5kYXJkwqDCoMKgwqDCoMKgwqAgwqDCoMKgwqDC
oMKgwqDCoMKgwqA8dT48L3U+PHU+PC91Pjwvc3Bhbj48L3A+PHA+PHNwYW4gbGFuZz0iRU4tVVMi
PsKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKg
wqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgRGV2aWF0aW9uwqDCoMKg
wqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqAgPHU+PC91Pjx1PjwvdT48L3NwYW4+PC9wPjxwPjxz
cGFuIGxhbmc9IkVOLVVTIj7CoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKg
wqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDC
oMKgwqDCoChtcynCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqAgPHU+
PC91Pjx1PjwvdT48L3NwYW4+PC9wPjxwPjxzcGFuIGxhbmc9IkVOLVVTIj48dT48L3U+wqA8dT48
L3U+PC9zcGFuPjwvcD48cD48c3BhbiBsYW5nPSJFTi1VUyI+VGVzdCAxwqDCoMKgwqDCoMKgIDEw
MDDCoMKgwqDCoMKgwqDCoMKgIDDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgIDIzLjg3wqDCoMKgwqDC
oMKgIMKgwqDCoMKgwqDCoDMwLjc3wqDCoMKgwqDCoMKgIMKgwqDCoMKgwqAzLjMxwqDCoMKgwqDC
oMKgwqDCoMKgICZxdW90O0pEQkMgVGVzdCBSZXN1bHRfTXVsdGktVGhyZWFkcyZxdW90Ozx1Pjwv
dT48dT48L3U+PC9zcGFuPjwvcD48cD48c3BhbiBsYW5nPSJFTi1VUyI+VGVzdCAywqDCoMKgwqDC
oMKgIDEwMDDCoMKgwqDCoMKgwqDCoMKgIDDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgIDE3Ljk1wqDC
oMKgwqDCoMKgIMKgwqDCoMKgwqAyNy4zOMKgwqDCoMKgwqDCoMKgIMKgwqDCoMKgwqAzLjMxwqDC
oMKgwqDCoMKgwqDCoMKgICZxdW90O0pEQkMgVGVzdCBSZXN1bHRfTXVsdGktVGhyZWFkcyZxdW90
Ozx1PjwvdT48dT48L3U+PC9zcGFuPjwvcD48cD48c3BhbiBsYW5nPSJFTi1VUyI+PHU+PC91PsKg
PHU+PC91Pjwvc3Bhbj48L3A+PHA+PHNwYW4gbGFuZz0iRU4tVVMiPlRvdGFsc8KgwqDCoMKgwqDC
oCAyMDAwwqDCoMKgwqDCoMKgwqDCoCAwwqDCoMKgwqDCoMKgwqDCoMKgwqDCoCAyMC45McKgwqDC
oMKgwqDCoMKgIMKgwqDCoMKgMjkuMjfCoMKgwqDCoMKgwqDCoCDCoMKgwqDCoDYuNjHCoMKgwqDC
oMKgwqDCoMKgIDx1PjwvdT48dT48L3U+PC9zcGFuPjwvcD48cD48c3BhbiBsYW5nPSJFTi1VUyI+
PHU+PC91PsKgPHU+PC91Pjwvc3Bhbj48L3A+PHA+PHNwYW4gbGFuZz0iRU4tVVMiPkhhdmUgYW55
IHN1Z2dlc3TCoCBmb3IgaW1wcm92ZSBUUFMgdmFsdWUgPzwvc3Bhbj48L3A+PC9kaXY+PC9ibG9j
a3F1b3RlPjxkaXY+PGJyPjwvZGl2PjwvZGl2PjwvZGl2PjwvZGl2PjxkaXYgZGlyPSJsdHIiPjxk
aXYgY2xhc3M9ImdtYWlsX2V4dHJhIj48ZGl2IGNsYXNzPSJnbWFpbF9xdW90ZSI+PGRpdj5CdXkg
YSBmYXN0ZXIgREI/IFlvdSYjMzk7cmUgcHJvYmFibHkgdGVzdGluZyB0aGUgZGlzayBJL08gb24g
dGhlIERCIHNlcnZlci48L2Rpdj48ZGl2Pjxicj48L2Rpdj48ZGl2PlJlZ2FyZHMsPC9kaXY+PGRp
dj5HYXJ5PC9kaXY+PC9kaXY+PC9kaXY+PC9kaXY+DQotLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS08YnI+
DQpfX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fXzxicj4NCmdy
aW5kZXItdXNlIG1haWxpbmcgbGlzdDxicj4NCjxhIGhyZWY9Im1haWx0bzpncmluZGVyLXVzZUBs
aXN0cy5zb3VyY2Vmb3JnZS5uZXQiIHRhcmdldD0iX2JsYW5rIj5ncmluZGVyLXVzZUBsaXN0cy5z
b3VyY2Vmb3JnZS5uZXQ8L2E+PGJyPg0KPGEgaHJlZj0iaHR0cHM6Ly9saXN0cy5zb3VyY2Vmb3Jn
ZS5uZXQvbGlzdHMvbGlzdGluZm8vZ3JpbmRlci11c2UiIHJlbD0ibm9yZWZlcnJlciIgdGFyZ2V0
PSJfYmxhbmsiPmh0dHBzOi8vbGlzdHMuc291cmNlZm9yZ2UubmV0L2xpc3RzL2xpc3RpbmZvL2dy
aW5kZXItdXNlPC9hPjxicj4NCjwvYmxvY2txdW90ZT48L2Rpdj4NCg==
--001a113eee3c10a7f5052222f4c4--


--===============5749321411287806026==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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

--===============5749321411287806026==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

_______________________________________________
grinder-use mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/grinder-use

--===============5749321411287806026==--