Hosting Server Setup Recommendations for Optimal UNA Performance

Could UNA team write a guide on which to rely to make the correct settings on our servers? It was done for Dolphin and I think he has served a lot.

  • 678
  • More
Replies (19)
    • The common recommendations are the same as for Dolphin:
      https://www.boonex.com/trac/dolphin/wiki/HostingServerSetupRecommendations

      Additionally I would recommend to switch from MyISAM to InnoDB, it should perform much better in high concurrency. However you need to have some specific settings for InnoDB:
      https://una.io/cmts.php?sys=bx_forum&id=3139&cmt_id=13128

      • Hello,
        Thank you for contacting TMDHosting Support Team.
        We have reviewed your report and we would like to let you know that your current Virtual PRivate instance is configured with the requirements of the UNA application.
        Hence - you may proceed to install UNA as you see fit and work on it as you see fit.
        Considering this - do not hesitate to update us if we can be of any further assistance.
        Kind Regards,
        Ned Brewer
        Genius Support Team
        TMDHosting.com

        =================


        APP ANDROID HAVE ISSUES
        Any needed settings so android app to work?

        https://una.io/page/view-discussion?id=4266

        • Thanks Alex, I'll try this.

          • Alex, the second advice is important. My site was heavy in the evening and I noticed that 'load average' regularly exceeded 2.00 because of MySql, when I saw at the same time via Google Analytics a display rate of 40 pages / minute.
            I just went from MyISAM to InnoDB and applied the code change, under the same conditions, I get 'load average' 0.40 maximum and the site is very responsive. I did not expect so good results. Thank you !

            • I need some assistance with this Alex T⚜️ or Baloo 

              If I want to switch from MyISAM to InnoDB to help make my site faster, I understand the 1st part of adding 

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

              to my header.inc.php file but, where do I make the 2nd part of the changes?

              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

              Just for clarification, these settings will work with my existing MySQL database for my site right?

              • here may be we need to consider if our table structures for UNA are innoDb or myisam?
                In my tests for myisam ariadb as the engine seemed faster and less resource using then innodb.
                What do you think Alex T⚜️ ?

                • Hi Chris, in your MySql config file, in my case /etc/mysql/mysql.conf.d/mysqld.cnf

                  image_transcoder.php?o=bx_froala_image&h=2409&dpx=1&t=1572906480

                  • I am using Maria +Ariadb after intensive testings the best couple I found :)

                    • Hi Cem, in my case it's the opposite. But I am not in test, I am in real situation with a traffic which becomes more important at certain hours. Alex seems to say that he is more successful in this case only.

                      • Alex, the second advice is important. My site was heavy in the evening and I noticed that 'load average' regularly exceeded 2.00 because of MySql, when I saw at the same time via Google Analytics a display rate of 40 pages / minute.
                        I just went from MyISAM to InnoDB and applied the code change, under the same conditions, I get 'load average' 0.40 maximum and the site is very responsive. I did not expect so good results. Thank you !

                        Baloo did this really make your site load faster?

                        • Yes, really +++ tonight it was very nice to sail, it's been a few weeks since it was not the case. I did not say anything, several members told me, did you do something? he is faster. Now, you have to see what is stuck in your home. You can run the 'top' command in a terminal and see if MySql is stuck.

                          • But did you try Maria with Ariadb? it is tailored for myisam tables like we have in UNA db.

                            Standart mysql was not succesfull like Maria+Ariadb

                              • No, I have not tried yet, so I do not compare with Maria here. I was considering it, but as it works well now, I keep this solution for the next slowdown.

                                • Chris you also need to convert your tables from MyISAM to InnoDB

                                  • Cem  I didn't check/test AriaDB yet, but generally if AriaDB is new version of MyISAM then if you have no high concurrency then it should work definitely faster.

                                    • Perhaps in the installation guide it should mention using InnoDB as the engine.

                                      • That would be awesome. And also tell the hosting companies who have the softalicious installer to make it so.

                                        • We can't make it as an option during install, because it requires special server settings and actually needed for high load sites only, so anyway it requires many manual steps and not required in 99% cases.

                                          Login or Join to comment.