>-----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.com>wrote: > >> 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
