> Hello, i have got a A BIG PROBLEM, help me please!!!
>
> I've got installed Apache + MySQL in a Sun Enterp. 250 whith two
> processors and my problem is the next:
>
> When I run MySQL only works one processor with mysqld
>
>
> load averages: 0.68, 0.81, 1.02
> 01:37:45
> 259 processes: 251 sleeping, 6 zombie, 2 on cpu
> CPU states: 48.8% idle, 26.9% user, 23.7% kernel, 0.6% iowait, 0.0% swap
> Memory: 1024M real, 16M free, 68M swap in use, 1934M swap free
>
> PID USERNAME THR PRI NICE SIZE RES STATE TIME CPU COMMAND
> 22889 root 30 33 0 801M 11M cpu0 23.6H 26.75% mysqld
> 3939 root 1 51 0 2136K 1552K cpu1 0:00 0.48% top
> 2227 nobody 1 58 0 4104K 2312K sleep 0:02 0.40% httpd
> 3363 nobody 1 58 0 4304K 3168K sleep 0:00 0.15% httpd
> 3136 nobody 1 59 0 4104K 2312K sleep 0:00 0.13% httpd
> 10402 nobody 1 58 0 4312K 3112K sleep 0:02 0.08% httpd
> 25838 nobody 1 58 0 4312K 3144K sleep 0:01 0.07% httpd
> 3919 svcapnda 1 58 0 2824K 1576K sleep 0:00 0.07% httpd
> 12933 nobody 1 58 0 4328K 3136K sleep 0:02 0.07% httpd
> 7555 nobody 1 59 0 4104K 2288K sleep 0:02 0.06% httpd
> 3520 nobody 1 58 0 5160K 2432K sleep 0:00 0.06% httpd
> 3381 nobody 1 58 0 4080K 2264K sleep 0:00 0.06% httpd
> 20654 nobody 1 58 0 4392K 2744K sleep 1:32 0.06% httpd
> 3920 svcapnda 1 48 0 2864K 1624K sleep 0:00 0.06% httpd
> 20688 nobody 1 58 0 4408K 2704K sleep 1:34 0.06% httpd
>
> The big problem is this:
>
> Actually I've got renamed the .htaccess to .htaccess.kk(for example) for
> no utilitation, but when I rename the .htaccess to its normal name (this
> is .htaccess) then occurs the next: in one minute one of the cpu's takes a
> load of 80% or 90% and the other cpu doesn't makes nothing, this is, my
> problem is that the mysqld not uses the 2 cpu's, only uses one of two.
>
>
> load averages: 6.84, 2.09, 1.13
> 02:07:56
> 240 processes: 235 sleeping, 1 running, 2 zombie, 2 on cpu
> CPU states: 0.0% idle, 55.5% user, 44.5% kernel, 0.0% iowait, 0.0% swap
> Memory: 1024M real, 15M free, 68M swap in use, 1933M swap free
>
> PID USERNAME THR PRI NICE SIZE RES STATE TIME CPU COMMAND
> 22889 root 54 43 0 801M 12M cpu0 23.8H 77.19% mysqld
> 7897 root 1 51 0 2120K 1544K cpu1 0:00 0.72% top
> 7106 svcapnda 1 58 0 2872K 1632K sleep 0:00 0.08% httpd
> 15023 nobody 1 58 0 4320K 3144K sleep 0:02 0.07% httpd
> 7970 nobody 1 58 0 4080K 2264K sleep 0:00 0.07% httpd
> 14254 nobody 1 58 0 4312K 3160K sleep 0:02 0.07% httpd
> 7780 svcapnda 1 48 0 2864K 1624K sleep 0:00 0.06% httpd
> 10556 nobody 1 58 0 4432K 3096K sleep 0:37 0.06% httpd
> 7980 nobody 1 58 0 4080K 2016K sleep 0:00 0.06% httpd
> 7979 svcapnda 1 58 0 2840K 1600K sleep 0:00 0.06% httpd
> 7976 nobody 1 58 0 4080K 2016K sleep 0:00 0.06% httpd
> 7975 nobody 1 58 0 4088K 2280K sleep 0:00 0.05% httpd
> 7953 nobody 1 58 0 4080K 2264K sleep 0:00 0.05% httpd
> 23276 nobody 1 58 0 4112K 2296K sleep 0:02 0.05% httpd
> 23278 nobody 1 58 0 4104K 2312K sleep 0:01 0.05% httpd
>
>
> Could be possible that the mysql is not compiled for SMP? If this is true
> what is the most convenient to do and how?
>
>
> Thank You and excuse my bad english.
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
