LoadRunner monitors MySQL performance using sitescope (add MySQL counters)

1. Download sitescope (you can reply to the message, leave a mailbox, and send it directly to your mailbox)

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 install the Java Runtime Environment jre6 and then run normally. You can also directly install JDK

3. Download the MySQL driver for Java (JDBC driver, later than version 5)

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 the group "MySQL" and choose "New Monitor". On the "new monitor" Page, select "database counters ",:

 

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.

 

Monitoring MySQL ends now.