Re: mysql db's hosed? Help needed badly

-- 
Rick Zeman
Manager of Information Technology
Melwood Horticultural Training Center
301.599.4574 - HelpDesk
301.599.4560 - MyDesk
http://www.melwood.org


>>> Karl Latiss <karl.latissatvert.com.au> 10/15/2007 10:45:39 PM
>>>
On Thu, 2007-10-11 at 12:23 -0400, Rick Zeman wrote:
>  free
>              total       used       free     shared   
buffers    
> cached
> Mem:       2074872    2022764      52108          0    
     0   
> 1590628
> -/+ buffers/cache:     432136    1642736
> Swap:      2104432        100    2104332
> 
> top shows:
> top - 12:13:36 up 1 day, 23:48,  5 users,  load
average: 2.00, 2.01,
> 2.33
> Tasks: 123 total,   1 running, 122 sleeping,   0
stopped,   0 zombie
> Cpu(s):  0.8%us,  0.3%sy,  0.0%ni,  1.8%id, 96.8%wa, 
0.0%hi,  0.2%si,

> 0.0%st
> Mem:   2074872k total,  2023072k used,    51800k free, 
      0k
buffers
> Swap:  2104432k total,      100k used,  2104332k free, 
1590904k
cached
> 

I'm not sure if you have resolved this (couldn't see it in
the list
messages) but this output is showing a wait state of 96.8%.
This would
indicate an I/O issue, ie your server is furiously
reading/writing to
disk while your CPU is idling.

_________________

Yeah, I got that one:  The bottleneck is the linux software
RAID 1...and
I don't have a way to resolve that.  The amount of overhead
it's taking is
staggering.  But I think if I can out from under this
multiple thousand
message backlog it'll be sufficient for a 15k/day server. 
_______________________________________________
Maia-users mailing list
Maia-usersrenaissoft.com
http://www.renaissoft.com/mailman/listinfo/maia-users

We use SUSE Linux 10 with software RAID1 on a couple WD 250
gig 7200rpm SATA
300 hds and don't have any problems. I don't know the
specific number of
messages we process a day but it is between 50k - 100k. 
Typical delay seems
to be 2 sec.

What kind of hard drives are you using?

I have 4 Gig of ram in the server and I set innodb buffer
pool to 1 gig.
Between MySQL and the 30 amavisd processes the server shows
2.2 gig used of
the 4 gig.  

You sure you have enough ram in your server?  

Todd




_________________
>
>Yeah, I got that one:  The bottleneck is the linux
software RAID 1...and
>I don't have a way to resolve that.  The amount of
overhead it's taking is
>staggering.  But I think if I can out from under this
multiple thousand
>message backlog it'll be sufficient for a 15k/day
server. 
_______________________________________________
Maia-users mailing list
Maia-usersrenaissoft.com
http://www.renaissoft.com/mailman/listinfo/maia-users



_______________________________________________
Maia-users mailing list
Maia-usersrenaissoft.com
http://www.renaissoft.com/mailman/listinfo/maia-users