Dramatic performance drop when table > 100MB
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
Subject
Views
Written By
Posted
Dramatic performance drop when table > 100MB
3893
November 01, 2004 09:48PM
2679
November 02, 2004 06:46AM
2519
November 02, 2004 10:38AM
2977
November 02, 2004 04:14PM
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.