PM
To: [EMAIL PROTECTED]
Subject: Re: MySQL eats 100% CPU on a quad CPU system...
Are you swapping? Check vmstat and iostat
Are your queries optimized, are they doing full table scans? Enable
the slow query log.
On Mon, 16 Aug 2004 14:48:35 +0200, Fahr o Mavastradioz
<[EMAIL PROTECTED]> wro
Are you swapping? Check vmstat and iostat
Are your queries optimized, are they doing full table scans? Enable
the slow query log.
On Mon, 16 Aug 2004 14:48:35 +0200, Fahr o Mavastradioz
<[EMAIL PROTECTED]> wrote:
> Hello people,
>
> I'm currently configuring a quad CPU system as a standalone
oper
http://www.dalar.net
- Original Message -
From: "Fahr o Mavastradioz" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, August 16, 2004 3:48 PM
Subject: MySQL eats 100% CPU on a quad CPU system...
> Hello people,
>
> I'm currently confi
Hello people,
I'm currently configuring a quad CPU system as a standalone MySQL server.
The machine runs nothing except for MySQL and some trivial things like SSH
and iptables.
A second server acts as a webserver and is connected to this one though an
internal LAN connection.
Using top or ps, it s
