Imam sledeci problem, na sajtu mi povremeno “iskace” sledeca greska:
1030
Got error -1 from storage engine SQL=SELECT a.*,
cr.rating_sum/cr.rating_count as rating, c.name as category_title,
c.id as categoryid, c.alias as categoryalias, c.params as
categoryparams, cc.commentcount as commentcount FROM xyo74_k2_items as a
LEFT JOIN xyo74_k2_categories c ON c.id = a.catid LEFT JOIN
xyo74_k2_rating as cr ON a.id = cr.itemid LEFT JOIN (select cm.itemid
as id, count(cm.id) as commentcount from xyo74_k2_comments as cm
where cm.published=1 group by cm.itemid) as cc on a.id =
cc.id WHERE a.published = 1 AND a.access IN (1,1,5) AND a.trash = 0 AND
a.featured = 1 AND a.catid IN(
“17”,“18”,“19”,“20”,“21”,“23”,“24”,“25”,“27”,“28”,“29”,“30”,“31”,“32”,“44”
) ORDER BY created desc LIMIT 5
U Cpanelu su mi obicno ovi parametri:
Server Load 1.93 (12 cpus)
Memory Used 37.95 %
Swap Used 15.64%
Disk /dev/sda3 (/) 94%
Disk /dev/sda2 (/boot) 16%
Disk /dev/sdb1 (/backup) 95%
Disk /tmp (/var/tmp) 99 %
Disk /dev/sdc1 (/var/lib/mysql) 26 %
Kada mi “iskoci” greska na sajtu ovaj dio bude Disk /tmp (/var/tmp) 100 %,
da bih nakon par trenutaka sve izgledalo ovako:
Server Load 1.42(12 cpus)
Memory Used 38.11 %
Swap Used 15.64%
Disk /dev/sda3 (/) 94%
Disk /dev/sda2 (/boot) 16%
Disk /dev/sdb1 (/backup) 95%
Disk /tmp (/var/tmp) 100 %
Disk /home/imesajta (/home/imesajta) 94 %
Disk /dev/sdc1 (/var/lib/mysql) 26 %
Znaci, pojavljuje mi se i ovaj dio Disk /home/imesajta (/home/imesajta) 94 %
Prostor na sajtu je zauzet oko 20%. Sajt je radjen u Joomli, u K2. I ovaj dio Disk /tmp (/var/tmp) stalno varira od 93% pa navise. Interesuje me u cemu moze biti problem, po svemu ovome iznad?