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
> 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
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
Hi,
I'm running mysql 3.23.42 on a 1.4ghz athlon with 512mb of ram for my
database server but this machine doesn't seem to be able to handle the load,
which makes me think i must be doing something wrong. The primary job of
this database is radius authentication for our 30k or so customers so it i
