Jump to content
xisto Community
.:Brian:.

Database Size? So how big is everybodys MySQL database?

Recommended Posts

Well I know that MySQL databases can get rather big, so I was just wondering how big everybodies databases were? Do you have really big ones, or are they relatively small? Also what do you store in them? (just text, or binary data as well)

Share this post


Link to post
Share on other sites

Mostly text for me I would say.Ahhhh, last time I checked my DB(s) were reasonably small, but have been growing little by little overtime of course. I use a lot of custom made stuff so it's quite lean.

Share this post


Link to post
Share on other sites

I'm writing software for customers, so they tends to stored quite a lot of different thing.For the management system, it stores transactions in decimal, customer database in text. That's still quite small. For a year already, and it's still less than 100MB in total, for 53 tables.For the media system, it's rather bigger. The worse is the table which i use to pass live screen capture from client to server, stored as binary. With frequent screen capture, it can reach up to 1GB per day, so have to clean every day, :P For the data acquisition system, it's mainly decimal and double. Will take up 10MB per day.

Share this post


Link to post
Share on other sites

Mine are hovering around 50mb, nothing too intensive just the forum database and the site database for storing accounts and news posts, small size means easier to backup (I have a script running that emails me the backups). I always prune what i can to keep the size down for easier storage. Nearly every entry is text.In my experience though having massive databases doesn't affect performance too much, a friend i know has a forum database that has reached 1gb+ and the site still runs smooth. Could just be the server it's running on though.-HellFire

Share this post


Link to post
Share on other sites

Hellfire121, is that using like a pre-made community board type software? or a low end custom job.I'm not sure if mine would take up a lot, if the forum was considerably large and filled up.I don't think I'll test it out either lol, unless locally when I finally have the software all setup for it, I have been lazy fixing up all my programs etc for this fresh installation, now that I have new hardware.

Share this post


Link to post
Share on other sites

Well I know that MySQL databases can get rather big, so I was just wondering how big everybodies databases were? Do you have really big ones, or are they relatively small? Also what do you store in them? (just text, or binary data as well)

In my case my databases are relatively small because i try to store just text, when i need to store binary data what i do is to simply store its location on the file system.
Best regards,

Share this post


Link to post
Share on other sites

So, none of you has seen mysql databases as big as the Oracle databases, which currtly go to some hundreds of higs, and sometimes several terabytes.

Well, you said it at the wrong place. If an admin who handle huge databases, be it MySQL or any other database, do you think he would have joint this forum? What you see here only represent a small community of netizen. So you cannot imply that there's actually no MySQL database that could go to some hundreds of "higs" or terabytes. :P

Share this post


Link to post
Share on other sites

Well, you said it at the wrong place. If an admin who handle huge databases, be it MySQL or any other database, do you think he would have joint this forum? What you see here only represent a small community of netizen. So you cannot imply that there's actually no MySQL database that could go to some hundreds of "higs" or terabytes. :P

That's right, especially if the MySql database stores images or when it uses the spatial features that MySql has. Take a look to the MySql Customers page.
Best regards,

Share this post


Link to post
Share on other sites

I try to store pure text with some html stuff where I can not use it on a script file, but I also written some bbcode for myself on my cms and of course I store numbers etc. For binary data, I am in no need to store such data in a database, placing them as files is just fine for me, my local database takes over 40 mb in MyISAM, later I will change to InnoDB, but the current one online ~2-3 MB not more..

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...

Important Information

Terms of Use | Privacy Policy | Guidelines | We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.