So I have only 12 slow queries after 2 hours
Uptime: 2 hours 25 sec
Threads: 1 Questions: 893621 Slow queries: 12 Opens: 408456 Flush tables: 1 Open tables: 2048 Queries per second avg: 123.685But in /var/log/mysql/mysql-slow.log I have queries like that:
# Time: 070123 22:12:30
# User@Host: pun[pun] @ localhost []
# Query_time: 11 Lock_time: 0 Rows_sent: 17 Rows_examined: 1594191
use pun_klasa3h;
SELECT u.email, u.title, u.url, u.yahoo, u.location, u.use_avatar, u.aim, u.msn, u.signature, u.email_setting, u.num_posts, u.registered, u.admin_note, SUM(r.rep_plus) AS count_rep_plus, SUM(r.rep_minus) AS count_rep_minus, u.reputation_enable, p.id, p.poster AS username, p.poster_id, p.poster_ip, p.poster_email, p.message, p.hide_smilies, p.posted, p.edited, p.edited_by, g.g_id, g.g_user_title, o.user_id AS is_online FROM posts AS p INNER JOIN users AS u ON u.id=p.poster_id INNER JOIN groups AS g ON g.g_id=u.group_id LEFT JOIN online AS o ON (o.user_id=u.id AND o.user_id!=1 AND o.idle=0) LEFT JOIN reputation as r ON (r.user_id=u.id) WHERE p.topic_id=101 GROUP BY p.id ORDER BY p.id LIMIT 2000,25;
What is wrong ?
