I've told MySQL to log queries that take longer than a second (1
in the config)... however I'm seeing queries like this that take much less than a second....
# Time: 101108 6:39:32
# User@Host: source_member[source_member] @ localhost []
# Query_time: 0.007271 Lock_time: 0.000062 Rows_sent: 1 Rows_examined: 2635
SET timestamp=1289216372;
SELECT
id,
name,
email,
auth_key
FROM member
INNER JOIN source_member.group_assoc ON (
source_member.group_assoc.group_id = 121 AND
source_member.group_assoc.member_id = member.id
);
My settings are...
log_slow_queries = /var/log/mysql/mysql-slow.log
long_query_time = 1
log-queries-not-using-indexes
I should ask... this means that it's only logging queries that do not have any indexes at all?