How big is your SQL-Database?

[Duke Of Lion]

I am just wondering when my IP will charge me more because of exceeding my 25 MB limit. So here's my question to you....

[afterlab]

More than 20MB here.. :o

[Hoffi]

without Search-Index we have about 23Megs... with Search Index about 90!

[Lesane]

With attachments my db was almost 80mb, now i deleted it and my db is now 42mb.

[heretic]

I think mine's about 30MB now

[DarkReaper]

http://www.seriouscommunity.com


access 90 7.1 KB
adminlog 2,442 154.7 KB
adminutil 1 2.0 KB
announcement 9 11.7 KB
attachment 331 12.7 MB
avatar 150 32.0 KB
bbcode 22 4.7 KB
calendar_events 6 5.9 KB
customavatar 132 510.0 KB
faq 4 2.1 KB
faqentries 33 33.1 KB
forum 59 10.2 KB
forumpermission 148 10.6 KB
icon 14 4.8 KB
moderator 48 5.0 KB
modlog 7 1.4 KB
namelogs 0 1.0 KB
poll 59 11.8 KB
pollvote 1,174 53.1 KB
post 86,663 31.2 MB
privatemessage 1,044 730.1 KB
profilefield 4 3.2 KB
replacement 135 9.6 KB
replacementset 5 3.2 KB
search 1,040 1.3 MB
searchindex 1,325,669 32.5 MB
session 47 1.5 MB
setting 175 45.8 KB
settinggroup 32 5.3 KB
smilie 69 16.4 KB
style 5 3.3 KB
subscribeforum 30 3.4 KB
subscribethread 569 23.3 KB
template 560 606.1 KB
templateset 5 3.2 KB
thread 7,708 946.4 KB
threadrate 82 4.6 KB
user 5,311 1.2 MB
useractivation 101 6.5 KB
userfield 5,315 5.1 MB
usergroup 10 5.6 KB
usertitle 6 3.5 KB
vbstats_counter 19 1.5 KB
vbstats_countries 247 10.7 KB
vbstats_date 25 1.9 KB
vbstats_exclude 5 5.1 KB
vbstats_options 1 1.1 KB
vbstats_referrer 186 10.9 KB
word 122,201 9.0 MB
49 table(s) Sum 1,561,998 97.8 MB


I went ahead and voted over 100, because in a few days it will be :)

[armond_tamzaria]

189.7 MB

[drumsy]

How does one find this information out?

[armond_tamzaria]

Originally posted by drumsy
How does one find this information out?

Option 1: phpmyadmin
Option 2: Backup your DB through your admin CP and take a look at the file size

[drumsy]

Originally posted by armond_tamzaria


Option 1: phpmyadmin
Option 2: Backup your DB through your admin CP and take a look at the file size

Thanks, 10+Mb!

[GameCrash]

This is not correct, the dump will be much bigger than what you see in phpMyAdmin as there is much more text (INSERT INTO etc.) in the dump ;)

phpMyAdmin says 35 megs for my database.

[Wayne Luke]

Over 300 Megabytes and only 9 gigabytes left on the database partition.

[sphinx]

21 meg here

[mjames]

53 MB.

[snakes1100]

100mb here thru a vb backup.

[N9ne]

Only 3.85mb :)

I am just wondering, but if you all were to backup your database, it would take a very long time! Especially those who have over 100mb, especially with a 56k connection; :ermm:

[NoFixxxer]

117MB At the moment, Been using VBulletin since Feb. 13'th 2002 :D

[hypedave]

I db is 9.50MB :alien:

[ethank]

Action
access 5.4 KB
adminlog 744.1 KB
adminutil 2.0 KB
announcement 7.6 KB
attachment 770.1 MB
avatar 11.4 KB
bbcode 3.8 KB
c_ban_users 1.0 KB
c_messages 97.8 KB
c_reg_users 1.1 KB
c_users 2.0 KB
calendar_events 12.5 KB
current_location 1.5 MB
customavatar 1.6 MB
forum 133.8 KB
forumpermission 5.3 KB
icon 3.4 KB
location 1.5 MB
map_data 4.2 KB
markread 300.9 KB
moderator 5.2 KB
poll 269.9 KB
pollvote 1.4 MB
post 155.6 MB
privatemessage 52.0 MB
profilefield 6.9 KB
replacement 7.6 KB
replacementset 3.0 KB
room 464.0 KB
room_menu 4.4 KB
search 4.9 MB
searchindex 153.6 MB
session 1.5 MB
setting 45.7 KB
settinggroup 5.4 KB
sigimage 10.4 KB
smilie 4.5 KB
style 3.0 KB
subscribeforum 27.0 KB
subscribethread 1.5 MB
template 946.5 KB
templateset 2.7 KB
thread 3.4 MB
threadrate 19.1 KB
user 1.5 MB
useractivation 51.8 KB
userfield 24.3 MB
usergroup 6.1 KB
usernotepad 236.1 KB
usertitle 3.2 KB
vbstats_counter 1.5 KB
vbstats_countries 10.6 KB
vbstats_date 1.4 KB
vbstats_exclude 1.0 KB
vbstats_options 1.1 KB
vbstats_referrer 22.6 KB
word 24.9 MB
57 table(s) 1.2 GB

[Gamingforce]

1.4 GB right now :(

[hypedave]

dang db's in the gb range, whoa, I dont ever want to know the break down

[scotty]

787 MB here

[FleaBag]

Mine's about 70 megabytes now.

[futureal]

My phpadsnew database, working in conjunction with one of my sites, has recorded around 3.5 million impressions and is about 300MB in size.

I really need to reset it... :)

[ethank]

2 gigs now.

[Darkwolf]

30 mb now

[TECK]

Originally posted by Duke Of Lion
I am just wondering when my IP will charge me more because of exceeding my 25 MB limit. So here's my question to you.... 25mb limit? good luck.

i have 500mb and i'm worried.

[zachb]

42.2 MB

[N9ne]

btw: because this thread has been brought back and my last post in it is from April, ignore that lol...

My DB now is about 70MB...so i'm ok for now, in fact i'll be ok forever lol.

[DeadMan384AD]

Mines about 29MB thru a CP backup... But we restarted about the middle of summer due to a server crash...


How the heck do you guys have a 1GB+ database? how big is your forum!?? :eek:

[N9ne]

Forums which have over a 1GB database normally have millions of posts and haven't reindexed their search index for a while, the search index is the biggest part of the database along with the posts...

[ethank]

Originally posted by DeadMan384AD
Mines about 29MB thru a CP backup... But we restarted about the middle of summer due to a server crash...


How the heck do you guys have a 1GB+ database? how big is your forum!?? :eek:

Posts = 600,893 = 225.5 MB
PMs = 146,734 = 118.3 MB
Search Index = 9,401,995 = 222.5 MB
Attachment = 19,478 = 1.2 GB

7700 users

:)

[FlyBoy73]

143mb and growing.. 55 gigs+ left.. :)

[Chris M]

4.5 or so Mb:)

Satan

[DrkFusion]

My database is more than 25mb now

-Arunan

[NTLDR]

Mines rocketed up due to adding 496 attachments for my gallery, thats added about 20MB to my DB :eek:

[Chris M]

Wow...

You should install PPN's attachments as files hack;)

Satan

[NTLDR]

I prefer to have them all in the DB, otherwise I would have 496 full images and 496 thumbnails + all my other attachments floating around, way to confusing and messy IMO, much easier to restrict when they are in the DB too.