It may not be the big-table option you are looking for. MySQL defaults to a 4GB table limit based on calculation. From CREATE TABLE
in the manual, under AVG_ROW_LENGTH.
MySQL uses the product of the MAX_ROWS and AVG_ROW_LENGTH options to decide how big the resulting table is. If you do not specify
either option, the maximum size for a table is 4GB.
Here are some links to help clarify the situation:
http://jeremy.zawodny.com/blog/archives/000796.html
http://dev.mysql.com/doc/refman/5.0/en/full-table.html
Most likely you'll just need to run a simple ALTER TABLE command to set the max_rows, and then wait a while for mysql to perform the
alteration.
----- Original Message -----
From: "Halid Faith" <[EMAIL PROTECTED]>
To: <mysql@lists.mysql.com>
Sent: Wednesday, June 28, 2006 8:46 AM
Subject: How can I enable big-table option ?
Hello
I use mysql 4.1. I have a big table which has larger than 4 Gbyte. Therefore I get an error "table is full". How can I enable
big-table ?
Thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
