Re: Improve MYSQL performance on large database

2008-11-09 Thread Salah Nait-Mouloud
Hello,

Here, you can get some help:
http://www.mysqlperformanceblog.com/2006/09/29/what-to-tune-in-mysql-server-after-installation/

Regards.

Salah NAIT-MOULOUD
www.echovox.com  |  www.m-boost.com


On Sat, Nov 8, 2008 at 7:08 AM, Guillermo Nardoni
[EMAIL PROTECTED]wrote:

 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.




 --
 MySQL General Mailing List
 For list archives: http://lists.mysql.com/mysql
 To unsubscribe:
 http://lists.mysql.com/[EMAIL PROTECTED]




Improve MYSQL performance on large database

2008-11-08 Thread Guillermo Nardoni
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.




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]