Re: Error with kinetic an 1.7 rc3
Posted: Fri Mar 22, 2013 5:02 pm
Static page issue: http://board.s9y.org/viewtopic.php?f=3&t=19219
Timbalu wrote:Also you should investigate the slowness of your server responses. What could cause these hangouts..?
Which still has to get solved, otherwise your blog will keep slowing down until it breaks.Jochen Hoff wrote:The slowness of the server comes from time to time. Duckhome takex most of the power, but i not able to clear the problem. Is the same with the traffic. Its terrible. But i have no money to pay an administrator so it is a problem.
Code: Select all
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid
LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_en')
WHERE isdraft = 'false' AND timestamp <= 1364059587
ORDER BY timestamp DESC
LIMIT 5
/ Incorrect key file for table '/tmp/#sql_e1b_0.MYI'; try to repair it
SELECT DISTINCT id, title, timestamp, epm.value AS multilingual_title FROM tb_entries AS e LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid LEFT OUTER JOIN tb_entryproperties AS epm ON (epm.entryid = e.id AND epm.property = 'multilingual_title_en') WHERE isdraft = 'false' AND timestamp <= 1364059587 ORDER BY timestamp DESC LIMIT 5Incorrect key file for table '/tmp/#sql_e1b_0.MYI'; try to repair it
and read
http://stackoverflow.com/questions/2090 ... iple-joins
It seems your servers or domains /tmp folder is running out of space, from time to time. There are different solutions for this... (give it more discspace, give it more ram, run REPAIR TABLE, run ANALYSE TABLE )