Skip to main content
UNA Community Management System UNA Community Management System UNA Community Management System UNA Community Management System
  • Platform
  • Resources
  • Community
  • Pricing
innodb really needed? Comment
    •  ·  Alex T⚜️
    •  ·  2019-07-11T10:02:04+0000

    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 # or tx_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
    

    #innodb

    • See older replies...
    • T

      •  ·  titanium
      •  ·  In reply to
        Alex T⚜️
      •  ·  2020-11-01T08:27:29+0000

      When you say "server side settings for MYSQL in mysqld section" - do you mean that we just need to add those lines to /etc/mysql/my.cnf?

        •  ·  LeonidS
        •  ·  In reply to

          T

          titanium
        •  ·  2020-11-01T17:57:14+0000

        Yes, but MySQL recommends to use /etc/mysql.cnf https://dev.mysql.com/doc/refman/8.0/en/server-options.html

        • T

          •  ·  titanium
          •  ·  In reply to
            LeonidS
          •  ·  2020-11-01T18:08:05+0000

          Yes, but MySQL recommends to use /etc/mysql.cnf https://dev.mysql.com/doc/refman/8.0/en/server-options.html

          Ok thanks!

        See more...
        • Features
        • Pricing
        • Forum
        • Blog
        • Market
        • About
        • Copyright
        • Contact
        • Terms
        • Privacy
        • 𝕏
        Search
        UNA Community Management System UNA Community Management System UNA Community Management System UNA Community Management System
      • Platform
        • Features
        • Core CMS
      • Resources
        • Documentation
        • Marketplace
        • Discussions
        • Support Groups
        • API Reference
        • UNA CMS on GitHub
        • Webinars
        • Blog
      • Community
        • Discussions
        • Groups
        • Webinars
      • Pricing
      • Are you sure?
        Please, enter a value here