List:General Discussion« Previous MessageNext Message »
From:Jim Lyons Date:June 25 2010 11:31am
Subject:Re: Altering database size to add more space
View as plain text  
I think you're confusing table size with data base size.  The original post
grouped by schema so it appears the question concerns database size.  I
don't believe mysql imposes any limits on that.  Is there a limit on the
number of tables you can have in a schema imposed by mysql?


On Fri, Jun 25, 2010 at 4:13 AM, Johan De Meersman <vegivamp@stripped>wrote:

> On Fri, Jun 25, 2010 at 7:11 AM, Prabhat Kumar <aim.prabhat@stripped>wrote:
>
>> In case MyISAM it will grow up to space on your data drive or the Max size
>> of file limited by OS..
>>
>
>
> Not entirely correct. There is some kind of limit to a MyISAM file that has
> to do with pointer size - I've encountered it several years ago.
>
> You shouldn't be encountering it, in most circumstances, but that's what
> the max_data_length column in *show table status* is about.
>
> Before 5.0.6, the default max datafile size was 4G, but that's been upped
> to 256T now.
>
> If you're really running in to this have a look at the various advanced
> options for create/alter table, like avg_row_length and max_rows; as well as
> the variable myisam_data_pointer_size.
>
> Now what Sarkis is running into, is more of a logical error: data_free does
> not tell you how much free space there is *for data*, but how much free
> space there is *in the existing datafile*. That is, it really tells you how
> much space in your file has become free by deleting rows et al. This also
> explains why it's always 0 for InnoDB tables :-)
>
>
> --
> Bier met grenadyn
> Is als mosterd by den wyn
> Sy die't drinkt, is eene kwezel
> Hy die't drinkt, is ras een ezel
>



-- 
Jim Lyons
Web developer / Database administrator
http://www.weblyons.com

Thread
Altering database size to add more spaceSarkis Karayan24 Jun
  • Re: Altering database size to add more spaceAnanda Kumar24 Jun
  • Re: Altering database size to add more spaceJim Lyons24 Jun
    • Re: Altering database size to add more spacePrabhat Kumar25 Jun
      • Re: Altering database size to add more spaceJohan De Meersman25 Jun
        • Re: Altering database size to add more spaceJim Lyons25 Jun
          • Re: Altering database size to add more spaceCarsten Pedersen25 Jun