Re: Help with improving mysql performance on 6.2PRE

2006-10-06 Thread Jerry Bell
I have actually made the changes to my.cnf before I ran these. I expanded them quite a bit beyond what is in my-large.cnf. I need to pull them back in to save on some memory usage. I'm going to look at some of the other patches that have been suggested to me to see if they'll work and if they ma

Re: Help with improving mysql performance on 6.2PRE

2006-10-06 Thread Alexander Leidinger
Quoting Divacky Roman <[EMAIL PROTECTED]> (from Fri, 6 Oct 2006 09:57:38 +0200): On Wed, Oct 04, 2006 at 08:52:51PM -0400, Jerry Bell wrote: I have a Dell PE2950 with 2 dual core 3.73Ghz processors and 4G of ram. I've looked through some of the lists here and have seen super-smack results in

Re: Help with improving mysql performance on 6.2PRE

2006-10-06 Thread Divacky Roman
On Wed, Oct 04, 2006 at 08:52:51PM -0400, Jerry Bell wrote: > I have a Dell PE2950 with 2 dual core 3.73Ghz processors and 4G of ram. > I've looked through some of the lists here and have seen super-smack > results in the 42k qps range on a 2 dual core opteron system. I'm able to > get up to abou

Re: Help with improving mysql performance on 6.2PRE

2006-10-06 Thread Michael Vince
Yeah the static compiling recommendations by MySQL documents are really more a linux thing more then anything else. The other other thing to check is to make sure you use larger buffer settings I recommend the large-my.cnf cp /usr/local/share/mysql/my-large.cnf /var/db/mysql/ Then restart MySQL.