MySQL size worries

[suicide1405241470 0]

I currently have a 100mb mysql database with my host, but I've got to thinking - is this really enough?I have phpbb running, and most of my site is in the database - username, password, other personal info, and then I have a table with 100 columns to which users add stats for certain computer games and more.The whole database is at 121kb at the moment, and this is without any members (but with the large table described above).The thing is, if I want to upgrade to the highest package, all that is offered is 5x100mb databases, and I can't see how I could store the data I need in the different databases.Will this cause trouble for me in the future if (and hopefully when) my website grows a lot larger? I mean is 100mb big or small for a mysql database?

[r3d1405241470 0]

mysql databases can store data up to 4-8 Gig i thinkin your case: it depends on how you administer your databasesin my old frnds web site, he have stored 200k+ ppl info for 5mb+ for total size of databasesand for an example my apache's log file it has 4531 lines and the file size is just 393kb when i insert into the the mysql table, the msyql table size is 438kb in 4532 rows see just lets assume one line = one info per head/visitor that's means you have 4.5k visitor and may be for 100k users your dabases size will be ranging from 10mb - 20mb, you don't have to worry for your databases size anymore, if you come at this point you should be worrying for your bandwidth

[currahee 0]

MySQL databases do note take up a lot of space at all. I had the same worries as you but later i've found out it doesn't occupy that much space. Of course that's with my phpbb forum. Don't worry too much about it until you start to get a LOT of visitors!

[rhammadkhan 0]

I currently have a 100mb mysql database with my host, but I've got to thinking - is this really enough?

I have phpbb running, and most of my site is in the database - username, password, other personal info, and then I have a table with 100 columns to which users add stats for certain computer games and more.

 

The whole database is at 121kb at the moment, and this is without any members (but with the large table described above).

 

The thing is, if I want to upgrade to the highest package, all that is offered is 5x100mb databases, and I can't see how I could store the data I need in the different databases.

 

Will this cause trouble for me in the future if (and hopefully when) my website grows a lot larger? I mean is 100mb big or small for a mysql database?

<{POST_SNAPBACK}>

Object Oriented Database Management Systems need to be worried about the size, not you! as you are using just an RDBMS system.

.. moreover, everything is text in your databases so there is no need to worry about the database space.

When u'll get to reach the 100MB users .. ofcourse u'll need to get worried about the BANDWIDTH. :-)

adios

[marijnnn 0]

that's a fact. you'll sooner reach your bandwith limit than your database limit.really 100mb is a lot.that's about one hundred million characters. if you have a popular messageboard, you can still delete the oldest topics if you need space... i think phpbb has the option to do this automaticly.

[Trekkie101 0]

Yes it is called pruning and it is in the Forum management in the admin panel, plus 100MB is quite a lot, some size of site it must be.