MySQL Forums
Forum List  »  Optimizer & Parser

Re: How to get rid of 'filesort'?
Posted by: Ruslan Osmanov
Date: March 02, 2010 02:34AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
3774
February 28, 2010 08:51AM
1818
March 01, 2010 04:51PM
1949
March 01, 2010 11:27PM
Re: How to get rid of 'filesort'?
1781
March 02, 2010 02:34AM
1622
March 02, 2010 04:56PM


Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.