mysql 2gb table limit?

[Keith]

MySQL5 on win2003 - I'm new to mysql, and have a table that has reached

2gb in size and I can't put any more in. I am using innodb and have
set "large table support" to yes and have set max_rows to 5million and
avg_row_length to 6000. To no avail.

Help?

[Bill Karwin]

Re: mysql 2gb table limit?

Keith wrote:

2gb in size and I can't put any more in. I am using innodb

You can allocate more InnoDB tablespace files.

See http://dev.mysql.com/doc/refman/5.0/...-removing.html

Regards,
Bill K.