Comment to 'innodb really needed?'
  • It's possible to use InnoDB with UNA, it's functioning better in hight concurrency, but some server side tuning is needed to avoid deadlocks. 

    First set (or add) the following line into inc/header.inc.php 

    define('BX_DATABASE_ENGINE', 'INNODB'); ///< db engine

    after 

    define('BX_DATABASE_NAME', 'xxxxxx'); ///< db name

    Then the following server side settings for MySQL is needed in [mysqld] section:

    innodb_stats_on_metadata = off
    innodb_buffer_pool_instances = 4 # number of CPUs
    innodb_buffer_pool_size = 4096M # ~80% of available RAM
    
    transaction_isolation = READ-COMMITTED
    lock_wait_timeout = 4
    innodb_lock_wait_timeout = 4
    innodb_rollback_on_timeout = 1
    binlog_format = MIXED
    innodb_log_file_size = 400M



    0 0 0 0 0 0
    • I'm still between Maria DB and updating. Did you have to make any big changes before upgrading to mariadb. I also seen your post there about Inoodb not being all that good, If I could just update to Maria DB and have less of a hassle that may be the best route? Was any table conversion needed especially for Aria? From what I have seen with Maria DB so far is it may be the best route based on my research. 

      0 0 0 0 0 0
      • İf the server resources are very limited, go to Mariadb and disable inno, enable aria engine as described in previous posts.

        İf your site is/ will be very active and there are enough server resources innodb is good.

        But first thing first setup a trial server :)

        0 0 0 0 0 0
        • Alex T⚜️ I made the changes mentioned above and have seen about a 30% improvement in page loads on my site. Will continue to assess as site activity picks up and report back.  Thank you for this.

          0 0 0 0 0 0

        UNA - Social Media Software Framework

        Close