Classic P99 Database

Abraham1 · #1 03-12-2011, 04:56 AM

Is there any chance that after kunark gets released, the original classic p99 database and the p99 classic eqemu server code could be released to the community publicly? As of now P99 is the only real everquest classic experience and doing so would not only benefit the players of classic eq but also the longevity of classic eq altogether.

karsten · #2 03-12-2011, 05:05 AM

here is a list of good ideas in this thread so far:

Uthgaard · #3 03-12-2011, 05:05 AM

Lol no.

DoucLangur · #4 03-12-2011, 01:32 PM

Not my idea, but I find the idea legitimate. So Uthgaard, I understand that you possibly do not want to make the fruits of your work publicly available, but what I don't understand is the "lol"...?

Cheers,

Slozem

DoucLangur · #5 03-12-2011, 01:37 PM

Never mind my comment. I figured out by myself why that isn't a good idea [You must be logged in to view images. Log in or Register.]

hedbonker · #6 03-12-2011, 01:44 PM

If they gave out the source / DB, Sony would get it and be able to fix the boats on live. That alone should be reason enough not to do it...

But seriously, these guys have poured 3 years of their lives into this and made this insanely cool thing that we all get to use for free. If I was them, giving away that code / DB would be the last thing I would do.

Admittedly, it would be useless to me personally since I do not know C++ from shinola. But I have to admit that I always wondered how many transactions per second the DB for Everquest was enduring when you had 800 people online...

mgellan · #7 03-12-2011, 02:00 PM

Quote:

Originally Posted by hedbonker [You must be logged in to view images. Log in or Register.]

I have to admit that I always wondered how many transactions per second the DB for Everquest was enduring when you had 800 people online...

It won't tell you anything about Live because they aren't running eqemu code on MySQL [You must be logged in to view images. Log in or Register.]

One question I'd like to ask tho: should the operators ever decide to shut this server down for any reason sometime in the future, would they Open Source the code and db (less chars obviously, but they can be recreated easily enough)? Then, at least, we could fire up a successor, regen our toons and continue [You must be logged in to view images. Log in or Register.]

Regards,
Mg

Uthgaard · #8 03-12-2011, 02:02 PM

Quote:

Originally Posted by hedbonker [You must be logged in to view images. Log in or Register.]

But I have to admit that I always wondered how many transactions per second the DB for Everquest was enduring when you had 800 people online...

This is going to be a little skewed since it's been in reduced functionality for about 14 hours, but:

This MySQL server has been running for 2 days, 20 hours, 53 minutes and 45 seconds. It started up on Mar 09, 2011 at 04:07 PM

Traffic 1 ø per hour
Received 36 GiB 530 MiB
Sent 48 GiB 716 MiB
Total 84 GiB 1,246 MiB

Query statistics: Since its startup, 32,484,538 queries have been sent to the server.
Total ø per hour ø per minute ø per second
32 M 471.50 k 7.86 k 130.97

Query type ø per hour %
delete 15 M 218.383 k 46.32%
select 8,279 k 120.171 k 25.49%
replace 3,842 k 55.762 k 11.83%
admin commands 1,873 k 27.187 k 5.77%
update 1,208 k 17.537 k 3.72%
insert 1,054 k 15.304 k 3.25%
set option 106 k 1.532 k 0.32%
insert select 34 k 493.179 0.10%
call procedure 21 k 305.853 0.06%
show table status 5,002 72.602 0.02%
replace select 411 5.966 0.00%
optimize 137 1.989 0.00%

**nilbog** · #9 03-12-2011, 02:04 PM

Absolutely not.

Closed.