At 15:53 +0100 10/06/2002, Andrew Braithwaite was thought to have said :
>Hi James,
>
>What kind of disks are in the old system and the new system (scsi or ide,
>any raid, what rpm do they have etc..?) I ask this because high cpu levels
>can be a symptom of a diskbound server...
>
>Try running the following:
>
>iostat -x 5 5
>vmstat 5 5
>
>Let me know & I'll try to help.
sql query
As requested, here is are the results fro vmstat and iostat from the
new slow server and the old dual zippy server both under the exact
same load less than 2 minutes apart.
Single Processor iostat
-----------------------
Linux 2.4.9-34 () 10/08/2002
avg-cpu: %user %nice %sys %idle
1.18 0.05 0.40 98.37
Device: rrqm/s wrqm/s r/s w/s rsec/s wsec/s avgrq-sz avgqu-sz
await svctm %util
hda 3.53 9.33 0.53 3.57 32.40 103.35 33.15 0.03
215.68 42.90 1.76
hda1 0.00 0.00 0.00 0.00 0.00 0.00 17.98 0.00
525.42 468.64 0.00
hda2 0.00 0.00 0.00 0.00 0.00 0.00 5.00 0.00
150.00 150.00 0.00
hda3 3.52 9.33 0.53 3.57 32.39 103.34 33.15 0.03
215.66 42.89 1.76
avg-cpu: %user %nice %sys %idle
0.00 0.00 0.40 99.60
Device: rrqm/s wrqm/s r/s w/s rsec/s wsec/s avgrq-sz avgqu-sz
await svctm %util
hda 0.00 3.00 0.00 1.00 0.00 32.00 32.00 0.00
0.00 0.00 0.00
hda1 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00
hda2 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00
hda3 0.00 3.00 0.00 1.00 0.00 32.00 32.00 0.00
0.00 0.00 0.00
avg-cpu: %user %nice %sys %idle
0.00 0.00 0.20 99.80
Device: rrqm/s wrqm/s r/s w/s rsec/s wsec/s avgrq-sz avgqu-sz
await svctm %util
hda 0.00 0.40 0.00 1.80 0.00 17.60 9.78 0.00
0.00 0.00 0.00
hda1 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00
hda2 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00
hda3 0.00 0.40 0.00 1.80 0.00 17.60 9.78 0.00
0.00 0.00 0.00
avg-cpu: %user %nice %sys %idle
7.60 0.00 7.20 85.20
Device: rrqm/s wrqm/s r/s w/s rsec/s wsec/s avgrq-sz avgqu-sz
await svctm %util
hda 0.00 0.20 0.00 0.60 0.00 6.40 10.67 0.00
0.00 0.00 0.00
hda1 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00
hda2 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00
hda3 0.00 0.20 0.00 0.60 0.00 6.40 10.67 0.00
0.00 0.00 0.00
avg-cpu: %user %nice %sys %idle
6.20 0.00 6.60 87.20
Device: rrqm/s wrqm/s r/s w/s rsec/s wsec/s avgrq-sz avgqu-sz
await svctm %util
hda 0.00 7.60 0.00 9.60 0.00 139.20 14.50 0.00
0.00 0.00 0.00
hda1 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00
hda2 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00
hda3 0.00 7.60 0.00 9.60 0.00 139.20 14.50 0.00
0.00 0.00 0.00
Single Processor vmstat
-----------------------
procs memory swap io system cpu
r b w swpd free buff cache si so bi bo in cs us sy id
0 0 0 21544 71820 234956 1007796 0 0 16 52 44 56
1 0 13
0 0 0 21544 71812 234956 1007796 0 0 0 16 112 23
0 1 99
0 0 0 21544 71812 234956 1007796 0 0 0 9 107 20
0 0 100
0 0 0 21544 71812 234956 1007796 0 0 0 3 110 18
0 0 100
0 0 0 21544 71480 234956 1007796 0 0 0 70 131 116
14 14 73
Dual Processor iostat
---------------------
avg-cpu: %user %nice %sys %idle
0.38 0.05 2.29 2.60
Device: rrqm/s wrqm/s r/s w/s rsec/s wsec/s avgrq-sz avgqu-sz
await svctm %util
hdc 7.19 3.02 1.24 5.54 8.25 10.17 20.19 0.03
21.87 0.69 0.05
hdc1 0.00 0.00 0.00 0.00 0.01 0.00 40.91 0.00
1291.58 1281.52 0.00
hdc5 7.19 3.02 1.24 5.54 8.24 10.17 20.19 0.03
21.84 0.69 0.05
hdc6 0.00 0.00 0.00 0.00 0.00 0.00 8.00 0.00
250.00 250.00 0.00
avg-cpu: %user %nice %sys %idle
22.20 0.00 11.20 66.60
Device: rrqm/s wrqm/s r/s w/s rsec/s wsec/s avgrq-sz avgqu-sz
await svctm %util
hdc 0.00 0.00 0.00 0.40 0.00 3.20 8.00 0.00
0.00 0.00 0.00
hdc1 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00
hdc5 0.00 0.00 0.00 0.40 0.00 3.20 8.00 0.00
0.00 0.00 0.00
hdc6 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00
avg-cpu: %user %nice %sys %idle
24.20 0.00 9.60 66.20
Device: rrqm/s wrqm/s r/s w/s rsec/s wsec/s avgrq-sz avgqu-sz
await svctm %util
hdc 0.00 0.00 0.00 2.00 0.00 16.00 8.00 0.00
0.00 0.00 0.00
hdc1 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00
hdc5 0.00 0.00 0.00 2.00 0.00 16.00 8.00 0.00
0.00 0.00 0.00
hdc6 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00
avg-cpu: %user %nice %sys %idle
11.40 0.00 4.00 84.60
Device: rrqm/s wrqm/s r/s w/s rsec/s wsec/s avgrq-sz avgqu-sz
await svctm %util
hdc 0.00 0.00 0.00 0.40 0.00 3.20 8.00 0.00
0.00 0.00 0.00
hdc1 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00
hdc5 0.00 0.00 0.00 0.40 0.00 3.20 8.00 0.00
0.00 0.00 0.00
hdc6 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00
avg-cpu: %user %nice %sys %idle
20.30 0.00 8.60 71.10
Device: rrqm/s wrqm/s r/s w/s rsec/s wsec/s avgrq-sz avgqu-sz
await svctm %util
hdc 0.00 0.00 0.00 1.20 0.00 9.60 8.00 0.00
0.00 0.00 0.00
hdc1 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00
hdc5 0.00 0.00 0.00 1.20 0.00 9.60 8.00 0.00
0.00 0.00 0.00
hdc6 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00
Dual Processor vmstat
---------------------
procs memory swap io system cpu
r b w swpd free buff cache si so bi bo in cs us sy id
1 0 1 928 31044 38796 648036 0 0 5 0 2 5 0 2 3
0 0 0 928 33276 38796 648044 0 0 0 0 198 3076 36 14 50
0 0 0 928 37276 38796 648060 0 0 0 3 153 1799 15 6 79
4 0 1 928 39596 38796 648064 0 0 0 6 150 625 26 8 65
1 0 0 928 44228 38796 648068 0 0 0 2 145 354 11 5 84
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
