CPU,Memory and disk I/O utilization for each query in mysql
Using IOTOP command you can see CPU,Memory and disk I/O utilization for each query. For each query mysql generates an ID. You can find CPU,Memory and disk I/O utilization against your query ID.

How ever you may find more command in detail at http://www.dbatodba.com/db2/useful-aix-commands/monitor-cpu-mem-and-i-o-usage/

SET profiling = 100 
-- Now you can find query ID and running sql query by 
SHOW PROFILES; IF you want TO CHECK IN detail FOR ANY QUERY, run this QUERY- 
-- SHOW PROFILE FOR QUERY QueryID; 
-- If you want to check CPU USAGE for any query, run this query- 
SHOW PROFILE CPU FOR QUERY QueryID;