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

[Brad Choate]

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.

-Brad

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