Daniel,
- Original Message -
From: "Daniel Andersen" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Tuesday, December 21, 2004 1:04 AM
Subject: Re: Weird load issues
On Mon, 20 Dec 2004 09:29 pm, Heikki Tuuri wrote:
Daniel,
it is simply processing bi
On Mon, 20 Dec 2004 09:29 pm, Heikki Tuuri wrote:
> Daniel,
>
> it is simply processing big SELECT queries. Maybe their optimization
> changed lately? You should tune your queries.
>
> You should also tune InnoDB, because you are running with the default 8 MB
> buffer pool size, and it is reading i
6 AM
Subject: Re: Weird load issues
please post the complete outputs of
SHOW PROCESSLIST;
and
SHOW INNODB STATUS
during such CPU peak.
> Daniel
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which al
> please post the complete outputs of
>
> SHOW PROCESSLIST;
>
> and
>
> SHOW INNODB STATUS
>
> during such CPU peak.
>
> > Daniel
>
> Best regards,
>
> Heikki Tuuri
> Innobase Oy
> Foreign keys, transactions, and row level locking for MySQL
> InnoDB Hot Backup - a hot backup tool for InnoDB which a
Daniel,
- Original Message -
From: "Daniel Andersen" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Friday, December 17, 2004 2:04 AM
Subject: Weird load issues
Hey,
A couple days ago my SQL server started hogging the entire CPU for no
reason
that I can f
Hey,
A couple days ago my SQL server started hogging the entire CPU for no reason
that I can find. I'm running MySQL 4.0.20 on Slackware 9.1 (i think), kernel
version 2.4.22. The process using up all the CPU is the parent process, ie
the top level mysql process that starts all the others.
The
