List:General Discussion« Previous MessageNext Message »
From:Paul Halliday Date:May 10 2005 9:57pm
Subject:Re: Solution to slow queries
View as plain text  
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."
Thread
Solution to slow queriesPaul Halliday10 May
  • Re: Solution to slow queriesFrank Bax10 May
    • Re: Solution to slow queriesJohn McCaskey10 May
  • Re: Solution to slow queriesJames Nobis10 May
  • Re: Solution to slow queriesmfatene10 May
  • Re: Solution to slow queriesRoger Baklund10 May
    • Re: Solution to slow queriesPaul Halliday10 May
      • Re: Solution to slow queriesRoger Baklund11 May
RE: Solution to slow queriesTheRefUmp10 May
  • Re: Solution to slow queriesEric Jensen10 May