ked slowness.
This appears to be a semi-bug, since its only when the erroneous 'use
index(type)' (a bug in my query-creation routine) appears, it uses the
'created' index. Removing the 'use index(type)' part causes it to
correctly choose the 'mid' index ins
Hi Kevin,
- Original Message -
From: "Kevin"
Sent: Monday, September 29, 2003 2:21 PM
Subject: slow 'sending data' phase
> I've fixed my swapping issues, but the system continues to get stuck
in
> a 'sending data' phase from time to time.
>
&
| eq_ref | PRIMARY | PRIMARY | 3 | poems.mid |
> 1 |
There are 272,000 rows returned... This slow 'sending data' phase only
happens under decently high load... But my impression of this query was
that it should be relatively instantm since its only loading 30 rows
On Mon, 29 Sep 2003, Kevin wrote:
> I've fixed my swapping issues, but the system continues to get stuck in
> a 'sending data' phase from time to time.
>
> With mod_perl + mysql, this phase SHOULD be when mysql collects the rows
> (after sorting, etc) and sends them to the perl handler for proces
I've fixed my swapping issues, but the system continues to get stuck in
a 'sending data' phase from time to time.
With mod_perl + mysql, this phase SHOULD be when mysql collects the rows
(after sorting, etc) and sends them to the perl handler for processing.
Any ideas why this phase would ever be
