long_query problem

[Nassou]

Hello everybody ;

I have some problems with long-query-log , the forum is very stable but it's not ok in the log , i explain :

I have set up this configuration on my.cnf :

# Here you can see queries with especially long duration
log_slow_queries    = /var/log/mysql/mysql-slow.log
long_query_time = 4

With this configuration i don't have a lot of long_query , logs look :

Time                 Id Command    Argument
# Time: 090627  1:00:11
# User@Host: xxx[xxx] @ localhost []
# Query_time: 6  Lock_time: 0  Rows_sent: 239788  Rows_examined: 239788
use database;
SELECT /*!40001 SQL_NO_CACHE */ * FROM `post`;
# Time: 090627  1:00:20
# User@Host: xxxx[xxxx] @ localhost []
# Query_time: 8  Lock_time: 0  Rows_sent: 3741271  Rows_examined: 3741271
SELECT /*!40001 SQL_NO_CACHE */ * FROM `postindex`;

I don't understand what this messages means.

And this is , my log error with this configuration when i added ( > log-queries-not-using-indexes ) on my.cnf

# Here you can see queries with especially long duration
log_slow_queries    = /var/log/mysql/mysql-slow.log
long_query_time = 4
log-queries-not-using-indexes

Because the log are too long , i have decided to upload this , please download the attachement file to see the log.


Some one can explain me , what can i do to resolve this problem ?

Thanks !