vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   How big is your SQL-Database? (https://vborg.vbsupport.ru/showthread.php?t=33656)

Duke Of Lion 12-30-2001 10:31 PM

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 12-30-2001 10:41 PM

More than 20MB here.. :o

Hoffi 12-31-2001 08:44 AM

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

Lesane 12-31-2001 10:25 AM

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

heretic 12-31-2001 01:58 PM

I think mine's about 30MB now

DarkReaper 12-31-2001 04:32 PM

http://www.seriouscommunity.com

Quote:

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 12-31-2001 05:45 PM

189.7 MB

drumsy 12-31-2001 06:51 PM

How does one find this information out?

armond_tamzaria 12-31-2001 07:08 PM

Quote:

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 12-31-2001 07:50 PM

Quote:

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 01-01-2002 12:59 PM

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 01-01-2002 02:49 PM

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

sphinx 01-01-2002 04:44 PM

21 meg here

mjames 01-02-2002 12:17 AM

53 MB.

snakes1100 04-08-2002 01:33 PM

100mb here thru a vb backup.

N9ne 04-08-2002 05:31 PM

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 04-09-2002 01:00 AM

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

hypedave 04-10-2002 12:13 AM

I db is 9.50MB :alien:

ethank 04-12-2002 11:26 PM

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 04-13-2002 01:12 AM

1.4 GB right now :(

hypedave 04-13-2002 02:33 AM

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

scotty 04-27-2002 09:11 AM

787 MB here

FleaBag 09-20-2002 01:57 PM

Mine's about 70 megabytes now.

futureal 09-21-2002 02:52 AM

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 09-21-2002 02:54 AM

2 gigs now.

Darkwolf 09-21-2002 11:48 AM

30 mb now

TECK 09-21-2002 12:07 PM

Quote:

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 09-21-2002 12:34 PM

42.2 MB

N9ne 09-21-2002 04:03 PM

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 09-21-2002 07:34 PM

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 09-21-2002 07:44 PM

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 09-21-2002 07:59 PM

Quote:

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 10-30-2002 08:30 PM

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

Chris M 10-30-2002 08:40 PM

4.5 or so Mb:)

Satan

DrkFusion 10-30-2002 08:59 PM

My database is more than 25mb now

-Arunan

NTLDR 10-30-2002 09:16 PM

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

Chris M 10-30-2002 09:44 PM

Wow...

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

Satan

NTLDR 10-30-2002 10:07 PM

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.


All times are GMT. The time now is 04:43 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01096 seconds
  • Memory Usage 1,779KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (5)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (38)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete