?
What happens after you run ANALYZE TABLE? It doesn't appear that you've
done so since your index cardinality is NULL.
Matt
- Original Message -
From: Peter Rabbitson
Sent: Sunday, October 12, 2003 10:42 PM
Subject: Re: unexpected index behaviour...
G you guys are very helpful
% of all rows?
What happens after you run ANALYZE TABLE? It doesn't appear that you've
done so since your index cardinality is NULL.
Matt
- Original Message -
From: Peter Rabbitson
Sent: Sunday, October 12, 2003 10:42 PM
Subject: Re: unexpected index behaviour...
G you
G you guys are very helpful... Anyway posting a reply to my own question. There is
no way to use a timestamp as an
index in a relatively large table. MySQL just does not take it even with explicit
FORCE KEY. Why? - I have no idea.
A workaround I found for this is running a script every
Hello all,
I asked a similar question earlier. Then I went and did tons of tests... but I am back
where I started. Basicly I am trying
to store pretty high volume of data (ip traffic) in a mysql database. The only choidce
for an engine is MyIsam because I
need the advantage of compressed