How many rows can mysql hold?



How many rows can mysql hold?..

Answer / 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

More MySQL Interview Questions

What is mysql connector used for?

1 Answers  


Where does mysql store data?

1 Answers  


What are procedures in mysql? Explain

1 Answers  


How do you determine the location of mysql data directory?

1 Answers  


What is horizontally scalable?

1 Answers  


What is difference between oracle and mysql?

1 Answers  


Is number a datatype in mysql?

1 Answers  


write a c++ program to add a user to mysql.the user should be permitted to only "insert" into the given database

3 Answers   Infosys, Webyog,


Is mysqli deprecated?

1 Answers  


Explain federated tables?

3 Answers   Tech Mahindra,


Is sqlite faster than mysql?

1 Answers  


What is the difference between mysql and oracle?

1 Answers  


Categories