Logging - Required server performance, new values per second

[bbrendon]

Required server performance, new values per second
system.run[script]

<?php
        chdir('/usr/local/share/zabbix');

        require_once "include/config.inc.php";


        $status=get_status();

        echo $status['qps_total'] . "\n";
?>

[nelsonab]

You can also run the following MySQL command

select count(*)/avg(delay) from items as i, hosts as h where i.hostid=h.hostid and h.status=0 and i.status=0 and h.available=1;

[nelsonab]

Added a link in the wiki:

http://www.zabbix.com/wiki/doku.php?id=howto:misc

[lauerdk]

Solution to mysql4.1+(supports subqueries)

This works in mysql 4.1+

SELECT sum(qps) AS qps 
  FROM (
    SELECT count(*),count(*)/i.delay as qps
      FROM items i,hosts h 
        WHERE i.status=0
          AND i.hostid=h.hostid 
          AND h.status=0
        GROUP BY i.type,i.delay
        ORDER BY i.type, i.delay
  ) as data;

[dawabz94]

This works in mysql 4.1+

SELECT sum(qps) AS qps 
  FROM (
    SELECT count(*),count(*)/i.delay as qps
      FROM items i,hosts h 
        WHERE i.status=0
          AND i.hostid=h.hostid 
          AND h.status=0
        GROUP BY i.type,i.delay
        ORDER BY i.type, i.delay
  ) as data;

Works perfectly on zabbix 1.8.4 / MySQL 5.0.51, thanks a lot !