My account: Login | Sign Up

Need help with under-performing query: using where, temporary and filesort | Thread profile

Thread profile page for "Need help with under-performing query: using where, temporary and filesort" on http://www.mysqlperformanceblog.com. This report page is a snippet summary view from a single thread "Need help with under-performing query: using where, temporary and filesort", located on the Message Board at http://www.mysqlperformanceblog.com. This thread profile page shows the thread statistics for: Total Authors, Total Thread Posts, and Thread Activity, which are reported in a table below. Additional thread profile information is also shown in the following ways:

1) Top Contributing Authors
2) Related Threads on "eBay Auctions"
3) Related Threads on Other Sites

Warning: These statistics are generated using 'best efforts' and can experience delays and reporting errors at times. Please note that such statistics do not constitute a thread's popularity and/or exact posting volumes at any given reporting period.

Title:	Need help with under-performing query: using where, temporary and filesort
Site:	MySQL Performance
Forum:	MySQL
Total authors:	3 authors
Total thread posts:	3 posts
Thread activity:	no new posts during last week
Domain info for:	mysqlperformanceblog.com

Thread posts in Need help with under-performing query: using where, temporary and filesort:

Need help with under-performing query: using where, temporary and filesort

Started 7 months, 4 weeks ago (2008-11-13 05:23:00) by sameerpanjwani

This is the table: CREATE TABLE common_categories ( id int(11) NOT NULL auto_increment, category varchar(255) NOT NULL default '', category_parent_id int(11) NOT NULL default '0', category_count varchar(255) NOT NULL default '', parent_category varchar(255) NOT NULL default '', visibility enum('Visible','Invisible') NOT NULL default 'Visible', related_words ...

Size: 1,463 bytes
Customize: