Got Server Lag? This might be your fix..

[John Adams]

WildcardX, I don't have the SQL files in front of me, but is it true that some tables are InnoDB already, and some are still MyISAM in the current PEQ database? If so, how is that determined, or is it just "guessed" by the server depending on the table you are creating? I've never quite grasped that (I tend to favor MS SQL myself ).

As I posted on PEQ, I am all for staying modern, especially since the alleged "supported" DB is no longer available from it's creators. Many have reported problems with MySQL 5.0, but many have also answered with solutions. I think it's time for the community to move forward with this.

It would be imperative that the devs acknowledge that using a newer DB will not out-and-out break the Emu. It's not likely, since SELECT, INSERT, UPDATE, and DELETE are pretty rudimentary. But you never know... data types and all. For instance, some older MySQLs do not support comments. ~twirls finger~ who cares about that tho.

[Angelox]

LoL WildCardX is a Dev!
believe me when I tell you this has all been tested (I was part of it for a while).
It all works fine - and you can have a backup ready , for just incase.
Also, the current PEQ DB has no InnoDB tables

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

[John Adams]

Originally Posted by Angelox

LoL WildCardX is a Dev!

Put down the pom-poms, Cheerleader. I know he's a Dev. I was meaning, all devs in the community come to an agreement or understanding before one person unilaterally makes a change. No disrespect to WildcardX meant.

Besides, I freakin agree with him. So there. :p

[WildcardX]

Fear not, when MySQL 5.0 and/or InnoDB become the "official" technologies of this project, it will be decision made by me and the rest of the dev team. In the meantime, I offer to share the information I have with the community so if people want to give these technologies a go, they can try it. I just ask people to post back to here their findings and experiences.