SERVER ISSUES: PLEASE HELP TEST

Post by **Darth Wong** » 2003-03-20 08:47pm

I've installed a new version of the database software (MySQL) on the test board. This new version fixes many serious performance issues, but it must be tested for reliability. Please abuse the test board mercilessly in order to make sure it's OK.

PS. For the propellerheads, the board currently runs on MySQL 3.23.55, and the one running on the test board is MySQL 4.0.12 (with PHP 4.3.1). Version 4.0.12 recently "went gold".

http://testbbs.stardestroyer.net

Kintaro · Post by **Kintaro** » 2003-03-20 08:56pm

Here we go again

J · Post by J » 2003-03-20 08:56pm

Loads fine, reads fine, but trying to post replies takes forever and eventually times out.

RedImperator · Post by **RedImperator** » 2003-03-20 09:20pm

I've had no problems with it thus far. My computer here sucks shit though, so I can't really post high volume spam.

Post by **Sea Skimmer** » 2003-03-20 09:26pm

Seems okay

Kelly Antilles · Post by **Kelly Antilles** » 2003-03-20 09:27pm

Considering I have quite a hard problem actually spamming... it does seem to work well.

Wicked Pilot · Post by **Wicked Pilot** » 2003-03-20 09:30pm

testbbs wrote:Could not obtain vote data for this topic

DEBUG MODE

SQL Error : 1 Can't create/write to file '/root/tmp/#sql_ee7_0.MYI' (Errcode: 13)

SELECT vd.vote_id, vd.vote_text, vd.vote_start, vd.vote_length, vr.vote_option_id, vr.vote_option_text, vr.vote_result FROM phpbb_vote_desc vd, phpbb_vote_results vr WHERE vd.topic_id = 13588 AND vr.vote_id = vd.vote_id ORDER BY vr.vote_option_id ASC

Line : 682
File : /var/www/html/viewtopic.php

Yeah, here's an error

Kintaro · Post by **Kintaro** » 2003-03-20 09:31pm

Yea, it's going slow for me, too.

Montcalm · Post by **Montcalm** » 2003-03-20 09:32pm

The only problem i have is when i post a message at lets say 9.40 pm it post 9.30 pm

KhyronTheBackstabber · Post by **KhyronTheBackstabber** » 2003-03-20 10:03pm

I just posted two fairly large pics, and it poped up quickly after I hit the submit button, so it seems to work fine for me so far.

Post by **Beowulf** » 2003-03-20 10:10pm

Having problems posting a reply too...

Defiant · Post by **Defiant** » 2003-03-20 10:28pm

Generally slow access times, but not too outrageous.

Post by **Darth Wong** » 2003-03-20 10:43pm

Wicked Pilot wrote:
testbbs wrote:Could not obtain vote data for this topic

DEBUG MODE

SQL Error : 1 Can't create/write to file '/root/tmp/#sql_ee7_0.MYI' (Errcode: 13)

SELECT vd.vote_id, vd.vote_text, vd.vote_start, vd.vote_length, vr.vote_option_id, vr.vote_option_text, vr.vote_result FROM phpbb_vote_desc vd, phpbb_vote_results vr WHERE vd.topic_id = 13588 AND vr.vote_id = vd.vote_id ORDER BY vr.vote_option_id ASC

Line : 682
File : /var/www/html/viewtopic.php
Yeah, here's an error

Thanks. I fixed that one; it was a config goof (I set the wrong TMP directory).

PS. I haven't been able to duplicate the long posting delays; I'll have to watch for it.

Post by **Darth Wong** » 2003-03-20 10:44pm

Defiant wrote:Generally slow access times, but not too outrageous.

Keep in mind it's currently running through a 128kbps connection, which is only 2-3 times as fast as a typical dial-up modem.

Einhander Sn0m4n · Post by **Einhander Sn0m4n** » 2003-03-20 11:07pm

Well it has occasional slowdowns, but that may be related to my "Most Unreal Spam Attacks I Have Ever Seen" as quoted by Darth Wong... LOL!!

Post by **Beowulf** » 2003-03-20 11:12pm

Darth Wong wrote:I haven't been able to duplicate the long posting delays; I'll have to watch for it.

It comes and goes.

irishmick79 · Post by **irishmick79** » 2003-03-20 11:35pm

I did my duty. No problems posting a new topic, and board speed seemed to be satisfactory. It didn't take me twenty minutes to make a friggin' post, which is a step in the right direction.

Post by **Darth Wong** » 2003-03-20 11:37pm

In theory, this version has more overhead so might be a bit more sluggish on certain operations, particularly searches. But when it gets bombarded with heavy traffic, it won't get as mind-bogglingly slow as the older version does. In other words, it's supposed to scale better.

Einhander Sn0m4n · Post by **Einhander Sn0m4n** » 2003-03-20 11:44pm

Darth Wong wrote:In theory, this version has more overhead so might be a bit more sluggish on certain operations, particularly searches. But when it gets bombarded with heavy traffic, it won't get as mind-bogglingly slow as the older version does. In other words, it's supposed to scale better.

Good! Means it can eat my Nuclear Spam MIRVs for breakfast

Hamel · Post by **Hamel** » 2003-03-20 11:46pm

Hohoho

What a treat

Post by **Sea Skimmer** » 2003-03-20 11:54pm

Einhander Sn0m4n wrote: Good! Means it can eat my Nuclear Spam MIRVs for breakfast

Break out the SM-1E38 Super Standard ABM missiles and load em on the Delete class cruisers quickly!

Test board still seems okay.

irishmick79 · Post by **irishmick79** » 2003-03-21 12:13am

Should we be concerned about the post-count difference? Here, I'm at 526, and at the test board I'm at 369. I'm getting poked, and I don't like it.

Post by **Sea Skimmer** » 2003-03-21 12:16am

irishmick79 wrote:Should we be concerned about the post-count difference? Here, I'm at 526, and at the test board I'm at 369. I'm getting poked, and I don't like it.

The test board is based off a copy of this board taken many weeks ago. Any changes or posts you made since then would not have carried over.

Brother-Captain Gaius · Post by **Brother-Captain Gaius** » 2003-03-21 12:35am

Thread formatting problems, don't know if too much was quoted or what: http://testbbs.stardestroyer.net/viewto ... 309#322309

BrYaN19kc · Post by **BrYaN19kc** » 2003-03-21 12:37am

Have you considered Oracle 9i as an option? MySql is really limited with limited resources. Oracle powers some of the most powerfull databases in the world.

With MySql, you get open code and no promises, no real support, and no real upgrades.

No, I'm not being snotty.. I'm an Oracle DBA and I believe that it's one of the BEST databases there is....

Just my thought.