[Chicago-talk] search indexers

[James.Q.L]

--- Andrew Brosnan <andrew at broscom.com> wrote:
> On 1/20/06 at 4:29 PM, jt at plainblack.com (JT Smith) wrote:
> 
> > > I maintain some code that does this also. I found that as table
> > > size and load increase, complex queries can really hang. We're
> > > waiting for MySQL Cluster to support FULLTEXT before doing a
> > > rewrite. <shrug>
> > 
> > At what point do you see this, and on why kind of hardware? Are we
> > talking 100k rows, 1M, 1b? And what's the average size of your
> > records? Or perhaps this is more easily expressed as, what is the
> > size of your database table on the file system?
> 
> This is two dedicated load balanced db servers (master/slave
> replication) each with several GB of RAM. Average MyISAM table sizes
> range 1-2 million records (200-400MB). We've spent some time tuning
> MySQL and optimizing queries, but the FULLTEXT queries can still cause
> problems especially under heavier loads (500K+ per day).

slow because of too many writes? I know MyISAM handle concurrent writes poorly. but good read
handling.

Qiang


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com