MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Mark Maunder Date:November 7 2004 6:13am
Subject:massive fulltext indexes - what hardware?
View as plain text  
I'm busy building an application that will have 10 million records, each
with a chunk of text - about 500 words each, on average. Does anyone
have any benchmarks they can share with mysql's fulltext search
performance on indexes of this size?

What I'd like to know is what size server I need to run this app on. How
much RAM, how much CPU and what sort of disk channel performance I need
to provide?

I'd like to get sub 1 second responses, and all fulltext queries will be
boolean using the 'IN BOOLEAN MODE' modifier.

Thanks,

Mark.

Thread
massive fulltext indexes - what hardware?Mark Maunder7 Nov
  • Re: massive fulltext indexes - what hardware?Michael J. Pawlowsky7 Nov
    • Re: massive fulltext indexes - what hardware?Mark Maunder7 Nov