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: 5323
Joined: 28 Mar 2001, 17:01
Location: Sun Yat Sen Memorial
86 Recommends(s)
37 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: 1504
Joined: 01 Aug 2005, 00:54
Location: Taiwan
8 Recommends(s)
16 Recognized(s)

6000

Previous




Return to Feedback



Who is online

Forumosans browsing this forum: No Forumosans and 1 visitor

If I could only remember that the days were, not bricks to be laid row on row, to be built into a solid house, where one might dwell in safety and peace, but only food for the fires of the heart -- EDMUND WILSON