![]() |
suspended account due to 1.7 gig database Need help@
I just got a email from my host today telling me my account was suspended diue to a large 1.7 gig database. I need some ideas peraps hacks I can install that will help drop this number down! Please!!!
I am looking for the attachments as files hack now. Thanks!! |
Turn off avatars, attachments, limit post sizes, prune old posts, remove hacks that add bulk to the database, turn off searching. Should make database size plummet.
|
thanks filburt1 I will try that. I know people will not like to loos the avatar so I think I have to leave that alone. I jsut noticed i had over 400,000 posts in a usenet group. Hopefully pruning that will help!
|
1.7 gig database..? :eek:
A lot of hosts would have suspended your account ages ago.. |
LOL I don;t think they noticed!! I just got the email today.
|
First, prune old messages, then reindex the search index if you don't want to turn it off completely. The search index is usually a big chunk of the database.
|
Make sure you regularly optimize the attachments table, through phpmyadmin, as I once found when my attachment table was reading 50+ megs, that once I optimized it, it had gone down to under 5mb.
Use repair.php ;) |
OK Well i used the rep[air.php and got now have this error on my pages/. . .
Database error in vBulletin 2.2.6: Invalid SQL: SELECT post.postid, post.userid, post.pagetext, post.topic, user.username as username, attachment.attachmentid,attachment.filename,attach ment.visible AS attachmentvisible,attachment.counter FROM post LEFT JOIN user ON (post.userid = user.userid) LEFT JOIN attachment ON attachment.attachmentid=post.attachmentid WHERE threadid=11529 ORDER BY postid LIMIT 1 mysql error: Can't open file: 'post.MYI'. (errno: 144) mysql error number: 1016 Date: Wednesday 09th of April 2003 06:46:31 PM Script: http://www.talkdisney.com/forums/ Referer: |
run it again, shopuld fix that
|
OK i will try. Thanks! I am dying here!!! I almost uploaded my backup from 3 months ago. Glad i read this first!! Thanks
FYI when I run it i do get a lot oferrors saying tanble is corrupt. . . |
All times are GMT. The time now is 12:34 AM. |
Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|