WHM check user resource consumption

CloudLinux Manager > Users > Choose user > History

Munin > MySQL CPU Time by User (how many cores a users consumes for MySQL usage)

Munin > MySQL Queries per Second by User

Munin > System > CPU usage (for a general overview of CPU usage)