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.
-
-
·
Alex T⚜️
- ·
The common recommendations are the same as for Dolphin:
https://www.boonex.com/trac/dolphin/wiki/HostingServerSetupRecommendationsAdditionally 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 -
·
Alex T⚜️
-
- · Expertzkris
- ·
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? -
- · Baloo
-
·
In reply to Alex T⚜️
- ·
Thanks Alex, I'll try this.
-
- · Baloo
-
·
In reply to Baloo
- ·
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 ! -
- · Chris
- ·
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 = 400MJust for clarification, these settings will work with my existing MySQL database for my site right?
-
- · Cem
-
·
In reply to Chris
- ·
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⚜️ ? -
- · Baloo
-
·
In reply to Chris
- ·
Hi Chris, in your MySql config file, in my case /etc/mysql/mysql.conf.d/mysqld.cnf
-
- · Cem
- ·
I am using Maria +Ariadb after intensive testings the best couple I found :)
-
- · Baloo
-
·
In reply to Cem
- ·
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.
-
- · Will Monte
-
·
In reply to Baloo
- ·
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?
-
- · Baloo
-
·
In reply to Will Monte
- ·
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.
-
- · Cem
-
·
In reply to Baloo
- ·
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
-
- · Will Monte
-
·
In reply to Baloo
- ·
Nice!!
-
- · Baloo
-
·
In reply to Cem
- ·
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.
-
-
·
Alex T⚜️
-
·
In reply to Chris
- ·
Chris you also need to convert your tables from MyISAM to InnoDB
-
·
Alex T⚜️
-
-
·
Alex T⚜️
-
·
In reply to Cem
- ·
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.
-
·
Alex T⚜️
-
- · unknown
- ·
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.
-
-
·
Alex T⚜️
-
·
In reply to unknown
- ·
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.
-
·
Alex T⚜️