Re: [Perfparse-users] Tables cleanup

[Ciro I. <cy...@gm...>]

2007/1/21, Florian Gleixner <fl...@bi...>:
> Hi,
>
> The PHP interface will have full functionality in the next version of
> Perfparse. At 106.1 this part simply was not finished.
> With the cgi interface the menu "View / Edit Hosts Deletion Policy"
> works for me.
>
> Try to set one policy there and rerun the purge to see if it works.
>
> Flo
Ok, that works, i had to disable the inserts made by nagios because i
was getting many timeouts from runnig perfparse-log2mysql.

After 3 hours of execution i get:

+-----------------------------------------------------------------------------+
| There are no Plugins, Unique Key or Metrics marked for deletion today.      |
+---------------------------------------------------+--------------+----------+
|  Raw Data Delete Policy                                                     |
+---------------------------------------------------+--------------+----------+
| Unique Key                                        | Policy       | Deleted  |
+---------------------------------------------------+--------------+----------+
| as400, CPU                                        | To   30 days |   177425 |
| as400, PING                                       | To   30 days |    36000 |
| as400, RAM                                        | To   30 days |   173613 |
| as400, Storage                                    | To   30 days |
An error occured with the SQL:

  "DELETE FROM perfdata_service_raw WHERE host_name = 'as400' AND
service_description = 'Storage' AND ctime < NOW() - INTERVAL 30 DAY"

Failure Message:

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

Can the --no_transactions flag help with this?, in which case do i
need to use it?, did anybody seen this error?

Ciro