How big can MySQL DB be..?

P

PHTech

Senior Member
Joined
Aug 21, 2006
Messages
588
Reaction score
0
Location
Witbank
Hi There...

I just want to find out, how big can you make one MySQL database...? For instance: How many tables can you create in one MySQL database, and how many records can it store in one complete DB...?

Thanx....
 
I've made sites before with over 100 tables in a database. I think the limit only lies in the size restrictions of your web hosting provider. If you did make very large mysql databases though, its more likely that the OS will be the problem and not mysql itself.
 
Cool... The Site that I'm doing is hosted on my own server (it mainly a data management intranet site)... So, my 15 tables at this stage is stil a minor to how much tables you can create in one DB with MySQL...? Cool...!

And datawise...? Can MySQL store 1000s of record, or millions in one DB...?
 
Its hard to say without knowing the types of records you are storing, but if they are on average just simple strings then yes, its in the millions. Of course though, things such as your hdd space can limit you. Also, if you have a table with 1 million records on a machine with a 200 Mhz processor and you query it you will see slow performance.
 
Averages for my user databases ( financial sector type information ) is about 1gig...slow as crap to access the bigger ones :P
 
OK Cool...! That about answers the questions I had in mind... Luckily the Server is new, and has alot of resources to handle MySQL... Thanx for your replies...!
 
MyBB uses Mysql. So I would like to think it can be big.
But obviously not compared to SQl Server & Oracle.
 
The digg.com backend is built on mysql...so unless you are planning to take over the world, I reckon you should be fine.
 
seymour7 said:
Also, if you have a table with 1 million records on a machine with a 200 Mhz processor and you query it you will see slow performance.
Click to expand...

:D

Been there, done that with Informix on a 300MHz CPU... luckily the client's systems got upgraded before it got too problematic :)

HavocXphere said:
The digg.com backend is built on mysql...so unless you are planning to take over the world, I reckon you should be fine.
Click to expand...

Wonder what does the Brain (from Pinky and the Brain) use? :D:D:D
 
Cool...

I think then I would be fine with my current project...! Thanx guys...
 
I had a db on M$Sql that was 15GB in size running on a Xeon server :D

Personally, I think there is no limit to the size of db as specified by MySQL or MsSQL but rather limited by the capacity of your available HDD space :D
 
You must log in or register to reply here.
Back
Top
Sign up to the MyBroadband newsletter
X