Views performance issue
The process list is saying that Mysql is writing to tmp tables.  The issue is the way you configured mysql.  Check the my.cnf configuration, and make sure that the temporary tables are large enough.