Announcement

Announcement Module
Collapse
No announcement yet.

Optimization: Only InnobDB, no MyISAM

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Optimization: Only InnobDB, no MyISAM

    As I've chosen to use only InnoDB for my tables, I wish to know which configuration values I may cut to save on memory.

    Also, I understand that MyISAM is used anyway for temporary tables. It also seems like the default "MySQL" and "Information_Schema" databases use MyISAM. Can this be changed or am I stuck with MyISAM anyway?

    Thanks

  • #2
    You are stuck with myisam. You should leave about 32M or so in your key_buffer for temporary tables, and that's about the only thing you need to change.

    Comment

    Working...
    X