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.......
-------------------------------------------------------------------------
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
