POG MySQL tables type

13 views
Skip to first unread message

Valentin

unread,
Jan 26, 2011, 3:20:46 PM1/26/11
to Php Object Generator
Hello everybody,

I've been using POG for my application for a while. And I am really
happy with it.

I see that by default POG uses MyISAM tables. I was just wondering if
it's possible and easy to migrate to innodb.

I am mainly concerned about the table lock stuff on MyISAM tables.


Thanks in advance for this,

Valentin

Crispy

unread,
Jan 26, 2011, 11:54:19 PM1/26/11
to Php Object Generator
That's a good idea - the default for MySQL should probably be innodb
now.

Pedro Worcel

unread,
Jan 27, 2011, 6:33:05 AM1/27/11
to Php Object Generator
Hi!

Myisam and innodb are both great. :) Innodb should be default imo,
too.

Anyways, you can change the engine of the table using the following
sql command:

alter table table_name engine innodb;

Regards,
Droope
Reply all
Reply to author
Forward
0 new messages