GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

Max_data_length is Zero

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Max_data_length is Zero

    Hi All,


    show table status\G*************************** 1. row *************************** Name: name_table Engine: MyISAM Version: 10 Row_format: Dynamic Rows: 259956366 Avg_row_length: 128 Data_length: 33460714548Max_data_length: 0 Index_length: 44122680320 Data_free: 3640 Auto_increment: NULL Create_time: 2008-10-06 14:59:57 Update_time: 2008-10-16 12:19:30 Check_time: 2008-10-06 15:32:38 Collation: latin1_swedish_ci Checksum: NULL Create_options: partitioned Comment:


    I have almost 260 millions of records with 73 GB disk capacity. What does actually "Max_data_length is zero" mean? How can I increase that?

    Thanks,

  • #2
    It means you didn't set a max_data_length explicitly when you created the table. This controls the size of the internal pointers for row offsets, etc.

    Comment

    Working...
    X