Page 1 of 1
MySQL Question
Posted: Wed Jun 09, 2004 4:01 pm
by Base
How many rows can a MySQL table hold? Is their a limit?
Posted: Wed Jun 09, 2004 4:09 pm
by feyd
there is no limit, as far as I know. If there is a limit, it's extremely large.
Posted: Wed Jun 09, 2004 4:13 pm
by tim
look at the number of people registered for this forum
thats a large number, n i'm sure (not seeing the code for phpbb) each one is a row in a SQL table.

Posted: Wed Jun 09, 2004 4:14 pm
by Base
OK thanks, I use mysql to keep track of logs into my website and I'm already up to 1400. I don't want to lose any data.
Thanks Everyone.

Posted: Wed Jun 09, 2004 4:16 pm
by feyd
I know for a fact, it can store more that 150 million rows in any given table.. so it's substantial..

Posted: Wed Jun 09, 2004 4:40 pm
by Joe
Yeah but remember how much storage capacity you have available on your site!
Posted: Wed Jun 09, 2004 7:17 pm
by lostboy
Its more the storage that you have available on the filesystem...Some file systems limit your files to 2Gb..others no limit...there are also many options in adminning the DB as to where you place files etc