On 5/10/05, Roger Baklund <roger@stripped> wrote:
> Paul Halliday wrote:
> > srcaddr VARCHAR(15),
> > dstaddr VARCHAR(15),
>
> Are these ip-adresses? If they are, consider using UNSIGNED INT columns
> and the INET_NTOA() and INET_ATON() funtions. It will save you a lot of
> space, thus increase the amount of data your hw can handle.
They are indeed ip addresses. This infomation is gathered and input
into the db via a program called flow-export (export netflows). I
intially had the column as UNSIGNED INT but it would only pick up the
first octet, so I switched to VARCHAR.
>
> > I have read up a bit on merge tables (this is probably the answer) but
> > I am unsure as to how you trigger the changes. ie, how do you do the
> > rollover after every 24hours?
>
> You would have to program this yourself, there are no mechanisms for
> this in MySQL. It's pretty straight forward, though. Just use a shell
> script and cron or the equivalent if you are on a non-unix platform.
>
> --
> Roger
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1
>
>
--
_________________
Paul Halliday
http://dp.penix.org
"Diplomacy is the art of saying "Nice doggie!" till you can find a rock."
