Ad Widget

Collapse

Large database = bad settings?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • neurovish
    Junior Member
    • Mar 2007
    • 14

    #1

    Large database = bad settings?

    I've been testing out Zabbix for a couple weeks now, and noticed that my database is growing at a rather quick pace. I'm monitoring less than 10 hosts, and my database has already reached 17G after a few weeks. Do I have something misconfigured?

    ....yes I do, and it wasn't my database that grew to that size. I'm using gentoo, which does not rotate the innodb bin logs by default and that's what filled up my var partition. After adding expire_logs_days = 2 to my.cnf and restarting mysql, these files were cleared out.
    Last edited by neurovish; 29-03-2007, 16:54. Reason: duh
Working...