Queries:
pitajfm_cms
1. SELECT * FROM odgovori WHERE uid = 7954 AND pid = 86013
table odgovori, make sure index for uid and pid exists, if not add it in phpmyadmin
2. SELECT id FROM brojac_posjeta WHERE ko = '185.36.84.113' AND kome = '8074'
table brojac_posjeta, make sure index for ko and kome
3. SELECT id FROM brojac_posjeta WHERE kome = '9464'
table brojac_posjeta, same as above, need kome index
4. SELECT * FROM notifikacije WHERE kome = 8443 AND vrsta = 'odgovor' ORDER BY datum DESC LIMIT 5
notifikacije, add index kome
5. SELECT * FROM pitanja WHERE uid = 8443 AND status = '1' ORDER BY id DESC LIMIT 0,25\G
table pitanja, index on uid
6. SELECT `id` FROM `lajkovi` WHERE `oid` = 63566 AND `ko` = 8443\G
table lajkovi, index on oid and ko
Based on top results
top - 18:06:18 up 2 days, 21:54, 1 user, load average: 0.85, 0.84, 0.97
Tasks: 86 total, 2 running, 84 sleeping, 0 stopped, 0 zombie
Cpu(s): 15.7%us, 0.7%sy, 0.0%ni, 83.6%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Your server is mostly idle