# Max\_data\_length is Zero

**URL:** <https://forums.percona.com/t/max-data-length-is-zero/964>\
**Category:** Other MySQL® Questions\
**Created:** [October 16, 2008, 1:33am UTC](https://forums.percona.com/t/max-data-length-is-zero/964 "2008-10-16T01:33:07Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![cowboymathu](https://avatars.discourse-cdn.com/v4/letter/c/bbce88/32.png) [@cowboymathu](https://forums.percona.com/u/cowboymathu)\
**Post date:** [October 16, 2008, 1:33am UTC](https://forums.percona.com/t/max-data-length-is-zero/964/1 "2008-10-16T01:33:07Z")

</div>

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,

---

<div class="post-metadata">

**Author:** ![xaprb](https://avatars.discourse-cdn.com/v4/letter/x/49beb7/32.png) [@xaprb](https://forums.percona.com/u/xaprb)\
**Post date:** [December 25, 2009, 10:45am UTC](https://forums.percona.com/t/max-data-length-is-zero/964/2 "2009-12-25T10:45:21Z")

</div>

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.