From: mark_round@ipcmedia.com
Date: Fri Mar 04 2005 - 07:01:28 EST
Hi all,
I have an urgent problem here, and would appreciate any help... I have a
MySQL server running on an E450 with 1.5Gb RAM, and mirrored disks via
DiskSuite. MySQL is 4.0.22. Solaris is 9 04/04, latest patch cluster
applied.
The iowait on this system is sky-high (50-60%), and when I use truss on
the mysqld process, I can see that there are a large number of failed
"read" system calls. Top also shows that there is a large number of page
faults :
CPU states: 4.8% idle, 21.1% user, 18.5% kernel, 55.7% iowait, 0.0%
swap
Memory: 1.5G real, 932M free, 1003M swap in use, 4.1G swap free
PID USERNAME THR PR NCE SIZE RES STATE TIME FLTS CPU COMMAND
4329 mysql 333 60 0 975M 274M cpu02 63:04 2524 27.16% mysqld
Checking with truss reveals hundreds of these errors every second :
# sudo truss -p 4329 2>&1 | grep 'read(' | grep Err
/184: read(1072, 0x357BF410, 4) Err#11 EAGAIN
/184: read(1072, 0x357BF410, 4) Err#11 EAGAIN
/184: read(1072, 0x357BF410, 4) Err#11 EAGAIN
/184: read(1072, 0x357BF410, 4) Err#11 EAGAIN
/184: read(1072, 0x357BF410, 4) Err#11 EAGAIN
/184: read(1072, 0x357BF410, 4) Err#11 EAGAIN
/184: read(1072, 0x357BF410, 4) Err#11 EAGAIN
/184: read(1072, 0x357BF410, 4) Err#11 EAGAIN
/184: read(1072, 0x357BF410, 4) Err#11 EAGAIN
/58: read(1121, 0x3361DE78, 4) Err#11 EAGAIN
Has anyone got any ideas on where I should go from here to track this
problem down and try to resolve it ?
Many thanks in advance,
-Mark
Mark Round
UNIX Systems Administrator
IPC Country and Leisure Media
IPC Media Ltd, a Time Warner Company.
Kings Reach Tower, Stamford Street, London, SE1 9LS
mark_round@ipcmedia.com
AIM: markroundipc
+44 (0)207 261 5225
-----------------------------------------------------------------------
This E-mail is from IPC Media Ltd whose registered office is at Kings
Reach Tower, Stamford Street, London SE1 9LS, registered number 53626.
The contents and any attachments to it include information that is
private and confidential and should only be read by those persons to
whom they are addressed. IPC Media accepts no liability for any loss or
damage suffered by any person arising from the use of this e-mail.
Neither IPC Media nor the sender accepts any responsibility for viruses
and it is your responsibility to check the email and attachments (if any).
No contracts may be concluded on behalf of IPC Media by means of e-mail
communications. If you have received this e-mail in error, please destroy
and delete the message from your computer. For unbeatable savings on
magazine subscriptions and great gift ideas visit www.ipcsubs.co.uk/IZAF
_______________________________________________
sunmanagers mailing list
sunmanagers@sunmanagers.org
http://www.sunmanagers.org/mailman/listinfo/sunmanagers
This archive was generated by hypermail 2.1.7 : Wed Apr 09 2008 - 23:30:17 EDT