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 find. I'm running
