Skip navigation links

MySQL Forums :: Newbie :: Dramatic performance drop when table > 100MB


Advanced Search

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

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

PS: I have asked that question before and received no answer

Options: ReplyQuote


Subject Written By Posted
Dramatic performance drop when table > 100MB Patrick Questembert 11/01/2004 09:39PM
Re: Dramatic performance drop when table > 100MB Rikard Froberg 11/02/2004 01:12AM
Re: Dramatic performance drop when table > 100MB Patrick Questembert 11/02/2004 06:42AM
Re: Dramatic performance drop when table > 100MB Patrick Questembert 11/02/2004 04:10PM


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.