SQL Crashes on Forumosa- for the Admin team

Let us know how you feel about the website and tell us how it could improve. You can also send e-mail to admin (at) forumosa.com.

Moderators: Tempo Gain, ironlady

Forum rules
Let us know how you feel about the website and tell us how it could improve. You can also send e-mail to admin (at) forumosa.com if you have any problems accessing the forums

Re: SQL Crashes on Forumosa- for the Admin team

Postby goose egg » 31 May 2012, 12:32

I gotta find out where all this sour cream is coming from

I'm sorry to hear you are going quiet Plasmatron. Hope to hear from you on Forumosa soon

FWIW, our logs tell us that last night's server restoration meant a loss of 20 hours of posts (we started daily backups in November) and the server problems cited only began last week (not "weeks")
Image
Click here to see the active topics
Forumosan avatar
goose egg
Forumosa Admin
 
Posts: 5302
Joined: 28 Mar 2001, 17:01
Location: Sun Yat Sen Memorial
80 Recommends(s)
36 Recognized(s)

6000

Re: SQL Crashes on Forumosa- for the Admin team

Postby engerim » 06 Jun 2012, 07:57

I added this bits to the part of the code where the SQL error appears:
Code: Select all
$backtrace = "SQL error on request: " . $sql . "\nBacktrace:\n" . get_backtrace();
mail ( 'engerim@forumosa.com', 'SQL error on Forumosa', $backtrace);


I also increased the number of maximum connections on Wednesday.
So in case this happens again we'll get immediately informed.

The server has been stable since the upgrade. Forumosa had a few out of memory errors before, not now anymore.

I guess the main reason is that the database is huge. You can go back in nearly 13 years of posts.
The oldest one: viewtopic.php?f=30&t=3968#p23648
The posts table alone is about 1.1 GB. Totally we have 2.4 GB of pure text data.
This isn't 'just' an average phpbb installation, For the "user experience" I take it that it is being worked on.
Forumosan avatar
engerim
Betelnut Beauty (bīnglang Xī Shī)
Betelnut Beauty (bīnglang Xī Shī)
 
Posts: 1501
Joined: 01 Aug 2005, 00:54
Location: Taiwan
8 Recommends(s)
15 Recognized(s)

6000

Previous




 
 
 x

Return to Feedback



Who is online

Forumosans browsing this forum: No Forumosans and 2 visitors

Come up with an automated backup system for your computer. There's no misery quite like the sick feeling of having lost chunks of your life because you didn't have a safety copy.
More tips from David Pogue