???????
???????loadrunner???δ?????mysql????????
???????????????????????ODBC????mysql???????????????????????
??????LR??????????????????dll????????б?дdll????в????
???????????????????????дdll???license????
????????????ο????????Bish.co.uk???????mysql??php??loadrunner??飬
????????????д??mysql?????
????———–????????????———————-
????GRANT ALL PRIVILEGES ON*.*TO'root'@'windows IP'
????IDENTIFIED BY'root'WITHGRANTOPTION;
???????úò???????????
????—————–LoadRunner???п????———————
????a.???MySQL LoadRunner libraries.zip?汾1?汾2?е??????LR?????
????b.??LR??vuser?????init?м?????????
????#include"Ptt_Mysql.h"
????#define MYSQLSERVER"192.168.2.5"
????#define MYSQLUSERNAME"root"
????#define MYSQLPASSWORD"root"
????#define MYSQLDB"tpch_1"
????#define MYSQLPORT"5029"
????c.??action????????sql????????
????lr_load_dll("libmysql.dll");
????———————–vu?????д??????c????————————–
????//action?м???
????char chQuery[128];
????MYSQL*Mconn;
????//??sql???????char??
????lr_load_dll("libmysql.dll");
????//???sql???????dll??
????Mconn=lr_mysql_connect(MYSQLSERVER??MYSQLUSERNAME??
????MYSQLPASSWORD??MYSQLDB??
????atoi(MYSQLPORT));
????//??init??define?ж?????????
????sprintf(chQuery??"select N_NATIONKEY??N_NAME??N_REGIONKEY from
????nation limit 3;");
????lr_mysql_query(Mconn??chQuery);
????//??????д?????????dll?е?lr_mysql_query??????????
????lr_save_string(row[0][0].cell??"sN_NATIONKEY");
????lr_save_string(row[1][0].cell??"sN_NAME");
????lr_save_string(row[2][0].cell??"sN_REGIONKEY");
????//?????????浽????????С?????????????????
????lr_output_message(lr_eval_string("N_NATIONKEY:{sN_NATIONKEY};
????N_NAME:{sN_NAME};N_REGIONKEY Description:{sN_REGIONKEY}"));
????lr_save_string(row[0][1].cell??"sN_NATIONKEY");
????lr_save_string(row[1][1].cell??"sN_NAME");
????lr_save_string(row[2][1].cell??"sJobDesc");
????lr_output_message(lr_eval_string("N_NATIONKEY:{sN_NATIONKEY};
????N_NAME:{sN_NAME};N_REGIONKEY Description:{
????//vu_end?м???
????lr_mysql_disconnect(Mconn);
????//???????
????———–?????linux????????———
????a.???rsh
?????????
????rpm-q rsh
????b.???rstat??????
????????
????http://sourceforge.net/projects/rstatd/files/rstatd/4.0.1/rpc.rstatd-4.0.1.tar.gz/download
????#tar–xzvf rpc.rstatd-4.0.1.tar.gz
????#./configure
????//????
????#make
????//????
????#make install
????//???
????#rpc.rstatd
????//???rstatd????
????c.??rstatd????????
????#rpcinfo-p
??????????????
????100001 5 udp 892 rstatd
????100001 3 udp 892 rstatd
????100001 2 udp 892 rstatd
????100001 1 udp 892 rstatd
???????rstatd??????????????????LR????????
????d.??LoadRunner Controller??run?????У????System Resource Graphs?μ?Unix Resource????Unix Resource??????Add Measurements???????Add????дip??192.168.1.99??????????????????????Add?п?????????????
????—————-lr control——-
???????controller?趨vu???????????????????ú??linux?????????????в??????????analyse???з?????
????????????????????????analyse?????????????
???????????dml?????в????????????????滮????insert 10????delete10??