1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Percona questions - InnoDB to XtraDB and performance benefits

Discussion in 'Server Configuration and Hosting' started by karll, Oct 18, 2014.

  1. karll

    karll Well-Known Member

    Is the InnoDB on Percona Server really XtraDB, so if I switch my XF board to Percona, I will get XtraDB without any extra work? Or will I have to manually migrate the InnoDB tables to XtraDB?

    I have a VPS with 1G RAM, currently running Oracle's MySQL 5.5. Is switching to Percona a good idea? I don't mind the work involved at all, but unsure of the benefits.
     
  2. MattW

    MattW Well-Known Member

    You don't have to actually do anything. The XtraDB storage engine is basically their patched version of InnoDB.
     
    karll likes this.
  3. karll

    karll Well-Known Member

    Ah, excellent. Thank you.

    What is memory usage like for Percona vs. Oracle's MySQL? Will Percona eat up my limited amount of memory?

    The vast amount of XF tables are InnoDB, but a few that sound crucial for performance (to do with sessions and searching) are MyISAM. I've read that MariaDB does a better job with MyISAM ...

    Any and all thoughts on this are welcome!
     
  4. MattW

    MattW Well-Known Member

    It won't use any more memory for the InnoDB tables than the Oracle version does. I use all 3 versions on different servers I have, and loading the same DB into all 3 of them shows the same usage. MariaDB has the XtraDB plugin provided by Percona, plus their own MyISAM improvements.
     
  5. Mouth

    Mouth Well-Known Member

  6. HWS

    HWS Well-Known Member

    There shouldn't be any MyISAM tables in xenforos database and there is absolutely no need for them. If you have some (happens some times with some badly coded add-ons), you should convert it to InnoDB asap. The only other table engine used by XenForo is "Memory" for the session table.
     
    Xon likes this.
  7. MattW

    MattW Well-Known Member

    There are 3 default MyISAM tables within XF

    xf_search_index
    xf_session
    xf_session_admin
     
  8. karll

    karll Well-Known Member

    Well, this is only a VPS with 1G RAM. Not really sure what the system requirements are for the various cache back-end options. Maybe I could still be using a file back-end?
     

Share This Page