LoadRunner monitoring MySQL performance via SiteScope

How to use Sitescope11 Monitoring MySQL database, and in LoadRunner view in chart form MySQL Monitoring Results

1. Download Sitescope11

2. Installing SITESCOPE11

Can be installed all the way by default, the license file selection can be empty first, empty representative trial, with a period of 60 days. After the installation is complete,

Will pop up a page, click on the Http://localhost:8080/SiteScope on the page. It will enter the SiteScope interface. When entering the interface, the display

As shown in the Red fork, you need to install the Java Runtime Environment Jre6, then run normally, or you can install the JDK directly.

3. Download the Java version of the MySQL driver (the JDBC driver, preferably the 5 version above)

Unzip after download, copy the extracted Mysql-connector-java-5.1.14-bin.jar file

C:\SiteScope\java\lib\ext directory, whichever is your installation directory

4. Add MySQL counter

Go to the "monitor" screen, select "SiteScope" right click, select New Group, enter the group information, such as the group name for monitoring MySQL.

Right-click the group "MySQL", select new "Monitor" and select "Database Counter" in the New Monitor interface:

Database connection: Enter JDBC:MYSQL://MYSQL server IP: Port number/database name (port default is 3306 can not write out)

Query: Show status (indicates that all parameters are displayed and then selected) or show status where variable_name like ' parameters ' (indicating direct selection of parameters to be monitored)

Database driver: Org.gjt.mm.mysql.Driver

User name and password for the database: root password

After filling out the above information, click "Get Counter", tick the counter to monitor the counter, click "OK", add counter end.

5. Add the MySQL counter to the controller in LoadRunner

First select a script to execute, after the designer, go to the Run interface, select the SiteScope Resource Graph in the location, right click on the right image to add a measure.

Add measurements is adding the measurement method, click on the first "add" to add SiteScope service system IP (because SiteScope and LoadRunner are installed on the same machine, so directly fill in localhost), then click the Second " Add, select the resource to be monitored on this service.

The following is a description of MySQL common counters

See:

Using LoadRunner to monitor MySQL database performance
Http://hi.baidu.com/yanfei666666/blog/item/62c87200b201fe027bec2c09.html
Where to watch MySQL with SiteScope
Http://hi.baidu.com/%C7%D0%D3%EA/blog/item/f6b431486953a42908f7efff.html

Using LoadRunner to monitor MySQL database performance
http://testingtop.com/space.php?uid=13&do=blog&id=214

LoadRunner How to monitor the MySQL method
http://www.51testing.com/?uid-72-action-viewspace-itemid-89977

How to use LoadRunner to monitor the performance of MySQL database
http://www.51testing.com/?uid-168974-action-viewspace-itemid-94034

LR9.0 can you monitor MySQL?
http://bbs.51testing.com/viewthread.php?tid=102782

LR monitors mysql under Linux with SNMP
http://www.51testing.com/?uid-130600-action-viewspace-itemid-102036

Custom Monitors for LoadRunner
http://www.51testing.com/?uid-49159-action-viewspace-itemid-1093

In addition MySQL open 3306 port technology can see this article:

Solve the problem that MySQL cannot connect to the database remotely under Ubuntu
Http://blog.csdn.net/gumanren/archive/2010/12/22/6092779.aspx

In particular, this sentence:

View/ETC/MYSQL/MY.CNF found bind-address only to find the configuration is 127.0.0.1 (bind-address=127.0.0.1), directly to bind-address=192.168.0.xxx (native IP) , and then look at Port 3306 turned on,

Deleting bind-address will indicate that it is open to all IPs.

LoadRunner monitoring MySQL performance via SiteScope