Problem with ibdata1 is growing up how can shrink??

Archived community.zenoss.org | full text search

Skip navigation

Up to Discussions in zenoss-users

53365 Views 4 Replies Latest reply: Nov 24, 2009 3:14 AM by Gabe

rodyan

47 posts since
Apr 1, 2009

Currently Being Moderated

Aug 4, 2009 10:15 AM

Hello I'm using Zenoss Core v2.4.2 and manage 100 devices (cisco routers) and more or less between 20000 and 21000 OID's requests.

After this information I have a little problem with the MySql DB into the path "/usr/local/zenoss/mysql/data" with the file "ibdata1", actually the size it to big:

# du -sh *
96K events
4.2G ibdata1 ------> How to shrink DB?
5.1M ib_logfile0
5.1M ib_logfile1
776K mysql
796K mysqld.log
4.0K test
4.0K zncsrvr.pid
#

How I can decrease or shrink this database file???

I'll apreciate all your comments

Like (0)

guyverix
846 posts since
Jul 10, 2007

Currently Being Moderated

1. Nov 21, 2009 11:18 PM (in response to rodyan)
Re: Problem with ibdata1 is growing up how can shrink??

I am having the same trouble. I am at 17 gigs on my database. What can safely be done about getting this file under control?

Report Abuse

Like (0)
Andrea Consadori
863 posts since
Feb 11, 2008

Currently Being Moderated

2. Nov 22, 2009 1:56 AM (in response to rodyan)
Re: Problem with ibdata1 is growing up how can shrink??

take a look here if can be usefoul

My events database was growing a lot although I already had used the cleanupscripts of zenoss. Here is how to clean more.

docs/DOC-3220

Report Abuse

Like (0)
guyverix
846 posts since
Jul 10, 2007

Currently Being Moderated

3. Nov 22, 2009 5:48 AM (in response to Andrea Consadori)
Re: Problem with ibdata1 is growing up how can shrink??

Added it to my cron. Thanks! I had not seen that tweak before..

Report Abuse

Like (0)
Gabe
94 posts since
Jun 29, 2008

Currently Being Moderated

4. Nov 24, 2009 3:14 AM (in response to guyverix)
Re: Problem with ibdata1 is growing up how can shrink??

another thing could also be to set a max size on the my.cnf , usually in /usr/local/zenoss/mysql
i.e
innodb_data_file_path = ibdata1:10M:autoextend:max:512M

or if you more generous.

innodb_data_file_path=ibdata1:10M:autoextend:max:15G

as i understand it with this, the database will never grow bigger than your max setting and old data will be lost whe max size is reached.

plz correct me if im wrong, im no mysql guru.

BTW:
Zope also has a database. should be packed now and then.
http://XXXXXXXXXX:8080/Control_Panel/Database/main/manage_main

Report Abuse

Like (0)

Go to original post

Aug 4, 2009 10:15 AM

Problem with ibdata1 is growing up how can shrink??

Actions

More Like This