First of all thanks all for your answers.
Second I'll explain what I manage to do in regard with this issue,
maybe someone else may need it in the future.
So, first I have started by changing the way I have stored the `ip`
field from varchar(15) to int unsigned and populated this field with
the 4
Hi all!
(Sorry for the late reply.)
Puiu Hrenciuc wrote (re-ordered):
"Barry" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
Puiu Hrenciuc wrote:
Hi,
I have a table ( MyISAM, MySQL 5.0.20, FreeBSD ) containing network
traffic data :
record_time datetime - time when recording
2006/4/13, Puiu Hrenciuc <[EMAIL PROTECTED]>:
> Hi,
>
> I have a table ( MyISAM, MySQL 5.0.20, FreeBSD ) containing network traffic
> data :
>
> record_time datetime - time when recording was added
> ip char(15) - ip that generated the traffic
> type tinyint(3) - traffic type ( 1 - local, 2 - inte
Hmmm, I have omited that :
I also have an index on (ip,type) in that order
"Barry" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Puiu Hrenciuc wrote:
>> Hi,
>>
>> I have a table ( MyISAM, MySQL 5.0.20, FreeBSD ) containing network
>> traffic data :
>>
>> record_time datetime -
Puiu Hrenciuc wrote:
Hi,
I have a table ( MyISAM, MySQL 5.0.20, FreeBSD ) containing network traffic
data :
record_time datetime - time when recording was added
ip char(15) - ip that generated the traffic
type tinyint(3) - traffic type ( 1 - local, 2 - internet )
inbound int(10) - in bytes
o
Hi,
I have a table ( MyISAM, MySQL 5.0.20, FreeBSD ) containing network traffic
data :
record_time datetime - time when recording was added
ip char(15) - ip that generated the traffic
type tinyint(3) - traffic type ( 1 - local, 2 - internet )
inbound int(10) - in bytes
outbound int(10) - out by