mersenneforum.org The Archive...
 Register FAQ Search Today's Posts Mark Forums Read

 2003-03-27, 15:41 #1 Xyzzy     Aug 2002 3·2,861 Posts The Archive... I had to kill the archive... It doubled the size of our database and slowed everything down too much... We only had 75 out of 375 digests posted which means the database would have gotten huge... It looks like when we get to 10,000 messages we'll either have to start pruning old messages or maybe find a faster database server... I think what I will do is mirror the uncompressed digests on the mersenneforum.org web server and let Google index them... It will take a few months, but it will eventually work... Now I have to find pakaran another job... :)
 2003-03-27, 18:32 #2 pakaran     Aug 2002 3×83 Posts I'll be on AIM this evening, or reply here. I was wondering why the forum was so slow this morning!
 2003-03-27, 19:53 #3 Prime95 P90 years forever!     Aug 2002 Yeehaw, FL 2×4,099 Posts This worries me. Isn't the forum MySQL based? If we consider using MySQL for an open-source reimplementation of the PrimeNet server it will have large databases. Properly indexed, the database size should have virtually no effect on timings to access records. Is MySQL a toy database or is ready for a real job like the Primenet server. It is possible the the bulletin board software uses MySQL non-optimally. Let's hope so.
 2003-03-27, 20:09 #4 eepiccolo     Dec 2002 Frederick County, MD 2×5×37 Posts This is totally a shot in the dark, and probably irrelevant, but does the message at the bottom of the pages saying it is in "Debug Mode" have anything to do with it? I ask because usually when you compile an executable in debug mode, it runs slower.
2003-03-27, 21:13   #5
Xyzzy

Aug 2002

100001100001112 Posts

Quote:
 Originally Posted by Prime95 This worries me. Isn't the forum MySQL based? If we consider using MySQL for an open-source reimplementation of the PrimeNet server it will have large databases. Properly indexed, the database size should have virtually no effect on timings to access records. Is MySQL a toy database or is ready for a real job like the Primenet server. It is possible the the bulletin board software uses MySQL non-optimally. Let's hope so.
The problem is, I think, the fact we are not on dedicated hardware... To make the jump up to dedicated hardware is a significant jump in cost... I'm starting now to look for a better host to hold our database... I figure at our current rate we have 6 months to a year before we outgrow this one...

There are phpBB forums out there that have hundreds of thousands of messages and they are just as fast as we are... I assume they have a heavy-duty server hosting the database...

2003-03-27, 21:15   #6
Xyzzy

Aug 2002

3·2,861 Posts

Quote:
 Originally Posted by eepiccolo This is totally a shot in the dark, and probably irrelevant, but does the message at the bottom of the pages saying it is in "Debug Mode" have anything to do with it? I ask because usually when you compile an executable in debug mode, it runs slower.
The debug mode just reports the number of database queries and the time taken... It has no effect on speed...

2003-03-29, 01:01   #7
quikdave

Mar 2003

516 Posts
Re: The Archive...

Quote:
 Originally Posted by Xyzzy I had to kill the archive... It doubled the size of our database and slowed everything down too much
Pity - I was hoping it would finally extend forward in time to the point where I joined the project, Primenet was running properly, etc. etc.
8&lt;,

2003-03-29, 03:22   #8
Xyzzy

Aug 2002

3·2,861 Posts

I was quoted this yesterday...

Quote:
 Our QS-0 packages have the same details as our QS-1 server packages, with the exception of the processor speed. So, the following still holds for all QS-0 packages: - 256MB RAM - 30GB Hard Drive - 60GB/Mon Traffic - 250 Mailboxes - Includes Virtual Domain We have a number of QS-0 processor speeds, the lower the processor, the lower the monthly fee. The two lowest end packages we currently have are as follows: 1) Pentium 667 for $149/month. 2) Celeron 900 for$199/month. We also have packages (as available) for $249/month and$299/month. You may inquire about these if you would like a higher processor speed. ------------------------------------------------------ The MySQL database packages have 0 bandwidth allowances (all of the bandwidth used is internal for the queries), so they are $50 less than the full servers. Thus, and this is the simple bottom line you wanted all along I'm sure, you could get a dedicated MySQL database server for$99/month. If that or any of the other packages interest you, let me know. Gwendolyn R. Schmidt, Systems Administrator, pair Networks, Inc.
I think it would be hard to justify that kind of expense...

 2003-03-29, 08:57 #9 trif     Aug 2002 2×101 Posts Xyzzy, I have a web server that could host the site. It runs Ensim, which means it is a Redhat machine. There is presently very little running out of it (except Prime95 ops: ), and while I intend to run it as a business at some point, I have no pricing for service right now (it would be considerably cheaper than pair, though).
 2003-03-29, 15:14 #10 Xyzzy     Aug 2002 3×2,861 Posts I appreciate the offer, but for now what we have is adequate... I figure the slow pages happen only a few times a day... At least that is what I see and I'm here all day off and on... The only advantage to having a dedicated server is we wouldn't have to wait in line for our queries... I figure I have a year before we are in trouble so that gives me plenty of time to learn how to tweak everything... It might even be possible to set everything up to use two different database servers, like maybe a load balanced deal... I have plenty of databases left that I could use, and it is easy to make sure they are on different physical machines...
 2003-03-31, 16:21 #11 eepiccolo     Dec 2002 Frederick County, MD 37010 Posts Um, so Xyzzy, if you get everything tweaked and working well, will you bring back the archive? I agree with quikdave that it would be nice to see what went on before more recent members like us joined.

 Similar Threads Thread Thread Starter Forum Replies Last Post swl551 MISFIT 584 2013-03-19 20:13 swl551 MISFIT 125 2012-11-09 14:50 D_unreg Information & Answers 4 2009-02-18 12:00 em99010pepe Octoproth Search 161 2007-06-08 21:31 ValerieVonck Octoproth Search 90 2007-03-21 01:01

All times are UTC. The time now is 13:03.

Tue Mar 28 13:03:59 UTC 2023 up 222 days, 10:32, 0 users, load averages: 0.89, 0.88, 0.87