When users accessing your web site 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.