MySQL server Load is 100% CPU
I don't see the configurations are rightly set for memory. Hope you are using innodb engine. 

Use this to fill basic my.cnf to effectively make user of your server setup. https://tools.percona.com/wizard