Cacti Graphs for Apache Not Working? Check Your IPv6
I was wondering earlier why my Apache Cacti graphs were all graphing 0s. Looking to test manually, I see it’s either 0s or -1s like below. [revin@forge ~]# /usr/bin/php -q /usr/share/cacti/scripts/ss_get_by_ssh.php –host xx.xx.xxx.xxx –type apache –items g1,g3 g1:-1 g3:-1 Looking at the Apache access log on the target server, I noticed Cacti was trying to …
in Apache
Apache Running on Multiple Ports and Percona Cacti Templates for Apache
For some users, running Apache on different ports is more economical than adding multiple IPs to the same server i.e. when you have several Apache servers behind a load balancer where the public IP is in front of the load balancer. If you’re thinking of using the Percona Monitoring Templates for Cacti particularly for Apache, …
in MySQL
Optimizing OR’ed WHERE Clauses Between JOIN’ed Tables
OR conditions are normally difficult to optimize when used on different columns, a pain when the columns are of range conditions and worst when done between 2 or more different tables. Look at my example below, the original query is trying to find rows which conditions are based on columns from the JOIN’ed tables. mysql …