List:General Discussion« Previous MessageNext Message »
From:Guillermo Nardoni Date:November 8 2008 6:08am
Subject:Improve MYSQL performance on large database
View as plain text  
Hello everyone, good evening. This is my first time posting here and it is 
just for asking...!!!

Well, we are building a project for our customer wich is basically a 
searcher, google style.
We use mnoGoSearch as indexer, 3.2.27-mysql, to more specific.!.
We already try lots of version even compiling from source to discard indexer 
as a problem.

The database, wich is about 20 gb and increasing!!!, is distributed among 5 
server, 4 of 5  has SATA disks, 2 gb RAM, the 5th, is 512 mb ram and 80 gb 
SCSI 3 disk with adaptec 2940U as host scsi adapter.

Well, after lots of testing, if you enter on the site, aka: 
www.lomejordetodo.com.ar, and type a text to search to. it takes about 5 
minutues if
query has lots of result, like "linux kernel" query.

We read lots of posting, messages and googling but we couldn't solve the 
problem at all!.

If anyone here has o had the same problem I'l give lots of "thanks" if you 
could show me the path to
investigate.

Regards
Guillermo Nardoni
Rosario - Argentina.



Thread
Improve MYSQL performance on large databaseGuillermo Nardoni9 Nov
  • Re: Improve MYSQL performance on large databaseSalah Nait-Mouloud9 Nov