-Original Message-
From: Gunnar R. [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
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). The SQL database is about 700MB.
It's all running
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). The SQL database is about 700MB.
It's all running
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
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
Hi,
Thanks.
mysql show processlist;
++---+---+---+-+--+--+--+
| Id | User | Host | db| Command | Time
@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). The SQL database is about 700MB.
It's all running on a couple
@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). The SQL database is about 700MB.
It's all running on a couple of years old
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
-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 have
: 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 Dell box with two P4
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
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 couple of
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
14 matches
Mail list logo