merge tables for big log files ?

2004-05-31 Thread Michael Arndt
Hello *, goal: using merge tables for annual / monthly storage of syslog information using php-syslog-ng and syslog-ng problem: -one actual table must be available for inserts -the merge table needs to be the target for reports and queries -static parts of the merge table should be

Re: merge tables for big log files ?

2004-05-31 Thread Chris Elsworth
On Mon, May 31, 2004 at 02:03:09PM +0200, Michael Arndt wrote: Problem for this variant: merge table has to be dropped and recreated periodically. during the short lag interval the log merge table does not exist

Re: merge tables for big log files ?

2004-05-31 Thread Jeremy Cole
Hi Michael, Problem for this variant: merge table has to be dropped and recreated periodically. during the short lag interval the log merge table does not exist You don't have to drop and re-create the table. Please