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]