Printable View
http://gyazo.com/4f9c637db19638c3cb5d32829ecac7ea.png
Is this normal? My VPS has 4 gb ram and 4 CPU cores, however my CPU is always around 0-5% so not that high with this high memory. I use on my retro RevCMS, MariaDB and Phoenix.
How can I lower it?
I recommend you to download the latest Mysql Server.
What is better: that Mysql server or mariadb?Quote:
Originally Posted by Sir Jamal
You can use better MySQL server, and it is all about the settings.
I recommend that you use MariaDB.
MariaDB and phoenix are not good together. Because phoenix use alot CPU, mariadb can not handle that. Before you 'recommend' something know you facts, please. Do not recommend wrong things.Quote:
Originally Posted by JerryCool
This is most likely due to the poolsize. Here (https://tools.percona.com/wizard) is a handy tool for helping w/ your configuration. I do suggest having a Google for certain variables in the configuration though, certain values require being worked out from your usage, for best preformance.
You're talking rubbish. Its most likely due to poor configuration. MariaDB is just an improved MySQL fork. I've used MariaDB on a hotel with 1,000+ users & with Phoenix and ran fine. I still use MariaDB and perfectly hold over 1,000 - 1,400 daily.Quote:
Originally Posted by Vimsoration
Take your own advice.Quote:
Originally Posted by Vimsoration
Are you sure???Quote:
Originally Posted by Vimsoration
http://lightpics.net/images/2015/06/...5736301_n1.jpg
Try to optimize your my.cnf with mysqltuner/ and mysql-primer
MariaDB is by far superior to MySQL if you configure it correctly. The founder of MySQL is the current lead developer of MariaDB.
You don't know what you're talking about. I host 10,000 players concurrently using MariaDB with databases adding up to over 1TB in size without issue. Do your research before commenting next time.Quote:
Originally Posted by Vimsoration
Yes i am sure. Do you want to tell me that 3 hours and 4 minutes is a nice uptime? Your phoenix emulator with mariadb will not hold it with 3/4 days uptime before it lags. You guys do not even now what stability means.Quote:
Originally Posted by Mathis Hbx
Thats normal Phoenix is bad, with my butterfly i held 15 days with 2k3 onlines and with Comet.. :lol::lol: 1 month. So i don't have idea what is the stability?Quote:
Originally Posted by Vimsoration
Alright. :wink:Quote:
Originally Posted by Vimsoration
With MySQL community server you will hold it longer. @Leon, you dont host a hotel. A hotel is heavier then your site with probably 6 pages.Quote:
Originally Posted by Mathis Hbx
Quote:
Originally Posted by Vimsoration
Are you sure?