|
إنضمامك إلي منتديات استراحات زايد يحقق لك معرفة كل ماهو جديد في عالم الانترنت ...
انضم الينا
#1
| ||
| ||
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 111 # 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 120 # 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 sql log.txt‎ (97.6 KB) __DEFINE_LIKE_SHARE__ |
مواقع النشر (المفضلة) |
| |
المواضيع المتشابهه | ||||
الموضوع | كاتب الموضوع | المنتدى | مشاركات | آخر مشاركة |
Forum Questions and problem. Please help. (link parsing & code tag problem) | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 03-14-2010 07:11 AM |
Blog embed video problem and poll bar problem | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 02-11-2010 03:20 AM |
Adding new infraction problem (language problem ?) | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 12-21-2009 01:50 PM |
long_query problem | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 06-27-2009 07:40 PM |
Single user Lightbox problem (not a vB problem) | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 06-12-2009 12:20 AM |