On ons, januar 2, 2008, 13:07, Andrew Braithwaite wrote:
Hi,
If you can follow this document:
http://www.ufsdump.org/papers/uuasc-june-2006.pdf
You should be able to figure out what's happening.
Cheers,
Andrew
-Original Message-
From: Gunnar R. [mailto:[EMAIL PROTECTED]
Sent: Tue, 0
At 3:51p -0500 onGunnar R. wrote, On 01/08/2008 03:51 PM:
That tool tells me 100% of the data is read from memory, not a byte from
disk... would there still be any point in getting more memory?
Any suggestions to where to go from here?
I dunno. My hunch is that could do some query optimizat
At 6:47a -0500 on 08 Jan 2008, Gunnar R. wrote:
Concerning slow queries, it seems there's a couple of different queries
that's being logged.
I haven't tried it yet, but this recently went by on debaday.debian.net:
mytop: a top clone for MySQL
http://debaday.debian.net/2007/12/26/mytop-a-top-
4464 S 99.9 30.8 4200:25 mysqld
>>
>> How come the CPUs can have idle time even though mysqld is running at
>> 99.9%, AND there's a processor queue (4.36)?
>>
>> Cheers,
>>
>> Gunnar R.
>>
>> On ons, januar 2, 2008, 13:07, Andrew Braithwaite
4464 S 99.9 30.8 4200:25 mysqld
>>
>> How come the CPUs can have idle time even though mysqld is running at
>> 99.9%, AND there's a processor queue (4.36)?
>>
>> Cheers,
>>
>> Gunnar R.
>>
>> On ons, januar 2, 2008, 13:07, Andrew Braithwaite
mailto:[EMAIL PROTECTED]
Sent: Tue, 01 January 2008 23:31
To: mysql@lists.mysql.com
Subject: Performance problem - MySQL at 99.9% CPU
Hello,
I am running a community site mainly based on phpBB. It has about
9.300
registered users, 650.000 posts and about 200.000 visitors/month (12
mill
"hits&qu
ilto:[EMAIL PROTECTED]
> Sent: Tue, 01 January 2008 23:31
> To: mysql@lists.mysql.com
> Subject: Performance problem - MySQL at 99.9% CPU
>
> Hello,
>
> I am running a community site mainly based on phpBB. It has about 9.300
> registered users, 650.000 posts and about 200.000 v
Hi,
Thanks.
mysql> show processlist;
++---+---+---+-+--+--+--+
| Id | User | Host | db| Command | Time
bject: Performance problem - MySQL at 99.9% CPU
Hello,
I am running a community site mainly based on phpBB. It has about 9.300
registered users, 650.000 posts and about 200.000 visitors/month (12
mill
"hits"). The SQL database is about 700MB.
It's all running on a couple of years old
-Original Message-
From: Per Jessen [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 02, 2008 7:51 AM
To: mysql@lists.mysql.com
Subject: Re: Performance problem - MySQL at 99.9% CPU
Gunnar R. wrote:
> I am thinking about buying a new dual core box (with IDE disks?), but
> I h
Gunnar R. wrote:
> I am thinking about buying a new dual core box (with IDE disks?), but
> I have to make sure this really is a hardware issue before I spend
> thousands of bucks.
I think you've got an application problem somewhere which you should
look into first. Hardware-wise I think you're d
Hi, please monitor what happened with mysql
show processlist
show innodb status
and also ps aux
because maybe some application makes your mysql busy
On Jan 2, 2008 7:31 AM, Gunnar R. <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I am running a community site mainly based on phpBB. It has about 9.300
Hi,
On Jan 1, 2008 6:31 PM, Gunnar R. <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I am running a community site mainly based on phpBB. It has about 9.300
> registered users, 650.000 posts and about 200.000 visitors/month (12 mill
> "hits"). The SQL database is about 700MB.
>
> It's all running on a co
Hello,
I am running a community site mainly based on phpBB. It has about 9.300
registered users, 650.000 posts and about 200.000 visitors/month (12 mill
"hits"). The SQL database is about 700MB.
It's all running on a couple of years old Dell box with two P4 Xeon 1.7Ghz
CPUs, 1GB of RAMBUS memory
14 matches
Mail list logo
