My terribly archaic Database

[KingMort]

Well as some of you know most of my Database is from 2003ish....

I strongly believe that it's the main cause of many of my performance issues on KMRA...

I rent a Fully dedicated and very nice box that should be enough to handle 200+ people just like PEQ and VZ...

However at around 50+ people start to go LD while zoning alot.. Generalized Tell Lag and lag in encounters...

So what I was hoping was for someone who is good with Database stuff to help me out... And I will be willing to Donate to this person generously...

Please PM me here in the Forums... I would prefer to have some one that's well known in the community since they will be having access to the OLDEST Database with all of those years of work put into it...

Trev maybe ? Or KLS Or Cavedude would be my top choices.. If you guys could find the time to help me I will make it worth your while..

Jordan "King" Mortenson
Owner - www.raidaddicts.org

[trevius]

If you are seeing lag like that, it sounds like it is most likely the connection speed, in particular your upload bandwidth, that is causing it. Does your hosting provide a guaranteed speed for upload bandwidth? I have 2MB up and my server can probably handle about 150-180 before performance started to take a serious hit. Most professional hosting offers 100MB up/down, so that shouldn't be a problem, but it sounds like the same symptoms.

As long as your server is running fairly new source code from the SVN, your database should be fairly up-to-date as far as that goes. Anything else causing performance hits might be due to either certain settings for your server, or possibly from quests or something that is eating a lot of your resources. One thing that I did that seems to help quite a bit for raid zones was to change the rule for zonewide spawn updates from 1 time per minute to 1 time every 10 minutes. Having it set longer like that can cause minor issues with spawn position ghosting if people are running through a large zone with lots of roaming npcs that have long path ranges, but it isn't anything major.

What is your CPU running at, and how much memory does the server have?

BTW, I don't want any payment lol. I give my help for free to anyone that I can :P

[KingMort]

Thanks Trev

Server is hosted here http://www.spry.com/dedicated-servers/

We have 2 gigs of Ram.. on Fedora Core 6 Linux...

100 MB UP / DOWN

How do I do that with the mobs updating is that a Rule or a Variable.. Or an actual binary mod..

Really appreciate your help

King

[John Adams]

KM, if you have direct access to your MySQL instance, you might want to run some checks/optimizations to make sure your tables aren't fragmented or corrupt. On my EQ2Emu server, one table is HUGE and I notice that with recent power glitches, that table gets a little buggered up - but is immediately fixed with OPTIMIZE TABLES.

Another thing, many people poo-poo, is running the command-line too "mysqltuner.pl". Just to get a glimpse if something is f'd up.

...not that I was on your preferred list :p

[KingMort]

I run optimize usually once a month yeah...

[KLS]

The configuration of the mysql tables actually makes a pretty startling impact on performance. If you're using myisam on a table that is both written to and read from a lot like character_ it can really bog things down with all the locks going off left and right.

Tell / Combat lag could happen if it's bogged down from the database but it would be intermittent: not every tell would lag for example just the ones that happen during a slow query. Oh and I guess you could turn on http://dev.mysql.com/doc/refman/5.1/...query-log.html and see if there are any queries really causing problems.