My terribly archaic Database

[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.

[KingMort]

You guys rock....

I have had a hard time asking for help since I have been around so long it was hard for me to ask for help but....

The time has come to swallow my pride...

King

[cavedude]

alter table spawn2 engine=innodb;

and

alter table character_ engine=innodb;

Made HUGE differences on TGC. Inventory would also benefit from InnoDB. Though, keep in mind it does require a lot more HDD space (character_ grew 4x after the change here.)