Dear Dave,
Here is the output from vmstat 5:
>vmstat 5
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 3936 2980 10568 218856 8 4 11 3 3 9 0 3
10
0 0 0 3936 3096 10580 218728 0 0 0 1 111 30 0 1
99
0 0 0 3936 3092 10584 218728 0 0 0 1 109 26 1 1
98
2 0 0 3936 1676 10564 220012 0 0 287 1 212 137 1 2
97
2 0 0 3936 2628 10480 219084 0 0 646 2 235 130 4 3
93
1 0 0 3936 1652 10488 219428 22 0 727 5 456 522 2 2
96
0 1 0 3936 1708 10480 218776 0 0 1042 4 438 433 0 2
97
1 0 0 3936 2724 10484 218216 28 0 1028 0 488 557 0 3
97
1 0 0 3936 3080 10484 217860 0 0 308 2 297 380 34 16
50
1 0 0 3936 3072 10484 217860 0 0 0 0 103 10 67 33
0
0 0 0 3936 4064 10500 218392 0 0 565 1 411 558 10 5
84
Does this make any sense to you?
Tim
At 12:17 PM 6-2-2001 +0000, you wrote:
>Tim Samshuijzen <[EMAIL PROTECTED]> writes:
>
>> This still does not tell me why the query is amazingly slow.
>
>What else is happening on the system? what does, say, a vmstat 5 give?
>
>
>--
>Dave Hodgkinson, http://www.hodgkinson.org
>Editor-in-chief, The Highway Star http://www.deep-purple.com
> Apache, mod_perl, MySQL, Sybase hired gun for, well, hire
> -----------------------------------------------------------------
>
>---------------------------------------------------------------------
>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
>
>
>
---------------------------------------------------------------------
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