My terribly archaic Database

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

[KingMort]

Would it be wise to convert everything to InnoDB ??

[cavedude]

Smaller tables that aren't used much generally benefit more from MyISAM over InnoDB. However, it wouldn't hurt to convert everything over. The only table I would highly recommend you leave MyISAM is character_backup. I'm not sure about you, but TGC's table is huge. Converting to InnoDB would waste so much space it's silly, and for that table you wouldn't really see much peformance boost at all, if any.