Comments on Profile Post by Aikar

  1. Aikar
    Aikar
    converting all myisam tables to innodb, and will consider XtraDB for special tables like user after some research into it!
    Oct 21, 2014
  2. Aikar
    Aikar
    as to why - MyISAM is an older storage method for databases that has a slew of issues such as bigger hangups for messing with the data (table locking vs row locking), and worse off: bigger potential for data loss in the event of a crash. if data gets corrupted your in trouble which we have had one corruption incident before
    Oct 21, 2014
  3. Aikar
    Aikar
    additionally, myisam apparently requires routine 'maintenance', that I did not know about, so needless to say we haven't been doing it... But InnoDB is newer and doesn't have many of those flaws.
    Oct 21, 2014
  4. Aikar
    Aikar
    And is now the new default
    Oct 21, 2014
  5. mba2012
    mba2012
    What's the tool you're using? I'm assuming it's a Linux one? I've used SequelPro on OS X recently, which seems to be a good tool :P
    Oct 21, 2014
  6. Aikar
    Aikar
    pt-online-schema-change - Percona Tools
    Oct 22, 2014