MySQL fulltext search benchmark

Anyone has a benchmark on MySQL's fulltext indexing and search?

My plan is to index 4M of "contact info" records, each with different fields (name, address, phone #...etc), where name and address field has to be fulltext indexed. However, I need to have some idea about the performance.

Thx.
LVL 1
aboywongAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

SqueebeeCommented:
I can't actually point to an independant benchmark, I can report that large sites are using it, and those sites have big speed concerns. Of course, the best thing to do it test it yourself to ensure that the benchmark is relevant.
0
aboywongAuthor Commented:
can you name which site is using mySQL's fulltext search? and how many records they are running...?
0
SqueebeeCommented:
Yahoo. As for records I am not sure.

Source: http://jeremy.zawodny.com/blog/archives/000576.html

Quote: There's anywhere from a few hundred thousand to 5 million of them.
0
aboywongAuthor Commented:
Squeebee,

  Thx a lot. That link really provide some useful info. However, I think I still need to run my own benchmark....
By the way, I got MySQL 4.1.0 installed (via rpm), and I tried to use utf8 as the default character set and met the following error when login:

mysql: File '/usr/share/mysql/charsets/?.conf' not found (Errcode: 2)
mysql: Character set '#33' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index' file

Any hints about it? Does it mean utf8 is not supported (but it should, as in the documentation...)

0
SqueebeeCommented:
I would reccomend going to 4.1.1 for utf8 support, as it is one of the newest features. And yes, I reccomend running your own benchmark.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
MySQL Server

From novice to tech pro — start learning today.