RE: optimize my.cnf

2009-09-03 Thread Jerry Schwartz
>-Original Message- >From: prabhat kumar [mailto:aim.prab...@gmail.com] >Sent: Thursday, September 03, 2009 1:44 PM >To: Darren Cassar >Cc: Christos Pelekis; mysql@lists.mysql.com >Subject: Re: optimize my.cnf > >Well said Darren. Its not magic :) > [JS] Actua

Re: optimize my.cnf

2009-09-03 Thread prabhat kumar
Well said Darren. Its not magic :) Christos, you can download and run mysqlreport from http://hackmysql.com/mysqlreportguide it will give you more idea about DB serve performance. On Thu, Sep 3, 2009 at 3:07 PM, Darren Cassar wrote: > Hi Christos, > > Performance optimization is very subjective,

Re: optimize my.cnf

2009-09-03 Thread Darren Cassar
Hi Christos, Performance optimization is very subjective, and if you are experiencing low performance it can be a million different things. The description you provided didn't mention any of your current my.cnf settings, nor did it mention what kind of tables your database contains, size of data,