???????

???????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??