|
Morning chaps,
I keep getting an auto notification from my provider advising that the forum db is nearly full (20.94 of 22.00) used. Now, I've done the delete old threads et al but still didn't resolve so I ran a sql query to check the tables sizes. This returned the following:
| name |
rows |
reserved (kb) |
data (kb) |
index_size (kb) |
unused (kb) |
| tblThread |
5049 |
8904 |
4680 |
1152 |
3072 |
| tblAuthor |
163 |
432 |
208 |
112 |
112 |
| tblPMMessage |
2426 |
7536 |
6632 |
240 |
664 |
| tblBuddyList |
93 |
88 |
8 |
80 |
0 |
| tblConfiguration |
1 |
24 |
8 |
16 |
0 |
| tblDateTimeFormat |
Replies:
Posted By: WebWiz-Bruce
Date Posted: 04 March 2008 at 5:00pm
It looks like the database is reserving space within it. You have not said what db it is, but ask your web host to shrink the db.
20Mb is not allot anyway, I would also suggest getting a bigger database.
-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting
|
Posted By: Slugsabi
Date Posted: 04 March 2008 at 5:19pm
|
_popupControl();
Thanks Bruce, will get on that. Only small as only a few (50) users which usually surfices, even so I will allocate more space and get the providers to shrink as advised. It's the MS-SQL version, btw.
|
Posted By: WebWiz-Bruce
Date Posted: 04 March 2008 at 5:22pm
In that case you want to ask them to put the recover model on to simple and enable auto shrinking of the database. This will keep the file size down.
-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting
|
|