Re: [Perfparse-users] Tables cleanup

[Florian G. <fl...@bi...>]

Hi,

the --no_transactions switch was made for people that have no innodb 
table type. You can try. If you disable inserts, transactions are not 
needed. If you did not cleanup your tables for a long time (or never) i 
would set the deletion policies only for one host, run a purge, add 
another host, run purge ...
If you cannot clean a host at once try to make your delete policy longer 
(100 days or more) first. I had these problems first too, but since i 
clean every hour, problems are gone.

Flo

Ciro Iriarte schrieb:
> 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
> 
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> Perfparse-users mailing list
> Per...@li...
> https://lists.sourceforge.net/lists/listinfo/perfparse-users
>