SQL error

It Does What It Says on the Tin: Resolved Issues

Moderators: Moderator, Quality Control, Developer, DM

Post Reply
Shad
Posts: 328
Joined: Tue Nov 11, 2014 5:36 am
Location: Ukraine

Re: SQL error

Unread post by Shad »

Hey! Cheers forum's up again!
Btw deleting posts may not even free space, SQL just marks data for deletion, not really delete it from tables. Have to run optimize table on database to actually delete.
And there should be lots of logs which is obsolete.
Or how bout increasing disk space? If its virtual serever its really easy.
Tad - mercenary of the Phoenix Company. Now spending most of time in Friendly Arms, where he rents a room.
Corwin - Who am I? - Lost memory after injuries in the Undead war..
Top
User avatar
thids
Posts: 1254
Joined: Sat May 25, 2013 11:05 am

Re: SQL error

Unread post by thids »

I propose a ban for anyone with over 1k posts.
Lord Maximilian Blackthorne - retired
Top
Shad
Posts: 328
Joined: Tue Nov 11, 2014 5:36 am
Location: Ukraine

Re: SQL error

Unread post by Shad »

Hey that makes you close to it yourself!
Tad - mercenary of the Phoenix Company. Now spending most of time in Friendly Arms, where he rents a room.
Corwin - Who am I? - Lost memory after injuries in the Undead war..
Top
User avatar
Aspect of Sorrow
Custom Content
Posts: 2633
Joined: Fri Mar 28, 2014 7:11 pm
Location: Reliquary

Re: SQL error

Unread post by Aspect of Sorrow »

Shad wrote:Btw deleting posts may not even free space, SQL just marks data for deletion, not really delete it from tables. Have to run optimize table on database to actually delete.
And there should be lots of logs which is obsolete.
The clearance action is automatic for version 5 and above.
Shad wrote:Or how bout increasing disk space? If its virtual serever its really easy.
Unless the feature is provided by the hosting provider, the rented VPS doesn't have this option.
Top
User avatar
Maecius
Retired Admin
Posts: 11640
Joined: Sat May 16, 2009 4:24 pm

Re: SQL error

Unread post by Maecius »

Clearing up some space corrected the problem, and we'll stop our purging for now. Apologies to anyone who lost valuable threads.

As just a "best practice" moving forward, if you have a thread that's more than a couple of years old and it's not in a roleplaying forum, it's best to save a copy of it on your side. Alternatively, if it's something that benefits lots of players, bring it to a moderator's attention so it can be stickied.
Top
Post Reply

Return to “Solved Problems”