On 15/10/06, Eric Hodel <[EMAIL PROTECTED]> wrote:
On Oct 13, 2006, at 1:13 PM, Kris Kennaway wrote:
> On Fri, Oct 13, 2006 at 11:49:04AM -0700, Chuck Swiger wrote:
>> On Oct 13, 2006, at 11:26 AM, Eric Hodel wrote:
> Or did that change recently?
It's only on certain systems, appare
On Mon, Oct 16, 2006 at 07:05:28PM +0100, Chris wrote:
> On 15/10/06, Eric Hodel <[EMAIL PROTECTED]> wrote:
> >On Oct 13, 2006, at 1:13 PM, Kris Kennaway wrote:
> >> On Fri, Oct 13, 2006 at 11:49:04AM -0700, Chuck Swiger wrote:
> >>> On Oct 13, 2006, at 11:26 AM, Eric Hodel wrote:
> >> Or did t
On Oct 13, 2006, at 1:13 PM, Kris Kennaway wrote:
On Fri, Oct 13, 2006 at 11:49:04AM -0700, Chuck Swiger wrote:
On Oct 13, 2006, at 11:26 AM, Eric Hodel wrote:
Or did that change recently?
It's only on certain systems, apparently.
Is there a list of systems where it is safe to use the TSC w
I will do some testing tonight with variations in the my.cnf file and post
the results tomorrow.
> At 03:20 PM 10/6/2006, Jerry Bell wrote:
>>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
>> bac
At 03:20 PM 10/6/2006, Jerry Bell wrote:
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
Hi,
I was just looking at this thread as its relevant to a new
DB server I am trying to put tog
On Fri, Oct 13, 2006 at 11:49:04AM -0700, Chuck Swiger wrote:
> On Oct 13, 2006, at 11:26 AM, Eric Hodel wrote:
> >>>Or did that change recently?
> >>
> >>It's only on certain systems, apparently.
> >
> >Is there a list of systems where it is safe to use the TSC with
> >SMP? Or some script we ca
On Oct 13, 2006, at 11:26 AM, Eric Hodel wrote:
Or did that change recently?
It's only on certain systems, apparently.
Is there a list of systems where it is safe to use the TSC with
SMP? Or some script we can run?
The problem of the TSC clocks getting out of sync affects pretty much
a
On Oct 12, 2006, at 1:53 PM, Kris Kennaway wrote:
On Thu, Oct 12, 2006 at 11:25:48AM +0200, Oliver Fromme wrote:
Jerry Bell wrote:
I have a Dell PE2950 with 2 dual core 3.73Ghz processors and 4G
of ram.
[...]
changed the clock to TSC
As far as I know, it is unsafe to use TSC on SMP systems.
On Thu, Oct 12, 2006 at 11:25:48AM +0200, Oliver Fromme wrote:
> Jerry Bell wrote:
> > I have a Dell PE2950 with 2 dual core 3.73Ghz processors and 4G of ram.
> > [...]
> > changed the clock to TSC
>
> As far as I know, it is unsafe to use TSC on SMP systems.
>
> Or did that change recently?
Jerry Bell wrote:
> I have a Dell PE2950 with 2 dual core 3.73Ghz processors and 4G of ram.
> [...]
> changed the clock to TSC
As far as I know, it is unsafe to use TSC on SMP systems.
Or did that change recently?
Best regards
Oliver
--
Oliver Fromme, secnetix GmbH & Co. KG, Marktplatz
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
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
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
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.
On Friday 06 October 2006 07:24, Jerry Bell wrote:
> I always thougt that compiling something static increased performance, but
> then that's probably true for things that have to startup and shutdown
> frequently.
>
> Thanks again.
>
> Jerry
>
static compiling will link libpthread but not libthr.
Many thanks to all who responded. You are an incredibly smart group of
people.
The recompiling without static yielded much better results:
2950# super-smack -d mysql select-key-mysql.smack 10 1
Query Barrel Report for client smacker1
connect: max=1ms min=0ms avg= 0ms from 10 clients
Query_t
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 about 34k with the wide at the back of my server wh
On Thursday 05 October 2006 03:52, Jerry Bell wrote:
> I expected the 2950 to be a bit closer to the 1.8Ghz opteron discussed
> here:
> http://article.gmane.org/gmane.os.freebsd.performance/1137/match=mysql
Well he used several patches [1] from the current + ULE scheduler, which seems
to give you
Jerry Bell skrev:
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 about 34k with the wide at the back of my server whi
On Wed, 4 Oct 2006 20:52:51 -0400 (EDT)
"Jerry Bell" <[EMAIL PROTECTED]> 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 abl
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 about 34k with the wide at the back of my server whilest rubbing
the sid
21 matches
Mail list logo