Thanks Alex :-0
If he followed the install documentation, he *should* already have this cron
entry :-)
On Jan 28, 2008 2:44 PM, Alex Howells <[EMAIL PROTECTED]> wrote:
> On 1/28/08, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> >
> > Sure, what is sql statement to use ;-)
> >
>
> Without wanting to be too rude to anyone, top-posting hurts my eyes
> and isn't conducive to "threads" a la mailing lists ;)
>
> To answer your question, flush the table 'search_cache' and it'll be
> rebuilt with "current" hostnames fairly quickly, assuming you have a
> cronjob set to fire fairly regularly. I guess the rebuild might take
> a while if you have 5bn rows in your merge table, but it's efficient
> enough if you just have <500m really!
>
> Sample cron entry:
> */5 * * * * php /var/www/php-syslog-ng/scripts/reloadcache.php
>
> If you really need to ask me how to flush that table, I'm going to
> respond with links to MySQL.com and strongly suggest buying Splunk or
> hiring someone with >1/2 ounce of SQL skills. :) Hint: You're looking
> for TRUNCATE.......
>
--
______________________________________________________________
Clayton Dukes
______________________________________________________________
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Php-syslog-ng-support mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/php-syslog-ng-support
