[Perfparse-users] DB mantainance

[Daniele C. <dan...@ti...>]

Hi folks,
I'm using perfparse 0.105.6 with nagios to monitor a large network 
environment; so my Db has grown up to 9 GB. I scheduled every week to 
call the program perfparse-db-purge in order to keep only last three 
month, but last time it ended with the error:

An error occurred with the SQL:

   "DELETE perfdata_service_raw FROM perfdata_service_raw,perfdata_host 
WHERE perfdata_service_raw.host_name = perfdata_host.host_name AND 
perfdata_host.is_deleted = 1"

Failure Message:

   "The total number of locks exceeds the lock table size"

I'm running MySQL 4.1.10 (ver. 14.7) on FreeBSD 5.3, but I'm not very 
familiar with MySQL.

Can someone help me?

Thanks.

Daniele Coli`