Re: large multiple table update taking a very long time, help!

[Jason Hines]

mysql> show table status like 'table1'\G
*************************** 1. row ***************************
           Name: table1
         Engine: MyISAM
        Version: 10
     Row_format: Dynamic
           Rows: 70143307
 Avg_row_length: 127
    Data_length: 8962881892
Max_data_length: 281474976710655
   Index_length: 9923821568
      Data_free: 0
 Auto_increment: 70143308
    Create_time: 2009-04-07 17:13:56
    Update_time: 2009-04-07 22:34:38
     Check_time: 2009-04-07 18:00:19
      Collation: utf8_unicode_ci
       Checksum: NULL
 Create_options: 
        Comment: 
1 row in set (0.00 sec)

mysql> show table status like 'table2'\G
*************************** 1. row ***************************
           Name: table2
         Engine: MyISAM
        Version: 10
     Row_format: Fixed
           Rows: 70143307
 Avg_row_length: 13
    Data_length: 911862991
Max_data_length: 3659174697238527
   Index_length: 2149535744
      Data_free: 0
 Auto_increment: 70143308
    Create_time: 2009-04-07 20:01:26
    Update_time: 2009-04-07 20:38:57
     Check_time: 2009-04-07 20:41:14
      Collation: utf8_unicode_ci
       Checksum: NULL
 Create_options: 
        Comment: 
1 row in set (0.00 sec)

mysql> show table status like 'table3'\G
*************************** 1. row ***************************
           Name: table3
         Engine: MyISAM
        Version: 10
     Row_format: Dynamic
           Rows: 70143307
 Avg_row_length: 205
    Data_length: 14427407264
Max_data_length: 281474976710655
   Index_length: 7575571456
      Data_free: 0
 Auto_increment: 70143308
    Create_time: 2009-04-16 22:42:58
    Update_time: 2009-04-18 23:38:34
     Check_time: 2009-04-17 00:39:17
      Collation: utf8_unicode_ci
       Checksum: NULL
 Create_options: 
        Comment: 
1 row in set (0.00 sec)

mysql> show table status like 'table4'\G
*************************** 1. row ***************************
           Name: table4
         Engine: MyISAM
        Version: 10
     Row_format: Fixed
           Rows: 70143307
 Avg_row_length: 13
    Data_length: 911862991
Max_data_length: 3659174697238527
   Index_length: 2149609472
      Data_free: 0
 Auto_increment: 70143308
    Create_time: 2009-04-14 13:01:17
    Update_time: 2009-04-14 14:01:24
     Check_time: 2009-04-14 14:03:17
      Collation: utf8_unicode_ci
       Checksum: NULL
 Create_options: 
        Comment: 
1 row in set (0.00 sec)