• Registered: 2006-09-10
  • Posts: 13

Topic: Converting Tables to InnoDB Engine

Hi,

just 2 quick questions on converting all PunBB tables from MyISAM to InnoDB:

- Will it work without making any modification to PunBB?
- Can I delete all *.myd and *.myi without impacting the functionality and performance of the application/database?

I appreciate your help,


cutweed

cutweed's Website

  • From: 127.0.0.1
  • Registered: 2001-11-02
  • Posts: 9,167

Re: Converting Tables to InnoDB Engine

It should work without any problems. My question is why? The only table one could consider converting to innodb is the topics table (because it gets quite a lot of updates).

"Programming is like sex: one mistake and you have to support it for the rest of your life."

Rickard's Website

  • Smartys
  • Former PunBB Developer
  • Offline
  • Registered: 2004-04-30
  • Posts: 7,844

Re: Converting Tables to InnoDB Engine

Also, to take advantage of the transactional features of InnoDB, you'll have to rewrite start_transaction and end_transaction in the dblayer for MySQL (or MySQLi, depending on what you use)

  • Registered: 2006-09-10
  • Posts: 13

Re: Converting Tables to InnoDB Engine

Thanks for both of your inputs, any chance that you could suggest what kind of changes needed in dblayer? I figure that I should standardize all my data into one engine as my other portion is in InnoDB; not sure if matters much...

regards,

cutweed

cutweed's Website

  • From: Poland
  • Registered: 2005-01-08
  • Posts: 105

Re: Converting Tables to InnoDB Engine

at start you need to execute 2 queries:

SET AUTOCOMMIT = 0
BEGIN

and in end_transaction:

COMMIT

or

ROLLBACK

if there was an error smile

My site [PHP, Python, Linux]

Riklaunim's Website