MariaDB Overload :((

Depending on MySQL usage activity that can be normal as MySQL/MariaDB is multi threaded in nature so uses as many cpu cores/threads as needed i.e. 200% = 2 cpu threads in use, 250% = 2.5 cpu threads in use - all normal. Unfortunately, Centmin Mod is provided as is, it's up to you yourself to optimise and tune your server settings for your specific loads.

Some hints on where to look for config/setting files for respective software below:

Official site FAQ item 16 & 19 has some info at Centmin Mod FAQ - Menu based Nginx installer as does PHP-FPM page at PHP PHP-FPM - Centmin Mod - Menu based Nginx installer for CentOS servers and Centmin Mod Insights forum i.e. PHP Opcode and Memcached statistics pages | Centmin Mod Community

As to specific values, optimisation is left to end user as I provide Centmin Mod as is.. forum search has some hints i.e. PHP-FPM - pm.max_children | Centmin Mod Community

For MySQL, look at my mysqlmymonlite.sh addon which allows you to gather all relevant stats quickly Add Ons | Centmin Mod Community What you do with those stats are up to you i.e. provide it to hired consultants or post on forums (not necessarily this forum) in CODE tags for respective advice. I do not provide optimisation advice for free though, but other members are free to offer advice if they want.

Also cpu load of 12 is cummulative over all cpu threads. So if you have a 12 cpu thread server, cpu load of 12 is really only 12/12 = cpu load average of 1.0 or 100% which is normal. If only 6 cpu threads, then cpu load of 12 = 12/6 = cpu load average of 2.0 or 200% which is high but can still be within normal depending on age and architecture of the cpu model/brand used.

And as to TOP stats meaning read top - Linux Command - Unix Command

 

My optimisation consult rates start in the 4 figure $$$$ range for minimum of 4 days work however I am pretty much booked up in advance with paid up clients until end of February 2015 right now and still have dozens of enquiring clients each day. To contact me for such work or details and my schedule, you need to contact me via my blog at Contact | vbtechsupport.com

 

well you need to figure out how mysql is utilisation so much cpu time and what for - my mysqlmymonlite.sh script mentioned in 2nd post should be able to quickly gather all relevant stats for brief summary - may need further analysis to get to bottom of it though. Sample output of all stats gathered by mysqlmymonlite.sh is displayed at mysqlmymonlite.sh & mysqlmymon.sh server and mysql stats gathering tool

Also might want to ask @Matt who is a Centmin Mod Community moderator and also has his own paid services Moderator appointments = Matt | Centmin Mod Community

 

You'll have to figure it out on your own - unfortunately, I already have dozens of paying consult clients I need to prioritise first.

For mysqlmymonlite - if you check out web site's example displayed stats at mysqlmymon.com, next to each example there's a column linking to info and documentation regarding each of the example displayed stats for you to understand what you're seeing.