LoadRunner monitoring MySQL via SiteScope

1. LoadRunner monitors mysql1.1 through SiteScope. SiteScope download

The first time in the online download is sitescope11.30, after installation can not be cracked, so finally uninstalled, re-downloaded the sitescope9.50 installation package;

Sitescope9.5 Installing and cracking files,

Https://yunpan.cn/cPgTXnWApw4eT Access Password cc2c

Https://yunpan.cn/cPgT92LRPqM2U Access Password 6D20

1.2. SiteScope install 1.2.1. Installation Environment Description

The machine that installs the LoadRunner is Win64 bit, and SiteScope is installed on this machine (it is indicated on the Internet that LR and SiteScope must be installed on the same machine, there is no verification here)

1.2.2. Installation process

can refer to

Http://www.cnblogs.com/leon_2007/archive/2010/02/22/1671113.html

After the installation is complete, enter the following information in the browser:

Http://localhost:8080/SiteScope/servlet/Main,localhost can be changed according to the server IP address, such as the display interface:

Here is a description, the first time the installation, Installed is the version of the 11.30, each time Open SiteScope site always show forks, and later found because of the JDK version of the problem, the installation of Jre8 can normally open SiteScope site, and later, reinstall sitescope9.5, and I installed the jdk1.6 and JD k1.7 So after the installation is complete, it will open normally (there is a document on the Web: The JDK must be above 1.5 for sitescope9.5 installation).

1.2.3. Copy MySQL driver and restart

Copy the file Mysql-connector-java-5.1.17-bin.jar in the installation package to the directory under [installation directory \java\lib\ext\]

As I am, this machine is D:\SiteScope\java\lib\ext\.

1.2.4. How to restart the SiteScope service

Click Start, search services.msc to open the service, find HP SiteScope, click Restart Service.

1.3. Configure MySQL Monitoring

Click Health on the SiteScope website to open the module;

Click the Health Right button to create a new monitor in the open page, select the database counter to enter the database counter configuration interface,

In the Database Configuration page fill out the contents of the Red box, click Get Counter

1.3.1. Configuration options:

Database connection URL:JDBC:MYSQL://IP: Port number/database name;

Example: jdbc:mysql://192.168.10.1:3306/test; (description port default is 3306)

Enquiry: Show status;

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

4. Click "Get Counter", "OK" to save, so far, SiteScope has been able to monitor the data information;

Appendix:

MySQL Common counters

Counter	Counter Analysis
threads_connected	Indicates how many customers are currently connected to the MySQL server, the number of connections is too many, the network is a problem, it is dynamic, when the maximum number of connections, the database system can not provide more connections, at this time, the program also wants to create a new connection thread, the database system will be rejected, If the program does not do too much error handling, there will be an error message
Threads_running	If the database is overloaded, you will get a value that is growing (the query's statement continues). This value can also be less than the pre-set value. This value is not a problem in a short period of time to exceed the limit value. If you exceed the preset and do not fall back within 5 seconds, monitor some other values at the same time
Aborted_clients	The value of the client being abnormally interrupted is not affected for some applications, but may be traced to other applications because an abnormally interrupted connection may indicate a problem with some applications
Questions	The number of queries that can be obtained per second, or the number of all queries.
Opened_tables	Indicates that the table cache does not have a hit quantity. If the value is large, you need to increase the number of Table_cache
Select_full_join	There is no execution of the primary key (key) union (join). The value may be zero. This is a good way to catch development errors because such queries can degrade the performance of the system
Select_scan	The number of full-table search queries performed. If you find that the value continues to grow, it means optimization, lack of necessary indexes, or other issues
Slow_queries	The number of queries that exceed this value (--long-query-time), or the number of indexed queries is not used. There is a small conflict for all queries. If the value grows, it indicates that the system has a performance problem
threads_created	This value is generally low. A higher value means that you need to increase the number of Thread_cache, or you are experiencing a persistent increase in connectivity, indicating a potential problem

Settings for SiteScope in system resource graphs in Loadrunner-controller

In Loadrunner-controller, open sitescope in system resource graphs, then add host and data to be monitored,

Note here: The address of the MySQL database configured in SiteScope is the address of the server, such as 192.168.10.1, and the IP address of the add SiteScope in LR is not the address of the server and the IP of the SiteScope machine is installed. (description, because my LR and the server is not a machine, so here the address is not the same), has been because of this IP address problem, LR has been no monitoring data, and later on the forum to see [ on the window LR and SS, that's when you monitor, you should find SSin LR, and then add window 's IP address, not Linux IP]

Http://bbs.51testing.com/thread-337579-1-1.html

So modify the IP address, then you can access the normal!!!

, this is my native monitor interface.

It's done here, then it's analyzed, and you're learning ...

LoadRunner monitoring MySQL via SiteScope