Bug #5557 How to increase table maximum capacity
Submitted: 14 Sep 2004 5:57 Modified: 20 Oct 2004 8:25
Reporter: Sivan Narayana Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: MyISAM storage engine Severity:S4 (Feature request)
Version:MySQL 3.23.42 OS:Linux (Linux 7)
Assigned to: CPU Architecture:Any

[14 Sep 2004 5:57] Sivan Narayana
Description:
Hi All,

We are implementing a larger database driven application.For that we need to store bundles of data every day (Approximately 1 lac records are adding to database per every day).

We are using one table for reporting purpose.We are generating all types of report by using same table.We will drag the data for min 30 days to one year.So there will be so much data to get from database table.

Right now the capacity of the table became 4.3 GB.We had only 5 months data in it.We are not getting some reports (Which include much data retrieval).As we read some manuals..there it seems maximum capacity of the table is 4GB.

My question is , is there anyway to increase table maximum capacity.If so, please let me know.

How to repeat:
Hi All,

We are implementing a larger database driven application.For that we need to store bundles of data every day (Approximately 1 lac records are adding to database per every day).

We are using one table for reporting purpose.We are generating all types of report by using same table.We will drag the data for min 30 days to one year.So there will be so much data to get from database table.

Right now the capacity of the table became 4.3 GB.We had only 5 months data in it.We are not getting some reports (Which include much data retrieval).As we read some manuals..there it seems maximum capacity of the table is 4GB.

My question is , is there anyway to increase table maximum capacity.If so, please let me know.
[19 Oct 2004 18:19] Jeremy Tinley
http://dev.mysql.com/doc/mysql/en/CREATE_TABLE.html

See the comments on:
AVG_ROW_LENGTH 
MAX_ROWS 

Just alter your table to decrease the average row length or increase the maximum number of rows.

This is a topic better for the mailing list, not a bug tracking system.
[20 Oct 2004 8:25] Sergei Golubchik
Sorry, but the bug system is not the appropriate forum for asking
support questions. Your problem is not the result of a bug.
For a list of more appropriate places to ask for help using MySQL
products, please visit http://www.mysql.com/support/

Thank you for your interest in MySQL.