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 compressed
question:
what is the best strategy for grouping / using a merge table ?
a) have one separate table for continous syslog data
and synchronise this table regularily to e.g. a monthly table log_2004_06
("log_2004_06" is Part of a merge table "log_global" to enable global access
to all monthly logs with php-syslog-ng)
syslog-ng -> log
log --(INSERT INTO) -> log_2004_06
log_global ( log_2004_12,log2004_11,log_2004_10,...)
b) let the "insert table" for syslog-ng already be part of the merge table
and reordering the merge table on a regularly schema, to be
able to compress all old,static tables.
log ( log_2004_12,log2004_11,log_2004_10,...)
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
anyone has done something like this already ?
TIA
Micha
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]