optimize my.cnf
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: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: optimize my.cnf
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, types of indexes, engines used by your tables etc. You mention you have a quad core machine running 8G ram how much of that ram is being used by MySQL and how much by other applications? how much of it is free? What kind of CPU usage are you experiencing, what is the size of your db, are you logging slow queries and checking for missing indexes? My.cnf is not a magic box which improves performance by setting a couple of variables and normally the performance improvements are minimal as compared to other things like: 1: faster disks 2: normalized and correctly designed db (not in your power I guess) 3: good code in your application (not in your power either) I'd suggest you read High Performance MySQL 2nd ed which will definitely be of help. Sorry for bombarding you with questions but performance tuning is not something you do by setting a couple of params on my.cnf! Gluck Darren www.mysqlpreacher.com - yet another blog from a mysql dba www.securich.com - a mysql security plugin On Thu, Sep 3, 2009 at 10:06 AM, Christos Pelekis chris...@blueice.orgwrote: 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: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=i...@mysqlpreacher.com
Re: optimize my.cnf
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 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, types of indexes, engines used by your tables etc. You mention you have a quad core machine running 8G ram how much of that ram is being used by MySQL and how much by other applications? how much of it is free? What kind of CPU usage are you experiencing, what is the size of your db, are you logging slow queries and checking for missing indexes? My.cnf is not a magic box which improves performance by setting a couple of variables and normally the performance improvements are minimal as compared to other things like: 1: faster disks 2: normalized and correctly designed db (not in your power I guess) 3: good code in your application (not in your power either) I'd suggest you read High Performance MySQL 2nd ed which will definitely be of help. Sorry for bombarding you with questions but performance tuning is not something you do by setting a couple of params on my.cnf! Gluck Darren www.mysqlpreacher.com - yet another blog from a mysql dba www.securich.com - a mysql security plugin On Thu, Sep 3, 2009 at 10:06 AM, Christos Pelekis chris...@blueice.org wrote: 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: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=i...@mysqlpreacher.com -- Best Regards, Prabhat Kumar MySQL DBA My Blog: http://adminlinux.blogspot.com My LinkedIn: http://www.linkedin.com/in/profileprabhat
RE: optimize my.cnf
-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 Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com 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 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, types of indexes, engines used by your tables etc. You mention you have a quad core machine running 8G ram how much of that ram is being used by MySQL and how much by other applications? how much of it is free? What kind of CPU usage are you experiencing, what is the size of your db, are you logging slow queries and checking for missing indexes? My.cnf is not a magic box which improves performance by setting a couple of variables and normally the performance improvements are minimal as compared to other things like: 1: faster disks 2: normalized and correctly designed db (not in your power I guess) 3: good code in your application (not in your power either) I'd suggest you read High Performance MySQL 2nd ed which will definitely be of help. Sorry for bombarding you with questions but performance tuning is not something you do by setting a couple of params on my.cnf! Gluck Darren www.mysqlpreacher.com - yet another blog from a mysql dba www.securich.com - a mysql security plugin On Thu, Sep 3, 2009 at 10:06 AM, Christos Pelekis chris...@blueice.org wrote: 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: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=i...@mysqlpreacher.com -- Best Regards, Prabhat Kumar MySQL DBA My Blog: http://adminlinux.blogspot.com My LinkedIn: http://www.linkedin.com/in/profileprabhat -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
