-3

What to do if my mysql database table total rows exceeds 65535?What type of database can i use inorder to store more data?

user1673591
  • 79
  • 2
  • 7
  • 2
    MySQL doesn't limit the number of rows to 65535. There's a limit on _row size_ of 65535. – Ted Hopp Sep 17 '14 at 17:32
  • This is no builtin limit of MySQL. You can store millions of rows in just one table. – VMai Sep 17 '14 at 17:32
  • how much rows a single table can hold? – user1673591 Sep 17 '14 at 17:33
  • @user1673591 see this: http://dev.mysql.com/doc/refman/5.0/en/table-size-limit.html – D-side Sep 17 '14 at 17:34
  • 1
    See [this answer](http://stackoverflow.com/a/2716470/535871) for details on how many rows you can have. It depends on your table engine. As @D-side points out, there are also limits on the total size of the table (independent of the number of rows). – Ted Hopp Sep 17 '14 at 17:34
  • 1
    I didn't downvote (although I'm thinking about it), but my guess is that it is because the question "does not show any research effort". (Hover over the downvote arrow to see a brief summary of downvoting reasons.) All the info posted here is easily found by searching the web for "mysql 65535". Also, the comment thread has completely changed the question, which makes your question either "unclear" or "not useful" (other criterion for downvoting). – Ted Hopp Sep 17 '14 at 17:40
  • @user1673591 First of all, this question contains incorrect information, and thus is misleading. Moreover, you didn't supply any information of what you've found youself before posting a question, you could have found the link I've given in like **10 seconds**. We solve questions collaboratively and we expect you to collaborate as well, since it's your question. – D-side Sep 17 '14 at 17:53
  • @user1673591, are you confusing the terms *rows* and *columns*? – Bill Karwin Sep 17 '14 at 17:57
  • check Question : http://stackoverflow.com/questions/2716232/maximum-number-of-records-in-a-mysql-database-table – Smoke Aug 26 '15 at 09:56

1 Answers1

1

As the documentation says

The effective maximum table size for MySQL databases is usually determined by operating system constraints on file sizes, not by MySQL internal limits.

As @ D-side points out the number of rows depends on the engines used.

For example In InnoDB, with a limit on table size of 64 terabytes and a MySQL row-size limit of 65,535 there can be 1,073,741,824 rows.

Please check here and herefor more details..Hope it helps

Community
  • 1
  • 1
Avinash Babu
  • 6,171
  • 3
  • 21
  • 26