# Time: 080510 17:28:09
# User@Host: root[root] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 20 Rows_examined: 68450
SELECT *, MAX(a.id) AS sort_id, MAX(a.time) AS sort_time, MAX(a.hits) AS sort_hits, a.topic_emoticon, COUNT(a.catid) AS count FROM jos_fb_messages AS a , jos_fb_categories AS b WHERE b.id = a.catid AND b.published=1 AND b.pub_access<=0 GROUP BY thread ORDER BY sort_time DESC LIMIT 20;
# User@Host: root[root] @ localhost []
# Query_time: 4 Lock_time: 0 Rows_sent: 20 Rows_examined: 68450
SELECT *, MAX(a.id) AS sort_id, MAX(a.time) AS sort_time, MAX(a.hits) AS sort_hits, a.topic_emoticon, COUNT(a.catid) AS count FROM jos_fb_messages AS a , jos_fb_categories AS b WHERE b.id = a.catid AND b.published=1 AND b.pub_access<=0 GROUP BY thread ORDER BY sort_time DESC LIMIT 20;
# Time: 080510 17:28:13
# User@Host: root[root] @ localhost []
# Query_time: 8 Lock_time: 0 Rows_sent: 20 Rows_examined: 68450
SELECT *, MAX(a.id) AS sort_id, MAX(a.time) AS sort_time, MAX(a.hits) AS sort_hits, a.topic_emoticon, COUNT(a.catid) AS count FROM jos_fb_messages AS a , jos_fb_categories AS b WHERE b.id = a.catid AND b.published=1 AND b.pub_access<=0 GROUP BY thread ORDER BY sort_time DESC LIMIT 20;
# Time: 080510 17:28:14
# User@Host: root[root] @ localhost []
# Query_time: 5 Lock_time: 0 Rows_sent: 20 Rows_examined: 68450
SELECT *, MAX(a.id) AS sort_id, MAX(a.time) AS sort_time, MAX(a.hits) AS sort_hits, a.topic_emoticon, COUNT(a.catid) AS count FROM jos_fb_messages AS a , jos_fb_categories AS b WHERE b.id = a.catid AND b.published=1 AND b.pub_access<=0 GROUP BY thread ORDER BY sort_time DESC LIMIT 20;
# Time: 080510 17:28:15
# User@Host: root[root] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 20 Rows_examined: 68450
SELECT *, MAX(a.id) AS sort_id, MAX(a.time) AS sort_time, MAX(a.hits) AS sort_hits, a.topic_emoticon, COUNT(a.catid) AS count FROM jos_fb_messages AS a , jos_fb_categories AS b WHERE b.id = a.catid AND b.published=1 AND b.pub_access<=25 GROUP BY thread ORDER BY sort_time DESC LIMIT 20;
This is my mysql slow query log file. Can someone help me i have version 1.0.4 i have a single site and forum on Core 2 Duo cpu 3Gram and i have load avarage: 5
Can someone point to me where can i look for the problem. I have disabled recent posts and stats in the Fireboard configuration.
This is link to the forum:
http://www.kadevecer.com.mk/index.php?option=com_fireboard @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 20 Rows_examined: 68450
SELECT *, MAX(a.id) AS sort_id, MAX(a.time) AS sort_time, MAX(a.hits) AS sort_hits, a.topic_emoticon, COUNT(a.catid) AS count FROM jos_fb_messages AS a , jos_fb_categories AS b WHERE b.id = a.catid AND b.published=1 AND b.pub_access<=0 GROUP BY thread ORDER BY sort_time DESC LIMIT 20;
# User@Host: root[root] @ localhost []
# Query_time: 4 Lock_time: 0 Rows_sent: 20 Rows_examined: 68450
SELECT *, MAX(a.id) AS sort_id, MAX(a.time) AS sort_time, MAX(a.hits) AS sort_hits, a.topic_emoticon, COUNT(a.catid) AS count FROM jos_fb_messages AS a , jos_fb_categories AS b WHERE b.id = a.catid AND b.published=1 AND b.pub_access<=0 GROUP BY thread ORDER BY sort_time DESC LIMIT 20;
# Time: 080510 17:28:13
# User@Host: root[root] @ localhost []
# Query_time: 8 Lock_time: 0 Rows_sent: 20 Rows_examined: 68450
SELECT *, MAX(a.id) AS sort_id, MAX(a.time) AS sort_time, MAX(a.hits) AS sort_hits, a.topic_emoticon, COUNT(a.catid) AS count FROM jos_fb_messages AS a , jos_fb_categories AS b WHERE b.id = a.catid AND b.published=1 AND b.pub_access<=0 GROUP BY thread ORDER BY sort_time DESC LIMIT 20;
# Time: 080510 17:28:14
# User@Host: root[root] @ localhost []
# Query_time: 5 Lock_time: 0 Rows_sent: 20 Rows_examined: 68450
SELECT *, MAX(a.id) AS sort_id, MAX(a.time) AS sort_time, MAX(a.hits) AS sort_hits, a.topic_emoticon, COUNT(a.catid) AS count FROM jos_fb_messages AS a , jos_fb_categories AS b WHERE b.id = a.catid AND b.published=1 AND b.pub_access<=0 GROUP BY thread ORDER BY sort_time DESC LIMIT 20;
# Time: 080510 17:28:15
# User@Host: root[root] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 20 Rows_examined: 68450
SELECT *, MAX(a.id) AS sort_id, MAX(a.time) AS sort_time, MAX(a.hits) AS sort_hits, a.topic_emoticon, COUNT(a.catid) AS count FROM jos_fb_messages AS a , jos_fb_categories AS b WHERE b.id = a.catid AND b.published=1 AND b.pub_access<=25 GROUP BY thread ORDER BY sort_time DESC LIMIT 20;
This is my mysql slow query log file. Can someone help me i have version 1.0.4 i have a single site and forum on Core 2 Duo cpu 3Gram and i have load avarage: 5
Can someone point to me where can i look for the problem. I have disabled recent posts and stats in the Fireboard configuration.
This is link to the forum:
http://www.kadevecer.com.mk/index.php?option=com_fireboard @ localhost []
# Query_time: 4 Lock_time: 0 Rows_sent: 20 Rows_examined: 68450
SELECT *, MAX(a.id) AS sort_id, MAX(a.time) AS sort_time, MAX(a.hits) AS sort_hits, a.topic_emoticon, COUNT(a.catid) AS count FROM jos_fb_messages AS a , jos_fb_categories AS b WHERE b.id = a.catid AND b.published=1 AND b.pub_access<=0 GROUP BY thread ORDER BY sort_time DESC LIMIT 20;
# Time: 080510 17:28:13
# User@Host: root[root] @ localhost []
# Query_time: 8 Lock_time: 0 Rows_sent: 20 Rows_examined: 68450
SELECT *, MAX(a.id) AS sort_id, MAX(a.time) AS sort_time, MAX(a.hits) AS sort_hits, a.topic_emoticon, COUNT(a.catid) AS count FROM jos_fb_messages AS a , jos_fb_categories AS b WHERE b.id = a.catid AND b.published=1 AND b.pub_access<=0 GROUP BY thread ORDER BY sort_time DESC LIMIT 20;
# Time: 080510 17:28:14
# User@Host: root[root] @ localhost []
# Query_time: 5 Lock_time: 0 Rows_sent: 20 Rows_examined: 68450
SELECT *, MAX(a.id) AS sort_id, MAX(a.time) AS sort_time, MAX(a.hits) AS sort_hits, a.topic_emoticon, COUNT(a.catid) AS count FROM jos_fb_messages AS a , jos_fb_categories AS b WHERE b.id = a.catid AND b.published=1 AND b.pub_access<=0 GROUP BY thread ORDER BY sort_time DESC LIMIT 20;
# Time: 080510 17:28:15
# User@Host: root[root] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 20 Rows_examined: 68450
SELECT *, MAX(a.id) AS sort_id, MAX(a.time) AS sort_time, MAX(a.hits) AS sort_hits, a.topic_emoticon, COUNT(a.catid) AS count FROM jos_fb_messages AS a , jos_fb_categories AS b WHERE b.id = a.catid AND b.published=1 AND b.pub_access<=25 GROUP BY thread ORDER BY sort_time DESC LIMIT 20;
This is my mysql slow query log file. Can someone help me i have version 1.0.4 i have a single site and forum on Core 2 Duo cpu 3Gram and i have load avarage: 5
Can someone point to me where can i look for the problem. I have disabled recent posts and stats in the Fireboard configuration.
This is link to the forum:
http://www.kadevecer.com.mk/index.php?option=com_fireboard @ localhost []
# Query_time: 8 Lock_time: 0 Rows_sent: 20 Rows_examined: 68450
SELECT *, MAX(a.id) AS sort_id, MAX(a.time) AS sort_time, MAX(a.hits) AS sort_hits, a.topic_emoticon, COUNT(a.catid) AS count FROM jos_fb_messages AS a , jos_fb_categories AS b WHERE b.id = a.catid AND b.published=1 AND b.pub_access<=0 GROUP BY thread ORDER BY sort_time DESC LIMIT 20;
# Time: 080510 17:28:14
# User@Host: root[root] @ localhost []
# Query_time: 5 Lock_time: 0 Rows_sent: 20 Rows_examined: 68450
SELECT *, MAX(a.id) AS sort_id, MAX(a.time) AS sort_time, MAX(a.hits) AS sort_hits, a.topic_emoticon, COUNT(a.catid) AS count FROM jos_fb_messages AS a , jos_fb_categories AS b WHERE b.id = a.catid AND b.published=1 AND b.pub_access<=0 GROUP BY thread ORDER BY sort_time DESC LIMIT 20;
# Time: 080510 17:28:15
# User@Host: root[root] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 20 Rows_examined: 68450
SELECT *, MAX(a.id) AS sort_id, MAX(a.time) AS sort_time, MAX(a.hits) AS sort_hits, a.topic_emoticon, COUNT(a.catid) AS count FROM jos_fb_messages AS a , jos_fb_categories AS b WHERE b.id = a.catid AND b.published=1 AND b.pub_access<=25 GROUP BY thread ORDER BY sort_time DESC LIMIT 20;
This is my mysql slow query log file. Can someone help me i have version 1.0.4 i have a single site and forum on Core 2 Duo cpu 3Gram and i have load avarage: 5
Can someone point to me where can i look for the problem. I have disabled recent posts and stats in the Fireboard configuration.
This is link to the forum:
http://www.kadevecer.com.mk/index.php?option=com_fireboard @ localhost []
# Query_time: 5 Lock_time: 0 Rows_sent: 20 Rows_examined: 68450
SELECT *, MAX(a.id) AS sort_id, MAX(a.time) AS sort_time, MAX(a.hits) AS sort_hits, a.topic_emoticon, COUNT(a.catid) AS count FROM jos_fb_messages AS a , jos_fb_categories AS b WHERE b.id = a.catid AND b.published=1 AND b.pub_access<=0 GROUP BY thread ORDER BY sort_time DESC LIMIT 20;
# Time: 080510 17:28:15
# User@Host: root[root] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 20 Rows_examined: 68450
SELECT *, MAX(a.id) AS sort_id, MAX(a.time) AS sort_time, MAX(a.hits) AS sort_hits, a.topic_emoticon, COUNT(a.catid) AS count FROM jos_fb_messages AS a , jos_fb_categories AS b WHERE b.id = a.catid AND b.published=1 AND b.pub_access<=25 GROUP BY thread ORDER BY sort_time DESC LIMIT 20;
This is my mysql slow query log file. Can someone help me i have version 1.0.4 i have a single site and forum on Core 2 Duo cpu 3Gram and i have load avarage: 5
Can someone point to me where can i look for the problem. I have disabled recent posts and stats in the Fireboard configuration.
This is link to the forum:
http://www.kadevecer.com.mk/index.php?option=com_fireboard @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 20 Rows_examined: 68450
SELECT *, MAX(a.id) AS sort_id, MAX(a.time) AS sort_time, MAX(a.hits) AS sort_hits, a.topic_emoticon, COUNT(a.catid) AS count FROM jos_fb_messages AS a , jos_fb_categories AS b WHERE b.id = a.catid AND b.published=1 AND b.pub_access<=25 GROUP BY thread ORDER BY sort_time DESC LIMIT 20;
This is my mysql slow query log file. Can someone help me i have version 1.0.4 i have a single site and forum on Core 2 Duo cpu 3Gram and i have load avarage: 5
Can someone point to me where can i look for the problem. I have disabled recent posts and stats in the Fireboard configuration.
This is link to the forum:
http://www.kadevecer.com.mk/index.php?op...ard&Itemid=11448
Favoured: 0
