Loadrunner monitors and monitors mysql databases using sitescope

1. Download sitescope2. you can install sitescope by default. The license number can be blank first. If it is blank, it indicates trial use. You can enter it after installation. After the installation is complete, a page is displayed. Click localhost: 8080SiteScope on the page to enter the sitescope interface. Red Cross is displayed on the page.

1. Download and install sitescope 2. You can install it by default. The license number can be blank first. If it is blank, it indicates trial use. You can enter it after installation. After the installation is complete, a page is displayed. Click http: // localhost: 8080/SiteScope. On the page to enter the sitescope interface. The Red Cross is displayed on the interface.

1. Download sitescope

2. Install sitescope

It can be installed by default. The license number can be blank first. If it is blank, it indicates a trial. If it is available, you can enter the license number after installation. After installation

A page is displayed. Click http: // localhost: 8080/SiteScope. On the page to enter the sitescope interface. When you enter the interface

It indicates a Red Cross, you need to installJavaRun the jre6 environment and run normally. You can also install jdk directly.

3. Download the mysql driver for java (JDBC driver, preferably version 5 or later)

Download and decompress to copy the extracted mysql-connector-java-5.1.14-bin.jar File

C: \ SiteScope \ java \ lib \ ext directory, subject to your installation directory

4. Enter the sitescope interface, crack the advanced nature, and enter the license

In preferences-> General settings, enter the license number: PM90815892099998-99101472, which is displayed after successful input, indicating successful cracking and permanent license availability.

5. Add mysql counters

On the "Monitor" page, right-click "sitescope", select "New Group", and enter the group information. For example, the group name is mysql.

Right-click "mysql" in the group, select "new monitor", and select"DatabaseCounter ",:

Database Connection: Enter jdbc: mysql: // mysql Server IP: Port Number/Database Name (the default port is 3306, which can be left blank)

Query: show status (display all parameters and select) or show status where variable_name like 'parameter '(select the parameter to be monitored)

Database Driver: org. gjt. mm. mysql. Driver

Database username and password: root Password

After entering the preceding information, click "Get counter", select the counter to be monitored in the displayed counter, and click "OK" to add the counter.

6. Add a mysql counter to the loadrunner controller.

Select a script to be executed, and then enter the run interface. Right-click the resource map of the sitescope, and right-click it to add a measurement.

Add a measurement method, click add to add the Monitoring Service IP address and server system, and then click add to select the resources to be monitored for this service.

The monitoring of mysql is over, and the next step is to analyze the monitoring data, which requires some understanding of mysql.