[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql
Subject:    Re: fulltext search optimization
From:       John Hicks <johnlist () gulfbridge ! net>
Date:       2006-07-12 16:05:56
Message-ID: 44B51DE4.6050805 () gulfbridge ! net
[Download RAW message or body]

Svilen Spasov (Ancient Media) wrote:
> Hello,
> 
> I have a website with a MySQL database and I have a table with ~2 
> millions row (usernames, filenames; ~120MB db data file and ~230MB db 
> index file) with I would like to search using the fulltext indeces.
> 
> Unfortunately the server get loaded pretty much. It always stays on 20 
> load average and often gets 50-60 load average.
> 
> I'm sure that this is because of slow mysql response (slow queries) to 
> the apache web server.
> 
> Can you give me some advice how to optimize the mysql server?
> The server hardware is: 1GB RAM, 1.8GHz Celeron, 40GB HDD (currently I 
> have 512MB free memory)

Run a "SHOW CREATE TABLE <tablename>" on the table and post the results 
  here. (We're particularly interested in how it is indexed.)

Tell us what queries are being run against the table. If possible post 
the actual SQL queries.

-J


> Thanks,
> 
> Svilen Spasov
> 
> --MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    
> http://lists.mysql.com/mysql?unsub=johnlist@gulfbridge.net
> 


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=mysql@progressive-comp.com

[prev in list] [next in list] [prev in thread] [next in thread]