[Perfparse-users] RE: DB mantainance

[Philip V. <ph...@we...>]

I also had this problem, try using the --no_transactions option:

$ perfparse-db-purge -r --no_transactions


Philip


-----Original Message-----
From: per...@li...
[mailto:per...@li...] On Behalf Of
Daniele Coli`
Sent: Monday, 8 August 2005 9:50 PM
To: per...@li...
Subject: [Perfparse-users] DB mantainance

Hi folks,
I'm using perfparse 0.105.6 with nagios to monitor a large network=20
environment; so my Db has grown up to 9 GB. I scheduled every week to=20
call the program perfparse-db-purge in order to keep only last three=20
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=20
WHERE perfdata_service_raw.host_name =3D perfdata_host.host_name AND=20
perfdata_host.is_deleted =3D 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=20
familiar with MySQL.

Can someone help me?

Thanks.

Daniele Coli`


-------------------------------------------------------
SF.Net email is Sponsored by the Better Software Conference & EXPO
September 19-22, 2005 * San Francisco, CA * Development Lifecycle
Practices
Agile & Plan-Driven Development * Managing Projects & Teams * Testing &
QA
Security * Process Improvement & Measurement *
http://www.sqe.com/bsce5sf
_______________________________________________
Perfparse-users mailing list
Per...@li...
https://lists.sourceforge.net/lists/listinfo/perfparse-users