When users accessing your web site/web services report a problem, you need to identify the source of the problem: it could be in the network, or it could lie with a database or the web server. To monitor all the key elements that drive your entire web application/web services infrastructure, you need to have specific monitors to collect data from your web servers or databases.
Server/Database Performance Monitoring
Monitors critical web server parameters
such as, CPU and memory usage of your web servers.
Monitors database parameters for MySQL and Oracle databases. Parameters collected for MySQL
include:
Thread Details - Threads connected, created, running, cached,
etc.
Connection Details - Max_used_connections, Aborted clients,
Aborted connections, etc.
Temporary Table Details - Created_tmp_disk_tables and Created_tmp_tables.
Throughput Details - Bytes_received and Bytes_sent.
Query Details - Total Number of reads, Total Number of
writes, Slow_queries, etc,
Table Related Statistics - Table_locks_waited, Open_tables,
etc.
This provides
better visibility into the performance of your web servers and databases
that form the core components of your web applications/web services.
