Question Kunena DATABASE problem!

Hi,
i have upgraded from simpleboard to fireboard ALL VERSIONS, and now to Kunena i have always had problems with slow database server, now it is the worse, this is only a small part from my mysql SLOW log:

# Time: 090223 16:50:01
# User@Host: root[root] @ localhost []
# Query_time: 455 Lock_time: 0 Rows_sent: 5184 Rows_examined: 19440020
SELECT
a.id,
a.parent,
a.thread,
a.catid,
a.subject,
a.name,
a.time,
a.topic_emoticon,
a.locked,
a.ordering,
a.userid ,
a.moved,
u.avatar
FROM jos_fb_messages AS a LEFT JOIN jos_fb_users AS u ON u.userid = a.userid
WHERE a.thread IN ('54355','32759','74876','68155','12959','9191','27886','11893','6447','38081','4236','5314','40554','30153','18508','10281','3275','61417','11829','51443')
AND a.id NOT IN ('54355','32759','74876','68155','12959','9191','27886','11893','6447','38081','4236','5314','40554','30153','18508','10281','3275','61417','11829','51443')
AND a.hold=0;
# Time: 090223 16:50:22
# User@Host: root[root] @ localhost []
# Query_time: 457 Lock_time: 0 Rows_sent: 5184 Rows_examined: 19440020
SELECT
a.id,
a.parent,
a.thread,
a.catid,
a.subject,
a.name,
a.time,
a.topic_emoticon,
a.locked,
a.ordering,
a.userid ,
a.moved,
u.avatar
FROM jos_fb_messages AS a LEFT JOIN jos_fb_users AS u ON u.userid = a.userid
WHERE a.thread IN ('54355','32759','74876','68155','12959','9191','27886','11893','6447','38081','4236','5314','40554','30153','18508','10281','3275','61417','11829','51443')
AND a.id NOT IN ('54355','32759','74876','68155','12959','9191','27886','11893','6447','38081','4236','5314','40554','30153','18508','10281','3275','61417','11829','51443')
AND a.hold=0;

Can enyone help me with this, should i post more from the log???

thanx

This is more from the SLOW log file from mysql:

# Time: 090223 16:59:45
# User@Host: root[root] @ localhost []
# Query_time: 5 Lock_time: 0 Rows_sent: 8 Rows_examined: 145728
SELECT q.maxid AS id, m.time, m.thread, n.hits, q.countid AS `count`, m.subject, m.userid, m.name, m.catid, q.catname, t.message , 0 AS unread
FROM
(SELECT max(m.id) AS maxid, count(m.id) AS countid, c.name AS catname
FROM jos_fb_messages AS m
JOIN jos_fb_categories as c ON m.catid = c.id
WHERE c.published = 1 AND m.hold = 0 AND m.moved = 0 AND c.pub_access in (0,1,-1,18)
GROUP BY m.thread ORDER BY maxid DESC LIMIT AS q
JOIN jos_fb_messages AS m ON q.maxid = m.id
JOIN jos_fb_messages AS n ON m.thread = n.id
JOIN jos_fb_messages_text AS t ON q.maxid = t.mesid;
# Time: 090223 16:59:49
# User@Host: root[root] @ localhost []
# Query_time: 14 Lock_time: 0 Rows_sent: 8 Rows_examined: 145728
SELECT q.maxid AS id, m.time, m.thread, n.hits, q.countid AS `count`, m.subject, m.userid, m.name, m.catid, q.catname, t.message , 0 AS unread
FROM
(SELECT max(m.id) AS maxid, count(m.id) AS countid, c.name AS catname
FROM jos_fb_messages AS m
JOIN jos_fb_categories as c ON m.catid = c.id
WHERE c.published = 1 AND m.hold = 0 AND m.moved = 0 AND c.pub_access in (0,1,-1,18)
GROUP BY m.thread ORDER BY maxid DESC LIMIT AS q
JOIN jos_fb_messages AS m ON q.maxid = m.id
JOIN jos_fb_messages AS n ON m.thread = n.id
JOIN jos_fb_messages_text AS t ON q.maxid = t.mesid;
# Time: 090223 16:59:51
# User@Host: root[root] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 0 Rows_examined: 95452
SELECT a.id, a.introtext, a.sectionid, a.title, s.title as stitle, cc.title as ctitle,
CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END as catslug
FROM jos_content AS a
INNER JOIN jos_categories AS cc ON cc.id = a.catid
INNER JOIN jos_sections AS s ON s.id = a.sectionid
WHERE ( a.state = 1 AND a.sectionid > 0 )
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2009-02-23 15:59:48' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2009-02-23 15:59:48' )
AND a.id IN ( select itemlink from jos_fpss_slides where itemlink!=0 )
AND a.access <= 1 AND cc.access <= 1 AND s.access <= 1
AND s.published = 1
AND cc.published = 1
ORDER BY a.created DESC;
# Time: 090223 17:00:15
# User@Host: root[root] @ localhost []
# Query_time: 37 Lock_time: 0 Rows_sent: 8 Rows_examined: 145728
SELECT q.maxid AS id, m.time, m.thread, n.hits, q.countid AS `count`, m.subject, m.userid, m.name, m.catid, q.catname, t.message , 0 AS unread
FROM
(SELECT max(m.id) AS maxid, count(m.id) AS countid, c.name AS catname
FROM jos_fb_messages AS m
JOIN jos_fb_categories as c ON m.catid = c.id
WHERE c.published = 1 AND m.hold = 0 AND m.moved = 0 AND c.pub_access in (0,1,-1,18)
GROUP BY m.thread ORDER BY maxid DESC LIMIT AS q
JOIN jos_fb_messages AS m ON q.maxid = m.id
JOIN jos_fb_messages AS n ON m.thread = n.id
JOIN jos_fb_messages_text AS t ON q.maxid = t.mesid;

the mysql server is writing to this file every 2-3 seconds

Install your Joomla and Kunena local with Xampp and after this, make a backup with Joomlapack. Then bring the complete local installation with Joomlapack to your webspace.

Joomlapack has no problem with php timeout.

I dont think i understand what this will do?
Will this fix my database problem?

thanx

Проба да направиш оптимизација и поправка на базата? во краен случај направи дамп, креирај нова база импортирај се во неа и види како ќе се однесува. Пази само на енкодингот ако користиш кирилица за постовите.

поздрав

simonovski wrote:

I dont think i understand what this will do?
Will this fix my database problem?

thanx

I am sorry about that, may be i have misunderstood your problem . If you have a slow database, how should a program could fix that?

Kunena needs:

PHP >= 4.3 recommended 5.x
MySQL >= 5.0 recommended 5.x

Only to change the provider would help, i guess, isn't it?

But if you have a php timeout problem, look at technical requirements for PHP Settings:

php max_execution_time >= 120
php memory_limit >= 64M
safe_mode = off


and the provider will not make those settings, you could use Joomlapack, as i wrote.

Sorry, if your problem is another, my english is not perfect.