optimize my.cnf

2009-09-03 Thread Christos Pelekis
Hi, can you please send me some optimization examples for my.cnf ? I use mysql 5.1.37 The server run just 2 very busy forums. It is quad core cpu and 8 giga ram so we have lot of run (run debian) Can you please give me some examples? Thanks -- MySQL General Mailing List For list archives:

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,

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 i...@mysqlpreacher.comwrote: Hi Christos, Performance optimization

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] Actually, its voodoo :) Regards, Jerry