Got Server Lag? This might be your fix..

[WildcardX]

It is the table create SQL statement that determines what storage engine MySQL will use for a given table. For example:

CREATE TABLE  `pets` (
  `type` varchar(64) NOT NULL default '',
  `npcID` int(11) NOT NULL default '0',
  `temp` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`type`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

Notice the "Engine=" statement? That requests a particular storage engine from MySQL. In MySQL 4.1 or older, you will see a "TYPE=" statement instead of "ENGINE=". MySQL deprecated the "TYPE" keyword in MySQL 5.0.

[WildcardX]

Actually, technically speaking, even the current PEQ database has two tables that will be made into InnoDB tables providing your MySQL instance has the InnoDB storage engine enabled. These two tables are "rule_sets" and "rule_values". This happened by accident if I understand correctly. However, the PEQ game server does not have InnoDB enabled so all tables served up by it now are all MyISAM.