| Author |
 Topic  |
|
|
DavidRhodes
Senior Member
United Kingdom
1222 Posts |
 Posted - 27 November 2003 : 11:55:51
|
I'm getting a bit worried about the size of my database, almost 300Mb.
Some stats:quote:
1960 of 3013 Members have made 83442 posts in 35 forums
There are currently 8465 topics
There are 95671 archived posts in 9874 archived topics
Recovery model is "Simple"
Does this seem high?
|
The UK MkIVs Forum |
Edited by - DavidRhodes on 27 November 2003 11:56:09 |
|
|
Jeepaholic
Average Member
USA
697 Posts |
Posted - 27 November 2003 : 12:18:22
|
2638 of 5186 Members have made 244741 posts in 17 forums
There are currently 22681 topics
There are 208085 archived posts in 18733 archived topics
Note that my summary displays the TOTAL posts in the top two lines (including archived ones).
Regardless, my DB size is 380MB, recovery model is "Simple". You don't appear to be very out of line at all.
|
Al Bsharah
Aholics.com
Jeepaholics Anonymous
Broncoholics Anonymous
Network Insight
|
Edited by - Jeepaholic on 27 November 2003 12:18:51 |
 |
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 27 November 2003 : 12:39:29
|
This forum is currently 260Mb (clean Snitz, no MODS)
I have a few clients whose databases are approaching 500Mb |
|
|
|
dayve
Forum Moderator
USA
5820 Posts |
Posted - 27 November 2003 : 14:26:59
|
it seems high to me David. I am using Simple mode with 130,000+ posts and my DB is under 100 megabytes. I also have a lot of other tables with data going into it from other projects and mods.
btw, archiving won't make the database smaller... but I think you know that. |
 |
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 27 November 2003 : 14:38:01
|
the mode you use does not affect your database size, it affects your transaction log size.
so do you mean 300Mb including log ? if so how big is the log part. |
|
|
|
DavidRhodes
Senior Member
United Kingdom
1222 Posts |
Posted - 27 November 2003 : 14:50:22
|
I viewed the size from the properties after right clicked the database in EM.
And it now say 365Mb?! It was less than 300Mb earlier today |
The UK MkIVs Forum |
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 27 November 2003 : 14:54:49
|
| Ok, this is the size of both, if you select the transaction log tab, how much does it say is alocated to your transaction log ? |
|
|
|
dayve
Forum Moderator
USA
5820 Posts |
Posted - 27 November 2003 : 14:57:56
|
quote:
Originally posted by HuwR
the mode you use does not affect your database size, it affects your transaction log size.
so do you mean 300Mb including log ? if so how big is the log part.
agreed, but if I may add when you are running nightly backups it will include the database and the logs which is what I look at when I am talking about size. This is why I generally recommend turning logs to simple. I've also seen hosts count the log files towards your database limit. |
|
|
|
|
DavidRhodes
Senior Member
United Kingdom
1222 Posts |
Posted - 27 November 2003 : 15:00:07
|
I looked at the TaskPad view which shows 309.12Mb (Data) 56.3Mb (Log).
That's including free space as the TaskPad shows |
The UK MkIVs Forum |
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 27 November 2003 : 15:06:59
|
| 56mb is quite large for a log file using simple recovery, how much of it is actually used ? |
|
|
|
DavidRhodes
Senior Member
United Kingdom
1222 Posts |
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 27 November 2003 : 15:17:59
|
| Ok, you should be able to shrink it then, but unless you are pushed for space I wouldn't bother, it won't have any detrimental effect. |
|
|
|
wizard
Junior Member
208 Posts |
Posted - 29 November 2003 : 08:43:32
|
| I think you are all refering to the data itself right. Not the logs. Mine if logs are inclusive, it's quite/very huge. |
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 29 November 2003 : 11:16:39
|
| we are referring to both, if your log file is large then it is not set up correctly, if using simple mode, even on a pretty busy forum, if it is backed up daily your log should never be more than 10 to 20Mb |
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 29 November 2003 : 11:18:30
|
quote:
Originally posted by dayve
quote:
Originally posted by HuwR
the mode you use does not affect your database size, it affects your transaction log size.
so do you mean 300Mb including log ? if so how big is the log part.
agreed, but if I may add when you are running nightly backups it will include the database and the logs which is what I look at when I am talking about size. This is why I generally recommend turning logs to simple. I've also seen hosts count the log files towards your database limit.
Yes, I agree totally. which is why I also use simple mode for all my clients databases, although I do not count the log file towards the size, it is just more efficient to keep the log as small as possible. |
|
|
| |
Topic |
|
Topic Locked
