WordPress database error: [Can't create/write to file '/tmp/mysqltmp/#sql_1fd7_1.MYI' (Errcode: 2)]
SELECT ID, post_title FROM wp_posts LEFT JOIN wp_ak_popularity pop ON wp_posts.ID = pop.post_id WHERE post_status = 'publish' AND post_date < NOW() GROUP BY wp_posts.ID ORDER BY pop.total DESC LIMIT 10

WordPress database error: [Can't create/write to file '/tmp/mysqltmp/#sql_1fd7_1.MYI' (Errcode: 2)]
SELECT ID, post_title, COUNT(wp_comments.comment_post_ID) AS 'comment_count' FROM wp_posts, wp_comments WHERE comment_approved = '1' AND wp_posts.ID=wp_comments.comment_post_ID AND post_status = 'publish' AND post_password ='' GROUP BY wp_comments.comment_post_ID ORDER BY comment_count DESC LIMIT 10

WordPress database error: [Can't create/write to file '/tmp/mysqltmp/#sql_1fd7_1.MYI' (Errcode: 2)]
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) INNER JOIN wp_term_taxonomy ON (wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id) WHERE 1=1 AND wp_term_taxonomy.taxonomy = 'category' AND wp_term_taxonomy.term_id IN ('13') AND post_type = 'post' AND (post_status = 'publish') GROUP BY wp_posts.ID ORDER BY post_date desc LIMIT 0, 10