Why is MySQL nearly twice as fast on Linux?

[Petri Helenius]

JG wrote:

> At 08:46 PM 5/23/2004 +0300, you wrote:
>
>> JG wrote:
>>
>>>
>>> You mean where I have the 3 instances of mysqld running in top?  You 
>>> have ~30 instances?
>>
>> I´m running the supersmack with $1=30.
>
>
> (For those reading this thread who have not looked at the super-smack 
> source code,
> which I'm sure most have not, what Pete means by $1 is the number of 
> simultaneous
> supersmack client connections to run, even though it would be $2 from 
> shell
> ie:   super-smack smackfile-to-run clients rounds-per-client)
>
>
> Anyway Pete, I am running the supersmack with 30 clients as well.
>
> But that isn't what I asked you.
>
> I have 30 supersmack clients running in top -H when the test is 
> running (if I ran it with 30 clients anyway).
>
> What I don't have is 30 mysqld instances (I had 3, as shown), and that 
> is what you made it sound like you had.
>
> You said:
>
> "You seem to have a very small number of active threads. When I tried 
> supersmack on fairly old machine (800MHz dual pentium) I get ~30 
> active mysql threads using CPU between 1.5% and 3.5%."
>
> So if this is not the case, please clarify.
>
> Or better...  post your top -H while tests are running as well as the 
> super-smack command you ran.
>
last pid: 19842;  load averages:  7.32,  1.70,  
0.67                                                 up 5+10:01:49  21:33:44
110 processes: 1 running, 99 sleeping, 10 lock
CPU states: 55.6% user,  0.0% nice, 39.4% system,  0.8% interrupt,  4.2% 
idle
Mem: 312M Active, 64M Inact, 103M Wired, 18M Cache, 60M Buf, 992K Free
Swap: 3906M Total, 164K Used, 3906M Free

  PID USERNAME PRI NICE   SIZE    RES STATE  C   TIME   WCPU    CPU COMMAND
  646 mysql     20    0   285M   282M kserel 0 400:31  2.39%  2.39% mysqld
  646 mysql     20    0   285M   282M kserel 0 400:31  2.39%  2.39% mysqld
  646 mysql     98    0   285M   282M *Giant 0 400:31  2.34%  2.34% mysqld
  646 mysql     20    0   285M   282M kserel 1 400:31  2.25%  2.25% mysqld
  646 mysql     20    0   285M   282M kserel 0 400:31  2.15%  2.15% mysqld
  646 mysql     20    0   285M   282M kserel 1 400:31  2.15%  2.15% mysqld
  646 mysql     98    0   285M   282M *Giant 0 400:31  2.15%  2.15% mysqld
  646 mysql     20    0   285M   282M kserel 0 400:31  2.05%  2.05% mysqld
  646 mysql     20    0   285M   282M kserel 0 400:31  2.00%  2.00% mysqld
  646 mysql     20    0   285M   282M kserel 0 400:31  2.00%  2.00% mysqld
  646 mysql     20    0   285M   282M kserel 0 400:31  1.95%  1.95% mysqld
  646 mysql     20    0   285M   282M kserel 0 400:31  1.95%  1.95% mysqld
  646 mysql     20    0   285M   282M kserel 0 400:31  1.95%  1.95% mysqld
  646 mysql     20    0   285M   282M kserel 0 400:31  1.95%  1.95% mysqld
  646 mysql     98    0   285M   282M *Giant 0 400:31  1.95%  1.95% mysqld
  646 mysql     20    0   285M   282M kserel 1 400:31  1.90%  1.90% mysqld
  646 mysql     20    0   285M   282M kserel 0 400:31  1.90%  1.90% mysqld
  646 mysql     20    0   285M   282M kserel 1 400:31  1.90%  1.90% mysqld
  646 mysql     20    0   285M   282M kserel 0 400:31  1.86%  1.86% mysqld
  646 mysql     20    0   285M   282M kserel 0 400:31  1.86%  1.86% mysqld
  646 mysql     20    0   285M   282M kserel 0 400:31  1.81%  1.81% mysqld
  646 mysql     97    0   285M   282M *Giant 0 400:31  1.81%  1.81% mysqld
  646 mysql     20    0   285M   282M kserel 1 400:31  1.71%  1.71% mysqld
  646 mysql     98    0   285M   282M *Giant 0 400:31  1.71%  1.71% mysqld
  646 mysql     20    0   285M   282M kserel 0 400:31  1.66%  1.66% mysqld
  646 mysql     20    0   285M   282M kserel 0 400:31  1.66%  1.66% mysqld
  646 mysql     97    0   285M   282M *Giant 0 400:31  1.56%  1.56% mysqld
  646 mysql      4    0   285M   282M sbwait 0 400:31  1.46%  1.46% mysqld
  646 mysql     20    0   285M   282M kserel 0 400:31  1.37%  1.37% mysqld
  646 mysql     20    0   285M   282M kserel 1 400:31  1.22%  1.22% mysqld
  646 mysql      4    0   285M   282M sbwait 0 400:31  1.22%  1.22% mysqld
19813 pete       4    0  2600K  1712K sbwait 0   0:00  1.19%  0.68% 
super-smack
19835 pete       4    0  2600K  1712K sbwait 0   0:00  1.11%  0.63% 
super-smack
19831 pete      96    0  2600K  1712K *Giant 0   0:00  1.11%  0.63% 
super-smack
19837 pete       4    0  2600K  1712K sbwait 1   0:00  1.11%  0.63% 
super-smack

Pete