Page 967 - Cloud computing: From paradigm to operation

Monitoring 6

See Table 7-13.

Table 7-13 – Parameters collected for monitoring database efficiency

Metric name Description Unit

space Total space of DB kB
space used Total space used of DB kB
Total number of DB queries (select, insert, update,
queries query
delete, replace)
replace request Volume of replace requests request

replace request rate Average rate of replace requests per second request/s
response time of replace request Average time of responding replace request ms
insert/set request Volume of insert/set requests request
insert/set request rate Average rate insert/set request of per second request/s
response time of insert/set request Average time of responding insert/set request ms
update request Volume of update requests request
update request rate Average rate of update requests per second request/s
response time of update request Average time of responding update request ms
delete request Volume of delete requests request
delete request rate Average rate of delete requests per second request/s

response time of delete request Average time of responding delete request ms
select/get request Volume of select requests request
select/get request rate Average rate of select requests per second request/s
response time of select/get request Average time of responding select/get request ms
connect Connection number of concurrent clients request
connect rate Average rate of connections per second request/s
slow/expired query Volume of slow/expired queries query
slow/expired query rate Average rate of slow/expired queries per second request/s

7.2.3.4 Web service performance
The main function of the web server is to provide an online information browsing service. There are three
types of performance parameter for web service: throughput, concurrent transactions and response time.

959