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

Upgrade to Percona Server on a Plesk Server or VPS

Supercharge your XenForo Board by installing Percona Server on Plesk

  1. Slavik

    Slavik XenForo Moderator Staff Member

    Slavik submitted a new resource:

    Upgrade to Percona Server on a Plesk Server or VPS - Supercharge your XenForo Board by installing Percona Server on Plesk

    Read more about this resource...
     
  2. Slavik

    Slavik XenForo Moderator Staff Member

  3. p4guru

    p4guru Well-Known Member

    Great guide, more folks moving away from Oracle MySQL the better :)
     
  4. Marcus

    Marcus Well-Known Member

    You may have to add these steps as my.cnf is not included within Pecona releases (yet):

    1. create /etc/my.cnf with the right values (https://tools.percona.com/wizard/)
    2. rename /var/lib/mysql/ib_logfile* files if you change innodb_log_file_size to a different file size than these files.Without the right file size, Pecona won't start. If Pecona can not find these fields, it creates it on its own. There may be problems with the caching system if you just change the files, I don't know more about that.
    3. "/etc/init.d/mysql restart"
     
    Last edited: Aug 18, 2013
  5. Slavik

    Slavik XenForo Moderator Staff Member

    Remove the SQL mode line

    Your innodb bufferpool is set to 54G?
     
  6. Marcus

    Marcus Well-Known Member

    That helped :) I have 64 GB RAM for my community server. Pecona set the value to 54G but what do you think? Is it more useful to add cache to nginx or PHP? It's not my expertise field.
     
  7. Marcus

    Marcus Well-Known Member

    with outcommenting
    PHP:
    #sql_mode  = STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_AUTO_VALUE_ON_ZERO,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE,ONLY_FULL_GROUP_BY
    its still slow :/
    PHP:
    INSERT INTO xf_session_activity (user_idunique_keyipcontroller_namecontroller_actionview_stateparamsview_daterobot_keyVALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) ON DUPLICATE KEY UPDATE ip VALUES(ip), controller_name VALUES(controller_name), controller_action VALUES(controller_action), view_state VALUES(view_state), params VALUES(params), view_date VALUES(view_date), robot_key VALUES(robot_key)
    Params1171171556707374XenForo_ControllerPublic_ForumIndexvalidnode_name=, 1376824387,
    Run Time0.109770
     
  8. Slavik

    Slavik XenForo Moderator Staff Member

    Binary logging will slow things down slightly,

    It can also be amplified by your filesystem type.
     
  9. Marcus

    Marcus Well-Known Member

    Outcommenting like this helped :)
    PHP:
    # BINARY LOGGING #
    #log_bin  = /var/lib/mysql/mysql-bin
    #expire_logs_days  = 14
    #sync_binlog  = 1
     
  10. Slavik

    Slavik XenForo Moderator Staff Member

    I cant remember the exact setting now, but if your OS filesystem is ACID complient, enabling strict synced logging takes a massive effect.
     

Share This Page