Page 1 of 2
SERVER ISSUES: PLEASE HELP TEST
Posted: 2003-03-20 08:47pm
by Darth Wong
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
Posted: 2003-03-20 08:56pm
by Kintaro
Here we go again
Posted: 2003-03-20 08:56pm
by J
Loads fine, reads fine, but trying to post replies takes forever and eventually times out.
Posted: 2003-03-20 09:20pm
by RedImperator
I've had no problems with it thus far. My computer here sucks shit though, so I can't really post high volume spam.
Posted: 2003-03-20 09:26pm
by Sea Skimmer
Seems okay
Posted: 2003-03-20 09:27pm
by Kelly Antilles
Considering I have quite a hard problem actually spamming... it does seem to work well.
Posted: 2003-03-20 09:30pm
by Wicked Pilot
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
Posted: 2003-03-20 09:31pm
by Kintaro
Yea, it's going slow for me, too.
Posted: 2003-03-20 09:32pm
by Montcalm
The only problem i have is when i post a message at lets say 9.40 pm it post 9.30 pm
Posted: 2003-03-20 10:03pm
by KhyronTheBackstabber
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.
Posted: 2003-03-20 10:10pm
by Beowulf
Having problems posting a reply too...
Posted: 2003-03-20 10:28pm
by Defiant
Generally slow access times, but not too outrageous.
Posted: 2003-03-20 10:43pm
by Darth Wong
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.
Posted: 2003-03-20 10:44pm
by Darth Wong
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.
Posted: 2003-03-20 11:07pm
by Einhander Sn0m4n
Posted: 2003-03-20 11:12pm
by Beowulf
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.
Posted: 2003-03-20 11:35pm
by irishmick79
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.
Posted: 2003-03-20 11:37pm
by Darth Wong
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.
Posted: 2003-03-20 11:44pm
by Einhander Sn0m4n
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
Posted: 2003-03-20 11:46pm
by Hamel
Hohoho
What a treat
Posted: 2003-03-20 11:54pm
by Sea Skimmer
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.
Posted: 2003-03-21 12:13am
by irishmick79
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.
Posted: 2003-03-21 12:16am
by Sea Skimmer
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.
Posted: 2003-03-21 12:35am
by Brother-Captain Gaius
Thread formatting problems, don't know if too much was quoted or what:
http://testbbs.stardestroyer.net/viewto ... 309#322309
Posted: 2003-03-21 12:37am
by BrYaN19kc
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.
