[MTOS-dev] Feedback requested: changing 'junk_status' on comments and pings

[Hirotaka Ogawa]

On Sat, Apr 12, 2008 at 4:35 AM, Brad Choate <brad at sixapart.com> wrote:
> On Apr 11, 2008, at 12:27 PM, Hirotaka Ogawa wrote:
>
> > Sure!  I can find mt_tbping_blog_stat index by doing "show index from
> > mt_tbping".
> >
> > I think that, filesort is used if the key used to fetch the rows is
> > not the same as the one used in the ORDER BY (e.g. SELECT * FROM t1
> > WHERE key2=constant ORDER BY key1).
> >
> > Is it my misunderstaing?  I'll investigate more about this tomorrow.
> >
>
>  Weird. It's definitely not doing a filesort with my database. My comment
> table has about half a million rows and it isn't using filesort. How large
> is your ping table? Perhaps it thinks it can filesort faster if it's small
> (and maybe in memory)? I'm on MySQL 5.0.51a.

Right.  I can finally reproduce this case by using a blog with 2624 pings.


>
>
>
>  -Brad
>
>  --
>  Brad Choate
>  Engineering Manager, Movable Type, Six Apart, Ltd.
>  http://www.sixapart.com/movabletype/
>  Mobile: (918) 271-0105  -  AIM: bschoate
>
>
>
>
>



-- 
Hirotaka Ogawa
http://twitter.com/ogawa
http://as-is.net/blog/