es22 wrote:
How many rows can mysql handle in one table?
You will propably run out of free disk space before encountering this
limit. I'm not even sure if there is any limit how many rows you can
have. Anyway, the maximum table size is somewhat the same as what is the
largest file your os can handle. (2GB-4GB perhaps?)
Basicly you can find out how many only by testing. Create a script that
adds dump data into MySQL which has the same data types (and sizes)
which you are planning to use.
Actually, against my previous suggestion, you might need to do it with
many-tables-style, if the table size on disk grows too big for the os to
handle. Another solution would be to delete old data, or transfer it to
another file(s).
My guess would be that it can hold at least about 10-20 million rows (If
os limits the file size to 2GB). But this is just a guess, the real
value can be very different.
http://dev.mysql.com/doc/mysql/en/Table_size.html