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)

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.

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,

For the data acquisition system, it's mainly decimal and double. Will take up 10MB per day.

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

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.

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,

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.

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,

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..