MySQL Forums
Forum List  »  Performance

Dramatic performance drop when table > 100MB
Posted by: Patrick Questembert
Date: November 01, 2004 09:48PM

Please help an ex-Microsoft person stay with MySQL :-) - see below

"Simple" table:
time | datetime
n1 | smallint(5) unsigned
n2 | smallint(5) unsigned
n3 | smallint(5) unsigned
msgid | int(10) unsigned
msgtext | blob
url | varchar(255)

(tables seem to all be of Innodb type)

No problem at all - as long as the table size stays below 100MB. As soon as the size reaches that threshold, performance slows to less than 1/10th of normal! At that speed, it is just not feasible.

I doubt that the 100MB number is a coincidence.

This is with MySQL 4.1 on XP. Anybody has a clue what's going on?

Patrick

Options: ReplyQuote


Subject
Views
Written By
Posted
Dramatic performance drop when table > 100MB
3582
November 01, 2004 09:48PM


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.