That should decline significantly.
What's the value of key_buffer_size? It should generally be 20% of _available_
RAM (for MyISAM usage).
-Original Message-
From: James W. McNeely [mailto:jmcne...@nwrads.com]
Sent: Wednesday, November 14, 2012 3:48 PM
To: mysql@lists.mysql.com
Subject: Re
> Note the huge estimated number of rows. That should decline significantly.
>
> What's the value of key_buffer_size? It should generally be 20% of
> _available_ RAM (for MyISAM usage).
>
>> -Original Message-
>> From: James W. McNeely [mail
#x27;s the value of key_buffer_size? It should generally be 20% of _available_
RAM (for MyISAM usage).
> -Original Message-
> From: James W. McNeely [mailto:jmcne...@nwrads.com]
> Sent: Wednesday, November 14, 2012 3:48 PM
> To: mysql@lists.mysql.com
> Subject: Re: query
ProcModeCode, dateexam) -- in that order
> (I can't predict which index it would use.)
>
> Are IdAppt the same datatype and collation in each table?
>
>> -Original Message-
>> From: James W. McNeely [mailto:jmcne...@nwrads.com]
>> Sent: Wednesday, Novembe
James W. McNeely [mailto:jmcne...@nwrads.com]
> Sent: Wednesday, November 14, 2012 2:34 PM
> To: mysql@lists.mysql.com
> Subject: query tuning
>
> I have a query I'm having trouble with. If do this query which is DATE plus
> ProcModecode, it is very fast:
>
> SELECT e.z
I have a query I'm having trouble with. If do this query which is DATE plus
ProcModecode, it is very fast:
SELECT e.zzk FROM exams e
-- JOIN Appt_ a ON e.IdAppt = a.IdAppt
-- JOIN Affil_ af ON a.IdAffil_primary = af.IdAffil
WHERE e.dateexam >= '2012-09-01' AND e.dateexam <= '2012-09-30'
AND e
Hi All,
I am using mysql 5.0.41, on debian, with 8 CPU, 8 GB RAM.
I am having the below query with explain plan
select * from (select * from (select truncate0.34*LOG(10,((NO_BIDS +
1)/(TOTAL_QTY
+ 1 + (0.24*LOG(10,100*( (SOLD_QTY + 1) / (TOTAL_QTY + 1 + 0.14*(1
/ LOG(10, 10 + TOTAL_Q