sheeri kritzer wrote:
On 11/18/05, Michael Stassen <[EMAIL PROTECTED]> wrote:
Sheeri,
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!
-Sheeri
Hi There,
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.
Simon
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]