LoadRunner monitoring MySQL performance via SiteScope

Source: Internet
Author: User
Tags 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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.