i facing this problem 3 weeks ago until now i’m running 4 core ubuntu 16.04 16gb ram and i followed the performance tuning wiki page notes but still facing performance issues with 11 pos machine live plus 5 users at backend
Try tuning your innodb_buffer_pool_size. Try first with 2GB while innodb_buffer_pool_instances is set to 2. See if there is a change in performance or not
No that would be a good setting for those who are running seperate servers for ERPNext and MariaDB i.e. an ERPNext instance with a remote database setup. Try tuning it down to something lesser according to your database size.
However innodb_buffer_pool_size won’t solve the high CPU usage by gunicorn. I’ll see if this has been raised on the forum and get back to you.
EDIT : I found this link which has similar POS problem like yours
It is recommended by a user to try and experiment with varying number of gunicorn workers. You can find out the gunicorn worker numbers in your currentsite’s site_config.json