galvin Posted October 15, 2009 Share Posted October 15, 2009 How many rows can a MySQL database table hold? Is it unlimited? I have a site that has approximately 1,000 entries (i.e. rows) being put into one of my MySQL tables everyday. So this will obviously add up. Say this keeps up for a year, I will have over 350,000 rows in that one table and counting. Will performance be affected by having that many rows? Or can MySQL handle a lot more rows than I'll ever have to worry about it? Quote Link to comment Share on other sites More sharing options...
trq Posted October 15, 2009 Share Posted October 15, 2009 How many rows can a MySQL database table hold? Is it unlimited? It is limited by the size of your filesystem. Quote Link to comment Share on other sites More sharing options...
galvin Posted October 15, 2009 Author Share Posted October 15, 2009 Can yo be so kind as to tell me how to check the size of my filesystem? Or if its complicated, maybe direct me to a tutorial where i could learn about it. Thanks! Quote Link to comment Share on other sites More sharing options...
trq Posted October 15, 2009 Share Posted October 15, 2009 Your filesystem size relates to your harddrive, how big is that? Quote Link to comment Share on other sites More sharing options...
galvin Posted October 16, 2009 Author Share Posted October 16, 2009 I have my site hosted on HostGator, so I'm not sure how big the harddrive is. I guess I should look into that Quote Link to comment Share on other sites More sharing options...
GoneNowBye Posted October 17, 2009 Share Posted October 17, 2009 The absolute image (irrespective of row size - and thus file system) is the limit of the primary key. The Archive format has no primary key, consiquently you may not update records, only add and select (not sure on delete) but it presents near unlimited (if not unlimited) file storage. Also MySQL does split files when they get too large, there is an option for it in the mysql gui tools administrator, but it only apears when it is connected to localhost. (not me being weird, its the server variable page, where you set its starting parameters) if you have a primary key of an integer, i belive the limit is 65365 rows.... i'm really not sure. but the hard limit is the maxium value of the primary key. Hope i helped, pretty sure its all on the MySQL website, just google "mysql integer" or something. if you need something really big and intger use the type bigint its like twice the size (has a 20 in brackets, does that mean 2^20 or 20 digits?) mediumint bout half of integer tinyint ... really small. Goodluck. Quote Link to comment Share on other sites More sharing options...
fenway Posted October 17, 2009 Share Posted October 17, 2009 4GB is a reasonable maximum to assume... but I wouldn't worry about it. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.