adspace


How many rows can mysql hold?

Answer Posted / Kushal Verma

MySQL doesn't have a specific limit on the number of rows that can be stored in a table, as it depends on the storage engine and server configuration. However, for InnoDB (the default engine), the maximum number of rows that can be inserted into a table before hitting an overflow error is approximately 8 billion per table, assuming each row takes 100 bytes.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the current mysql version?

1105


How to Change a users password from unix shell.

1223


Which statement is used in a select query for partial matching?

1247


What is current version of mysql?

1085