Missing index in table mail_user
Looking at slow query report of mysql I found that there is a query can't use an index. The general query is: SELECT email, password, "", uid, gid, homedir, maildir, concat(quota,'S'), "", "" FROM mail_user WHERE email = "aa@bb.cc" AND (access='y');
Missing index for where clause, added a new index on fields (email,access)