long_query problem
 

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 :
Code:
# 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 :

Code:
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

Code:
# 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 !

Attached Files http://www.vbulletin.com/forum/images/attach/txt.gif log.txt‎ (97.6 KB)