www.cs.rug.nl Open in urlscan Pro
129.125.2.210  Public Scan

Form analysis
0 forms found in the DOM

Text Content

Cleaning up the Zabbix database Part I.  Miscellaneous subjects (and those still
to be sorted)  

--------------------------------------------------------------------------------


CLEANING UP THE ZABBIX DATABASE


JURJEN BOKMA

May 2010

--------------------------------------------------------------------------------

We've got Zabbix monitoring our machines, but some even more important databases
on the same DBMS, and Zabbix is using 16GB and hogging the disk under /var.
Cleanup time.

 1. Determine the size of the database
    
    
    
    zabbix=# SELECT pg_size_pretty(pg_database_size('zabbix')) As fulldbsize;
    fulldbsize
    ------------
    16765 MB
    (1 row)
    
    

 2. Determine the size of history
    
    (According to this thread on the Zabbix forum, history is a good acandidate
    to save some space:
    
    zabbix=# SELECT pg_size_pretty(pg_total_relation_size('history')) As fulltblsize, pg_size_pretty(pg_relation_size('history')) As justthetblsize;
    fulltblsize | justthetblsize
    -------------+----------------
    6123 GB  | 12298 GB
    (1 row)
    
    (The numbers seem to be the wrong way around, but they're large anyway, so I
    can save space removing them.)

 3. Cull the table
    
    
    
    zabbix=# truncate table history;
    
    

 4. Reclaim the space won
    
    
    
    zabbix=# vacuum analyze;
      VACUUM              
    
    



--------------------------------------------------------------------------------

   Creating the repositories   Multiple rotated monitors on NVidia under X