I tried the command you recommended and I am getting this error.
mysql> delete from history where device = 'FLOMA-FW-
P01.cleversafe.com';
ERROR 1206 (HY000): The total number of locks exceeds the lock table
size
mysql>
That's not good. Your database has gotten too big for your MySQL
configuration. To remedy this you will need to dump your database,
reconfigure MySQL, then restore the database. After doing all of this
you will be able to delete the events. The performance of Zenoss will
also likely improve.
# Dump database
mysqldump -uzenoss -pzenoss events > events.sql
# Drop database
mysql -uroot -e 'drop database events'
# Stop MySQL (as root)
service mysqld stop
# Reconfigure MySQL (as root)
cp /usr/share/mysql/my-huge.cnf /etc/my.cnf
Within this new /etc/my.cnf you will find a line that looks like this:
# Uncomment the following if you are using InnoDB tables
You need to uncomment the lines that it is referring to.
# Start MySQL (as root)
service mysqld start
# Recreate the events database
mysql -uroot -e 'create database events'
mysql -uroot -e "grant all privileges on events.* to [EMAIL PROTECTED]
identified by 'zenoss'"
# Load old data into events database
mysql -uzenoss -pzenoss events
mysql> \. events.sql
_______________________________________________
zenoss-users mailing list
[email protected]
http://lists.zenoss.org/mailman/listinfo/zenoss-users
