On 5/10/05, Roger Baklund <[EMAIL PROTECTED]> 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/[EMAIL PROTECTED] > > -- _________________ Paul Halliday http://dp.penix.org "Diplomacy is the art of saying "Nice doggie!" till you can find a rock." -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
