Re: SMP+mysql problem

2001-07-20 Thread Igor Brezac
Under solaris 8 you can use pmap -x 22889 which will give address space map. -Igor On Fri, 20 Jul 2001, Jeremy Zawodny wrote: > On Wed, Jul 18, 2001 at 12:45:57PM +0200, Werner Stuerenburg wrote: > > What I am stumbling about is this: > > > > > PID USERNAME THR PRI NICE SIZE RES STATE

Re: SMP+mysql problem

2001-07-20 Thread Werner Stuerenburg
> It's normal that the mysqld is 795M big? If is not normal which could be the > cause of this size? Certainly not. But Jeremy gave some comments; I don't know anything about this, I wonder myself. My processes are between 8 and 25 MB. > PID USERNAME THR PRI NICE SIZE RES STATE TIMEC

Re: SMP+mysql problem

2001-07-20 Thread Jeremy Zawodny
On Wed, Jul 18, 2001 at 12:45:57PM +0200, Werner Stuerenburg wrote: > What I am stumbling about is this: > > > PID USERNAME THR PRI NICE SIZE RES STATE TIMECPU COMMAND > >> 22889 root 30 330 801M 11M cpu0 23.6H 26.75% mysqld > > Is this really true: size 801 M?

Re: Solaris +SMP + mysql problem

2001-07-18 Thread Alexander Belyaev
Hello, I have thread_concurrency=4 already in my.cnf, but mysqld don't want to use more than 50% of CPU resources. (Solaris8 x86 MU3 on Dual PIII Xeon with 1GB RAM) Alexander > On Wednesday 18 July 2001 07:41, Alexander Belyaev wrote: > > Hello, > > I have a similar results on my Solaris8 x86 +

Re[2]: SMP+mysql problem

2001-07-18 Thread Werner Stuerenburg
the output of Top in Solaris mysqld is 801M > If you need an archive conf. or something to help me, say me please. > -Mensaje original- > De: Werner Stuerenburg [mailto:[EMAIL PROTECTED]] > Enviado el: miƩrcoles, 18 de julio de 2001 12:46 > Para: Jorge Ruiz Martinez > C

Re: SMP+mysql problem

2001-07-18 Thread Werner Stuerenburg
What I am stumbling about is this: > PID USERNAME THR PRI NICE SIZE RES STATE TIMECPU COMMAND >> 22889 root 30 330 801M 11M cpu0 23.6H 26.75% mysqld Is this really true: size 801 M How can that be -- Herzlich Werner Stuerenburg _

SMP+mysql problem

2001-07-18 Thread Jorge Ruiz Martinez
> 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: 2