Monitoring mySQL Databases
Monitoring aMySQLdatabase requires the use of a JDBC driver. To enable SiteScope to monitor a MySQL database:
- Download the JDBC driver fromhttp://www.mysql.com/downloads/api-jdbc.html
- 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 install path>/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://<database hostname>[:<tcp port>]/<database>
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;
}