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