Triggers or views on frequently updating table
... not more than 50k records ... database server consumes almost 100% 


Heavy CPU load suggests (to me) that there's lots of stuff happening in memory, which suggests poorly performing queries doing a lot of table scanning.  

Look in the Slow Query log to see which queries are taking along time to run and look to tune them.