Wow, thanks Brent, nice to learn something new (I'm not much of a 'server' guy)
Tried the iostat and got some results while performing a general query:
mysql> SELECT count(*) FROM product_fulltext WHERE MATCH(search_text) AGAINST('DISK');
+----------+
| count(*) |
+----------+
| 4975 |
+----------+
1 row in set (11.28 sec)
IOStat Output
----------------------
avg-cpu: %user %nice %sys %idle
0.25 0.00 0.00 99.75
Device: tps Blk_read/s Blk_wrtn/s Blk_read Blk_wrtn
dev8-0 0.00 0.00 0.00 0 0
dev8-1 0.00 0.00 0.00 0 0
avg-cpu: %user %nice %sys %idle
0.25 0.00 0.00 99.75
Device: tps Blk_read/s Blk_wrtn/s Blk_read Blk_wrtn
dev8-0 110.00 1872.00 88.00 1872 88
dev8-1 0.00 0.00 0.00 0 0
avg-cpu: %user %nice %sys %idle
0.25 0.00 0.25 99.50
Device: tps Blk_read/s Blk_wrtn/s Blk_read Blk_wrtn
dev8-0 347.00 6200.00 240.00 6200 240
dev8-1 0.00 0.00 0.00 0 0
avg-cpu: %user %nice %sys %idle
1.25 0.00 0.75 98.00
Device: tps Blk_read/s Blk_wrtn/s Blk_read Blk_wrtn
dev8-0 140.00 2024.00 1408.00 2024 1408
dev8-1 0.00 0.00 0.00 0 0
avg-cpu: %user %nice %sys %idle
0.00 0.00 0.50 99.50
Device: tps Blk_read/s Blk_wrtn/s Blk_read Blk_wrtn
dev8-0 342.00 6568.00 112.00 6568 112
dev8-1 0.00 0.00 0.00 0 0
avg-cpu: %user %nice %sys %idle
0.00 0.00 0.50 99.50
Device: tps Blk_read/s Blk_wrtn/s Blk_read Blk_wrtn
dev8-0 368.00 7600.00 0.00 7600 0
dev8-1 0.00 0.00 0.00 0 0
avg-cpu: %user %nice %sys %idle
0.25 0.00 0.50 99.25
Device: tps Blk_read/s Blk_wrtn/s Blk_read Blk_wrtn
dev8-0 363.00 7160.00 88.00 7160 88
dev8-1 0.00 0.00 0.00 0 0
avg-cpu: %user %nice %sys %idle
0.25 0.00 0.50 99.25
Device: tps Blk_read/s Blk_wrtn/s Blk_read Blk_wrtn
dev8-0 371.00 7104.00 0.00 7104 0
dev8-1 0.00 0.00 0.00 0 0
avg-cpu: %user %nice %sys %idle
0.00 0.00 0.25 99.75
Device: tps Blk_read/s Blk_wrtn/s Blk_read Blk_wrtn
dev8-0 343.00 6360.00 0.00 6360 0
dev8-1 0.00 0.00 0.00 0 0
avg-cpu: %user %nice %sys %idle
0.25 0.00 0.50 99.25
Device: tps Blk_read/s Blk_wrtn/s Blk_read Blk_wrtn
dev8-0 360.00 6696.00 64.00 6696 64
dev8-1 0.00 0.00 0.00 0 0
avg-cpu: %user %nice %sys %idle
0.00 0.00 0.25 99.75
Device: tps Blk_read/s Blk_wrtn/s Blk_read Blk_wrtn
dev8-0 367.00 7184.00 0.00 7184 0
dev8-1 0.00 0.00 0.00 0 0
avg-cpu: %user %nice %sys %idle
0.25 0.00 0.00 99.75
Device: tps Blk_read/s Blk_wrtn/s Blk_read Blk_wrtn
dev8-0 330.00 6448.00 56.00 6448 56
dev8-1 0.00 0.00 0.00 0 0
avg-cpu: %user %nice %sys %idle
0.25 0.00 1.00 98.75
Device: tps Blk_read/s Blk_wrtn/s Blk_read Blk_wrtn
dev8-0 380.00 7176.00 0.00 7176 0
dev8-1 0.00 0.00 0.00 0 0
avg-cpu: %user %nice %sys %idle
0.00 0.00 0.00 100.00
Device: tps Blk_read/s Blk_wrtn/s Blk_read Blk_wrtn
dev8-0 0.00 0.00 0.00 0 0
dev8-1 0.00 0.00 0.00 0 0
Not knowing much about this, it looks like the write speed is pretty slow (I guess it
should take longer than reads though).
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
