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.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
