MySQL Forums
Forum List  »  Partitioning

Re: Does partitioning make sense for this application?
Posted by: Paul Schmehl
Date: October 28, 2012 08:58PM

>
> Look at these two _strings_:
> '10.21.21.0'
> '10.21.3.0'
> Which one will sort _first_? The first on, which
> has a "2" paired up with the "3" in the second
> one. That implies that
> WHERE srcip BETWEEN '10.21.21.0' AND '10.21.44.0'
> will _include_ '10.21.3.0', which is not what is
> meant by IP ranges.
>

I screwed that up. If you look at the actual queries I was searching 10.21.21.0 to 10.21.30.255.

>
> Question: Are the typical queries for "recent"
> timeranges? If so, we can discuss partitioning on
> stime; it will help _some_ queries. (Well, cannot
> use stime as it stands, but we can work on that.)
>

Yes, they are for recent timeframes - usually within the past 24 hours, although occasionally we get asked to look back in time a ways.


> How many rows will you be inserting per second?

1200 to 1500

> Do you have RAID striping?

No, but we're in the early planning stages, so it's certainly a possibility.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Does partitioning make sense for this application?
1173
October 28, 2012 08:58PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.