LR monitoring MySQL

Sapphire's personal space describes how LoadRunner monitors the CPU usage of MySQL and appache processes
Here's how:
The company's new products need to monitor the MySQL and Appache process, the master to help finally succeed.


Server-side readiness:


1, log on the server, verify that the SNMP service can monitor the MySQL and HTTP process information:


Snmpwalk-os-c public-v 1 172.16.100.28|grep mysql


Snmpwalk-os-c public-v 1 172.16.100.28|grep http


You can have data.


If there is no data, then you need to manually configure the file. Go to step 2


2.

[Email protected] root]# cd/etc/snmp/

[Email protected] snmp]# VI snmpd.conf


Expand Visibility: Change the data behind the view SystemView included * * * * to a larger range


3. Run the following command


[[email protected] snmp]#/etc/init.d/portmap start


[[email protected] snmp]#/ETC/INIT.D/SNMPD start


4. Verify again


Verify that the SNMP service can monitor MySQL and HTTP process information:


Snmpwalk-os-c public-v 1 172.16.100.28|grep mysql


Snmpwalk-os-c public-v 1 172.16.100.28|grep http



Adding monitoring parameters to the Lunnerrunner


1, control the scene-run-add SNMP to the Monitoring window


2, in the SNMP to the Monitoring window right click, add the server and MySQL, Appache PID


Add the path to the PID: mgmt--mib-2--host-hrswrunperf--runperftable--hrswrunperfenter--HRSWRUNPERFCPU (if you want to monitor the memory then it should be * * * Mem) to find the required PID
But "Add monitoring parameters in Lunnerrunner" This "SNMP to monitoring window" I did not find the second step in the run, I do not understand how to operate, I hope that the monitoring of MySQL predecessors can explain to me in detail to listen to


1, control the scene-run-add SNMP to the Monitoring window


2, in the SNMP to the Monitoring window right click, add the server and MySQL, Appache PID


Add the path to the PID: mgmt--mib-2--host-hrswrunperf--runperftable--hrswrunperfenter--HRSWRUNPERFCPU (if you want to monitor the memory then it should be * * * Mem) to find the required PID

LR monitoring MySQL