mersenneforum.org  

Go Back   mersenneforum.org > Fun Stuff > Lounge

Reply
 
Thread Tools
Old 2003-03-27, 15:41   #1
Xyzzy
 
Xyzzy's Avatar
 
Aug 2002

2·17·251 Posts
Default 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... :)
Xyzzy is offline   Reply With Quote
Old 2003-03-27, 18:32   #2
pakaran
 
pakaran's Avatar
 
Aug 2002

3×83 Posts
Default

I'll be on AIM this evening, or reply here.

I was wondering why the forum was so slow this morning!
pakaran is offline   Reply With Quote
Old 2003-03-27, 19:53   #3
Prime95
P90 years forever!
 
Prime95's Avatar
 
Aug 2002
Yeehaw, FL

1F9416 Posts
Default

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.
Prime95 is offline   Reply With Quote
Old 2003-03-27, 20:09   #4
eepiccolo
 
eepiccolo's Avatar
 
Dec 2002
Frederick County, MD

37010 Posts
Default

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.
eepiccolo is offline   Reply With Quote
Old 2003-03-27, 21:13   #5
Xyzzy
 
Xyzzy's Avatar
 
Aug 2002

2·17·251 Posts
Default

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...
Xyzzy is offline   Reply With Quote
Old 2003-03-27, 21:15   #6
Xyzzy
 
Xyzzy's Avatar
 
Aug 2002

853410 Posts
Default

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...
Xyzzy is offline   Reply With Quote
Old 2003-03-29, 01:01   #7
quikdave
 
Mar 2003

516 Posts
Default 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<,
quikdave is offline   Reply With Quote
Old 2003-03-29, 03:22   #8
Xyzzy
 
Xyzzy's Avatar
 
Aug 2002

2·17·251 Posts
Default

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...
Xyzzy is offline   Reply With Quote
Old 2003-03-29, 08:57   #9
trif
 
trif's Avatar
 
Aug 2002

2·101 Posts
Default

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).
trif is offline   Reply With Quote
Old 2003-03-29, 15:14   #10
Xyzzy
 
Xyzzy's Avatar
 
Aug 2002

2×17×251 Posts
Default

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...
Xyzzy is offline   Reply With Quote
Old 2003-03-31, 16:21   #11
eepiccolo
 
eepiccolo's Avatar
 
Dec 2002
Frederick County, MD

1011100102 Posts
Default

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.
eepiccolo is offline   Reply With Quote
Reply

Thread Tools


Similar Threads
Thread Thread Starter Forum Replies Last Post
(archive)MISFIT swl551 MISFIT 584 2013-03-19 20:13
(archive)mfaktXapp 1.4 swl551 MISFIT 125 2012-11-09 14:50
Corrupt archive D_unreg Information & Answers 4 2009-02-18 12:00
Archive 2 for Other results (>155) em99010pepe Octoproth Search 161 2007-06-08 21:31
Archive 1 for Other results (>155) ValerieVonck Octoproth Search 90 2007-03-21 01:01

All times are UTC. The time now is 06:47.


Thu Dec 1 06:47:54 UTC 2022 up 105 days, 4:16, 0 users, load averages: 1.26, 1.37, 1.20

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2022, Jelsoft Enterprises Ltd.

This forum has received and complied with 0 (zero) government requests for information.

Permission is granted to copy, distribute and/or modify this document under the terms of the GNU Free Documentation License, Version 1.2 or any later version published by the Free Software Foundation.
A copy of the license is included in the FAQ.

≠ ± ∓ ÷ × · − √ ‰ ⊗ ⊕ ⊖ ⊘ ⊙ ≤ ≥ ≦ ≧ ≨ ≩ ≺ ≻ ≼ ≽ ⊏ ⊐ ⊑ ⊒ ² ³ °
∠ ∟ ° ≅ ~ ‖ ⟂ ⫛
≡ ≜ ≈ ∝ ∞ ≪ ≫ ⌊⌋ ⌈⌉ ∘ ∏ ∐ ∑ ∧ ∨ ∩ ∪ ⨀ ⊕ ⊗ 𝖕 𝖖 𝖗 ⊲ ⊳
∅ ∖ ∁ ↦ ↣ ∩ ∪ ⊆ ⊂ ⊄ ⊊ ⊇ ⊃ ⊅ ⊋ ⊖ ∈ ∉ ∋ ∌ ℕ ℤ ℚ ℝ ℂ ℵ ℶ ℷ ℸ 𝓟
¬ ∨ ∧ ⊕ → ← ⇒ ⇐ ⇔ ∀ ∃ ∄ ∴ ∵ ⊤ ⊥ ⊢ ⊨ ⫤ ⊣ … ⋯ ⋮ ⋰ ⋱
∫ ∬ ∭ ∮ ∯ ∰ ∇ ∆ δ ∂ ℱ ℒ ℓ
𝛢𝛼 𝛣𝛽 𝛤𝛾 𝛥𝛿 𝛦𝜀𝜖 𝛧𝜁 𝛨𝜂 𝛩𝜃𝜗 𝛪𝜄 𝛫𝜅 𝛬𝜆 𝛭𝜇 𝛮𝜈 𝛯𝜉 𝛰𝜊 𝛱𝜋 𝛲𝜌 𝛴𝜎𝜍 𝛵𝜏 𝛶𝜐 𝛷𝜙𝜑 𝛸𝜒 𝛹𝜓 𝛺𝜔