HP Intelligent Management Center v5.1 SP1 Application Manager Administrator Guide

195

 Lock Immediately—Indicate the number of the table lock which can be released immediately

in MySQL when APM did the last polling.

 Lock Wait—Indicate the number of the waiting locks when APM did the last polling.

 History Record—Click the History Record icon to view the table lock statistics related

index trend in a past time period, which includes the last 1 hour, last 6 hours, today, yesterday,

this week, this month, and this year. If you select the time period Last 1 hour, Last 6

hours, or Today, the lock statistics related index of the MySQL is measured in unit of a

polling interval; if you select the time period Yesterday, This week, or This month, the

lock statistics of the MySQL is measured in hours, and the diagram displays the lock statistics

related index trend, and the maximum, minimize, and average lock statistics of the MySQL; if

you select the time period This year, the lock statistics of the MySQL is measured in days,

and the diagram displays the lock statistics trend, and the maximum, minimize, and average

lock statistics of the MySQL. Move the pointer over the each sampling point to view the table

lock statistics of the MySQL for the time being.

SQL operation statistics/min

The SQL Operation Statistics/min information is shown as Figure 145.

Figure 145 SQL operation statistics/min-MySQL

• Fresh—Click the Fresh icon to update the detail.

• The curve graph displays the SQL operation statistics trend of the MySQL in the past one hour by

default. You can also select a time period to view the SQL operation statistics trend in the specified

time period. Click the Last 1 hour icon , the Last 6 hours icon , the Today icon , the

Yesterday icon , the This week icon , the This month icon , or the This year icon to

select a time period.

• SQL Operation Statistics/min chart—Indicate the times of SQL operations per minute. Green color

stands for delete operation; Orange color stands for insert operation; Blue color stands for select

operation, brown color stands for update operation.

 Put the mouse on the curve to view the specific data of all collection points.