maria-developers team mailing list archive
-
maria-developers team
-
Mailing list archive
-
Message #03860
Re: Optimization about count(*) of mysql 5.1.38
Hi, Lichao!
On Jan 21, Lichao Xie wrote:
> >
> > No, there is no such a API. The best you can do in your engine is to pay
> > attention to TABLE::read_set and HA_EXTRA_KEYREAD which will allow you
> > to reduce the amount of work you do per key. But still it will be the
> > complete range scan - from the lower to the upper boundary or the range.
>
> Yes. But I want to know that with this use is based on what consideration?
> the lock or something else?
I am sorry, I cannot understand you.
Could you try to rephrase your question please?
Regards,
Sergei
Follow ups
References