Database size...

[hjmaier]

http://www.midgard.forum.de

1.733 members
8.516 threads
633.240 posts

database is about 800 MB, Attachments are 141MB

Best regards
hj

[Vtec44]

if you do an SQL dump, the size of that text file is basically your database size. My SQL dump is about 70 mb right now, that's not including the php files. The database has a lot of info, including configuration, user info, posts info/text, thread info, PM text, style, etc. THe size of the database varies, as mentioned above, due to the amount of posts, users, PMs, and many other variables.

[conqsoft]

I don't know what you're asking. The datsbase can contain attachments, unless you use the option to move them to the file system, but they default to the database. Same with Avatars and Profile pictures.

[mikecp421]

well the database just includes the user info and post info right? Minus all the php files and attachments, wouldn't the database be much smaller?

[conqsoft]

My actual database is about 400megs, as noted above. It will vary depending on how many users/posts/threads/etc that you have.

[mikecp421]

the actual database.

[conqsoft]

What should only be about 20megs? My site is over 4gigs, plus the mySQL database.

[mikecp421]

so then it should only be about 20 megs right?

[conqsoft]

but shouldn't the database size not include the size of the php and html files?

Correct, it does not. That is only the database. Your web files are a totally separate thing.

[mikecp421]

but shouldn't the database size not include the size of the php and html files?

[TCM]

Threads: 5,628
Posts: 130,957
Members: 482
Data Usage: 81.66 MB
Index Usage: 28.82 MB
Attachment Usage: 197.31 MB
Avatar Usage: 1.48 MB
Profile Picture Usage: 1.39 MB

[Vtec44]

Data Usage 46.81 MB
Index Usage 16.30 MB
Members: 1,028
Threads: 4,052
Posts: 76,162

[conqsoft]

~332,000 Posts
~6,700 Members

Data Usage 214.29 MB
Index Usage 158.62 MB

Attachment Usage 2.26 GB (File System)
Avatar Usage 1.46 MB (File System)
Profile Picture Usage 408.7 KB (File System)

[Reeve of Shinra]

https://www.shinraonline.com

DB size: 718.2 MB
Posts: 1,143,251 (+ galleries, journals, and other stuff)
Avatars and attachments are stored on the server.

I could prune this but I dont have a specific need to.

[Floris]

My database is 200mb big, including attachments, and I have over 100,000 posts.