;Andrew I. Baznikin" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Monday, September 10, 2001 11:13 PM
> Subject: MySQL processor overload
>
> > >Description:
> > Sometimes MySQL capture 80-90% of processor time.
> >
> > # top
> >
- Original Message -
From: "Andrew I. Baznikin" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, September 10, 2001 11:13 PM
Subject: MySQL processor overload
> >Description:
> Sometimes MySQL capture 80-90% of processor time.
>
> # top
>
On Tue, Sep 11, 2001 at 11:13:48AM +0800, Andrew I. Baznikin wrote:
I'm not so sure that this is MySQL's fault as it is the FreeBSD
thread library.
IIRC, under the FreeBSD thread implementation, the process will
spin away doing essentially sched_yield() if it's simply waiting for blocked
I/O to
>Description:
Sometimes MySQL capture 80-90% of processor time.
# top
PID USERNAMEPRI NICE SIZERES STATETIME WCPUCPU COMMAND
45215 mysql53 0 31960K 5480K RUN941:42 94.68% 94.68% mysqld
#truss -p `cat /var/db/mysql/poster.pid `
g
