lr监控mysql_如何使用LoadRunner来监控MySql数据库的性能

Monitoring mySQL Databases

Monitoring aMySQLdatabase requires the use of a JDBC driver. To enable SiteScope to monitor a MySQL database:Uncompress the distribution file

Among all the other files, you should find a file with a .jar extension.

Copy the .jar file into the/SiteScope/java/lib/extdirectory

Stop and restart SiteScope

Now, use your browser to add a Database Query Monitor within SiteScope.

The Database Connection URL format for the MySQL JDBC driver is:

jdbc:mysql://[:]/For example to connect to the MySQL database "aBigDatabase" on a machine using the standard MySQL port number3306you would use:

jdbc:mysql://206.168.191.19/aBigDatabase

If you are using a different port to connect to the database then you should include that port number as part of the IP address.

The specification for the MySQL JDBC driver is:org.gjt.mm.mysql.Driver

Enter this string into the Database Driver text box under theAdvanced Optionssection of the Add Database Query Monitor form.

二、通过编写脚本来进行监控

// mysql_dll.cpp : Defines the entry point for the DLL application.

#include "stdafx.h"

#include "stdlib.h"

MYSQL *conn=NULL;

MYSQL_RES *p_res_ptr=NULL;

MYSQL_ROW sqlrows;

BOOL APIENTRY DllMain( HANDLE hModule,

DWORD  ul_reason_for_call,

LPVOID lpReserved

)

{

return TRUE;

}

extern "C" int _declspec(dllexport) init_mysql_connection(char *str_server,char *str_username,char *str_pwd,char *str_Table)

{

conn=mysql_init(NULL);

if(!conn)

{

printf("\nFailed to initate MySQL connection");

return 1;

exit(0);

}

else

{

printf("\nSuccess to initate MySQL connection");

if (!mysql_real_connect(conn,str_server,str_username,str_pwd,str_Table,0,NULL,0))

{

printf( "Failed to connect to MySQL: Error: %s\n", mysql_error(conn));

}

else

{

printf("\nLogged on to %s sucessfully",str_server);

return 0;

}

return 0;

}

}

extern "C" int _declspec(dllexport) close_mysql_connection()

{

if(conn=NULL)

{

printf("\nConnection is Null");

return 1;

exit(0);

}

else

{

mysql_free_result(p_res_ptr);

printf("\nClose connection");

mysql_close(conn);

return 0;

}

}

//"show status like \'qcache%\'"

extern "C" int _declspec(dllexport) get_mysql_table_query(char *str_query)

{

int res=0;

res=mysql_query(conn,str_query);

if(res)

{

printf("Failed to mysql query: Error: %s\n", mysql_error(conn));

return 1;

}

else

{

printf("\nSucess in Mysql Query");

return 0;

}

}

extern "C" int _declspec(dllexport) get_mysql_query_data(char *str_query,char *str_data)

{

unsigned long u1_numrow=0;

unsigned int i_index = 0;

p_res_ptr=mysql_use_result(conn);

if(p_res_ptr){

while((sqlrows=mysql_fetch_row(p_res_ptr))){

if(*sqlrows[0]=*str_query)

{

strcpy(str_data,sqlrows[1]);

}

}

}

return NULL;

}

lr 9.1中代码：

Action()

{

int i=0;

double x;

char *str_data;

str_data=(char *)malloc(20*sizeof(char));

lr_load_dll("D:\\vc\\mysql_dll\\Debug\\mysql_dll.dll");

i= init_mysql_connection("localhost","root","123456","mysql");

lr_output_message("%d",i);

for(;;)

{

get_mysql_query_data("Qcache_hits",str_data);

i=get_mysql_table_query("show status like \'qcache%\'");

lr_output_message("%d",i);

x = atof(str_data);

lr_user_data_point("hits",x);

lr_think_time(5);

}

lr_output_message("%d",x);

close_mysql_connection();

return 0;

}