Maximum Row in DBMS

Question

Is there any limit to maximum row of table in DBMS (specially MySQL)?

I want create table for saving logfile and it's row increase so fast I want know what shoud I do to prevent any problem.

Answer 1

You should periodically move log rows out to a historical database for data mining and purge them from the transactional database. It's a common practice.

Answer 2

I don't think there is an official limit, it will depend on maximum index sizes and filesystem restrictions.

From mySQL 5.0 Features:

Support for large databases. We use MySQL Server with databases that contain 50 million records. We also know of users who use MySQL Server with 200,000 tables and about 5,000,000,000 rows.

Answer 3

There's probably some sort of limitation, dependent on the engine used and the table structure. I've got a table with appx 45 million entries in a database I administrate, I've heard of (much) higher numbers.