Hi,

You can cleanup all your database tables, but if your using a mysql innodb it wont shrink the size on disk!

http://forums.mysql.com/read.php?35,121880,121886

You can create a new database and import all the data, this way you will get rid of al the filled up empty space in your database!

Cheers,

Martijn

Summary

This article explains how to dump and restore the MySQL events  database used by Zenoss. The main reason you would need to perform this  proceedure is to recover disk space used by the Events database.

Zenoss leverages the Innodb storage engine because of several distintinct advanages over other storage types:

• transaction-safe storage engine for MySQL that has commit, rollback, and     crash-recovery capabilities
• row-level locking and Oracle-style consistent non-locking     reads (increases multi-user concurrency and performance)
• stores data in clustered indexes to     reduce I/O for common queries based on primary keys

The main disadvantage to Innodb is that it will use more disk space  than some of the other storage methods, and deleting data (specifically  historical events in terms of Zenoss) will not free up used disk space.  To recover space you must dump and reload the database.

Stopping Zenoss

Before proceeding with the dump of the database, you will need to  first stop Zenoss.You must perform these steps as the zenoss user.

1. zenoss stop
2. ps -ef |grep py

If you see any zenoss processes still running as a result of the ps command, kill the processes before proceeding.

Dumping the Database

Dump and drop the events database:

$ su - zenoss
$ mysqldump -uzenoss -pzenoss events > events.sql
$ mysql -u root
mysql> drop database events;
mysql> \q

Delete the Database and Create a New Database

Execute the following commands to delete the database and create a new, empty database.

$ sudo /etc/init.d/mysqld stop
$ sudo rm /var/lib/mysql/ibdata1 /var/lib/mysql/ib_logfile*
$ sudo /etc/init.d/mysqld start
$ mysql -u root
mysql> create database events;
mysql> grant super on *.* to 'zenoss'@'localhost' identified by 'zenoss';
mysql> flush privileges;
mysql> \q

Restore the Database

Execute the following commands to restore the data that was previously dumped. Note that we are expecting to be in the $ZENHOME/Products/ZenEvents/db directory.

$ mysql -uzenoss -pzenoss events
mysql> \. events.sql

mysql> exit 
$ mysql -uzenoss -pzenoss events < /opt/zenoss/Products/ZenEvents/db/zenprocs.sql

More Information

More information on the Innodb storage engine can be found in the MySQL documentation: http://dev.mysql.com/doc/refman/5.1/en/innodb.html

Ahh ok, then what you did is the right order :-) I had thought you said you wanted to just remove history and to reduce the size of the DB - I assumed you wanted to keep your events.

If you want to keep your events and shrink the DB, do what I posted. If you want to clear completly, do what remotesyslog did.