Page 1 of 1

Question about server hardware/performance

Posted: Wed Jun 25, 2008 7:51 pm
by nyquist
About how much space do MySQL and the World binary (+ all dependencies) take up on a Linux machine? (Ubuntu in particular)
And what sort of processing power is required to host a world to even one or two players?
Finally, (this sort of relates to the previous question) would I be able to host the world on my machine AND debug it from the same PC?

Posted: Wed Jun 25, 2008 11:48 pm
by John Adams
The stats you seek do not have a very practical answer at this time, considering the emulator binaries are in constant flux, and the database has only just begun to be created. If you are speaking of MySQL itself, maybe you should check out the MySQL support site - as this is not it.
"Ballparking", I would say MySQL + EQ2World binary eat up a gig or two, at the outside right now... with room to grow.
You cannot get stats on processing power on a multi-player program that has no data nor been load tested. Your best bet is to assume, "If I can run the OS, I can run the software".
Lastly, I see no reason why you cannot host the world and debug it from the same machine. I do not even know what you mean by that, since with linux, you are getting the source from SVN, compiling it, and running it all on Linux.
It will be months before solid hardware specs can be offered that are tangible. Suffice it to say, they will not be lofty.

Posted: Thu Jun 26, 2008 4:30 am
by nyquist
I guess I could have been more clear in my question (although you did pretty much answer it).
"About how much space do MySQL and the World binary (+ all dependencies) take up on a Linux machine? (Ubuntu in particular)"
1) I really meant the MySQL database(s), which sounds like they will be 1-2gig for now, but I have ample space for this.
"And what sort of processing power is required to host a world to even one or two players? "
2) This was meant to determine if I would need processor > Dual Core ~2.4GHz for the server.
"Finally, (this sort of relates to the previous question) would I be able to host the world on my machine AND debug it from the same PC?"
3) I was merely asking if I could run the MySQL server, eq2 server, AND an EQ2 Client (using the client to test everything out from a user standpoint) all from one box. I looked at the Win32 binary and they are very small, more so than I thought they would be. From a load standpoint, I think my computer should be able to handle it. My PC is not top of the line, but it's okay.

Posted: Thu Jun 26, 2008 8:36 am
by Zcoretri
1) I really meant the MySQL database(s), which sounds like they will be 1-2gig for now, but I have ample space for this.
Right now my MySQL DB is around 7.5MB with only a few populated zones.
2) This was meant to determine if I would need processor > Dual Core ~2.4GHz for the server.
The more processing power the better :)
3) I was merely asking if I could run the MySQL server, eq2 server, AND an EQ2 Client (using the client to test everything out from a user standpoint) all from one box. I looked at the Win32 binary and they are very small, more so than I thought they would be. From a load standpoint, I think my computer should be able to handle it. My PC is not top of the line, but it's okay.
I'm doing what you asking here all on a laptop.
Intel Core 2 Duo T5250 @ 1.5Ghz
2048MB RAM
and it handles it just fine.

Posted: Fri Jun 27, 2008 7:04 am
by John Adams
nyquist wrote:1) I really meant the MySQL database(s), which sounds like they will be 1-2gig for now, but I have ample space for this.
Actually, I meant when the database is completely finished (which will be a long time from now), it could be as large as 1-2GB... today, it's barely a whisper.

Posted: Fri Jun 27, 2008 10:18 am
by nyquist
Oh, ok.
So my PC should be good to go
I will probably get a test server set up eventually. Most likely in August when I have my PC back at school and have a small portion of a T1 connection

Posted: Fri Jun 27, 2008 5:07 pm
by intodesi
Hell as a test server.. im using an old HP Pavilion.. think it has about 512 ram etc.. but for testing purposes, it works great.. as tony the tiger would say

Posted: Tue Jul 01, 2008 10:10 pm
by orchard54
If this has been asked before, I wasn't able to find it, but is eq2emu set up for 64 bit and/or is there a plan to do it?
Right now I'm running on the specs listed in my signature.
I've been kind of dinkin' around with the code, I'm pretty new at it so it'll take some time. But I got big plans for my server :D :D :D

Posted: Thu Jul 03, 2008 12:15 pm
by link2009
I doubt we'll implement 64-bit support in the near future...that's a good idea but really fast tracking.

Posted: Thu Jul 03, 2008 9:39 pm
by John Adams
Isn't 32/64 bit only reliant on the machine/compiler setup? I know there are integer differences, but I'd be surprised if we haven't taken that into consideration already.
One little, two little, three little endians...

Posted: Fri Jul 04, 2008 8:14 am
by LethalEncounter
Windows XP 64 bit can run 32 bit programs just fine. I dont have a 64 bit OS (yet) so I would have no way of testing any that I compile. I don't think you will have any problems compiling the emu in 64 bit, but until it is tried I can't be 100% certain.

Posted: Fri Jul 04, 2008 12:30 pm
by John Adams
Tell ya what. Since I am SUCH a helpful guy, I'll try it on one of my VMs this weekend, see what happens. I am fairly confident there won't be any problems, but you never know. :)
I have Fedora Core 8, WinXP, Servers 2003 and 2008 x64. Just give me some time to set them up as a dev environment, and we'll get this answered.
I think it's a good question, really.
Btw, f__k Vista. :D

Posted: Fri Jul 04, 2008 2:00 pm
by Zcoretri
John Adams wrote:Tell ya what. Since I am SUCH a helpful guy, I'll try it on one of my VMs this weekend, see what happens. I am fairly confident there won't be any problems, but you never know. :)
Gotta love VM's :) You use VMWare John?
Btw, f__k Vista. :D
I'm glad I'm not the only one who thinks that :)

Posted: Fri Jul 04, 2008 8:40 pm
by John Adams
I do use VMWare (1.0.5) on 3 hosts, and depending on what config I need to be in for work, I have about 30 "virtual machines" I can turn on as needed.