Re: How to get rid of 'filesort'?

[Ruslan Osmanov]

Here are table statuses:

mysql> SHOW TABLE STATUS like 's3_shop_product'\G
*************************** 1. row ***************************
          Name: s3_shop_product
        Engine: MyISAM
       Version: 10
    Row_format: Dynamic
          Rows: 604332
 Avg_row_length: 729
   Data_length: 440590696
Max_data_length: 281474976710655
  Index_length: 90487808
     Data_free: 0
 Auto_increment: 1335943
   Create_time: 2009-12-30 15:40:16
   Update_time: 2010-03-02 10:23:45
    Check_time: 2010-02-16 01:18:39
     Collation: utf8_general_ci
      Checksum: NULL
 Create_options:
       Comment:
1 row in set (0.01 sec)

mysql> SHOW TABLE STATUS like 's3_folder'\G
*************************** 1. row ***************************
          Name: s3_folder
        Engine: MyISAM
       Version: 10
    Row_format: Dynamic
          Rows: 375774
 Avg_row_length: 49
   Data_length: 18543684
Max_data_length: 281474976710655
  Index_length: 13281280
     Data_free: 1216
 Auto_increment: 885358
   Create_time: 2009-09-18 15:49:40
   Update_time: 2010-03-02 10:25:05
    Check_time: 2010-02-16 01:15:01
     Collation: utf8_general_ci
      Checksum: NULL
 Create_options:
       Comment:
1 row in set (0.00 sec)

mysql> SHOW TABLE STATUS like 's3_folder_item'\G
*************************** 1. row ***************************
          Name: s3_folder_item
        Engine: MyISAM
       Version: 10
    Row_format: Fixed
          Rows: 1142302
 Avg_row_length: 11
   Data_length: 12565322
Max_data_length: 3096224743817215
  Index_length: 35264512
     Data_free: 0
 Auto_increment: 885352
   Create_time: 2008-03-02 01:38:14
   Update_time: 2010-03-02 10:22:26
    Check_time: 2010-02-16 01:15:04
     Collation: utf8_general_ci
      Checksum: NULL
 Create_options:
       Comment:
1 row in set (0.00 sec)

FULLTEXT keys are used in search. Just no sense here.
And yes, "/*...*/" implies about all the rest product fields.