sheeri kritzer wrote:
> On 11/18/05, Michael Stassen <Michael.Stassen@stripped> wrote:
>>I think you've missed the point. The 4Gb limit is in mysql, not the filesystem.
>> Mysql effectively doesn't limit tablesize, but the *default* pointer size
>>limits you to a max of about 4Gb in a MyISAM table. To have a larger table, you
>>need to tell mysql that it needs to use a larger pointer for that table, either
>>at table creation, or with an ALTER TABLE such as the one Simon is proposing to
>>run. See the last half of
>><http://dev.mysql.com/doc/refman/5.0/en/table-size.html> for more.
> You're right, I did miss the point. Thanx for pointing this out; I
> wasn't sure why he was asking the question!
Im asking the question because :) ... I am running dbmail, which is a
mail server that stores its mail in mysql. The table where all the mail
is is getting nearly to 4GB, which is its Max_data_length limit:
show table status from dbmail like 'dbmail_messageblks';
gives Data_length = 3204062980 and Max_data_length = 4294967295
Im wanting a simple way of increasing the size of Max_data_length in the
shortest amount of time as it is a live mail server.