MyISAM tables in CMS database

amoxley's Avatar

amoxley

29 May, 2015 09:27 PM

Hi,

I have configured snapshots of my CMS database in Amazon RDS and I am getting notices that the MyISAM tables may not restore properly. I took a look at the database and I see that DATABASECHANGELOG & DATABASECHANGELOGLOCK are MyISAM while everything else is InnoDB.

What is the significance of these tables not being restored properly? Can I convert them to InnoDB?

  1. 1 Posted by Ryan Griffith on 01 Jun, 2015 03:05 PM

    Ryan Griffith's Avatar

    Hi,

    Those tables should definitely be InnoDB like all of the other tables, so feel free to convert them over.

    These particular tables are used by Cascade during the startup process to compare the versions of Cascade on the application and the database, which determines whether or not updates need to be applied.

    Please let me know if you have any questions.

    Thanks!

  2. Tim closed this discussion on 17 Jun, 2015 02:33 PM.

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac