Question Out of Ram on VPS

I run my J1.5.14 and K1.5.4 forum on a VPS with 768mb of RAM. I have approx 30+ users online at a time and i have been having problems lately with running of out RAM. My site is mainly just the forum, and I assume that the majority of the queries are from kunena (not sure how to check that though - does anyone know a way to look at a query log?)

1. Now I am thinking that the upcoming kunena v1.6 will come to my rescue by its huge performance overhaul? Can the devs confirm this?

2. Is there anything i can do in the meantime to help so it doesnt crash all the time?

peetree21 wrote:

I run my J1.5.14 and K1.5.4 forum on a VPS with 768mb of RAM. I have approx 30+ users online at a time and i have been having problems lately with running of out RAM. My site is mainly just the forum, and I assume that the majority of the queries are from kunena (not sure how to check that though - does anyone know a way to look at a query log?)

Hello,

You can set debug mode you will see all the queries.

peetree21 wrote:

1. Now I am thinking that the upcoming kunena v1.6 will come to my rescue by its huge performance overhaul? Can the devs confirm this?

2. Is there anything i can do in the meantime to help so it doesnt crash all the time?

1. Yes, Kunena 1.6.0 is a huge rewrite to MVC and it's more fast that Kunena 1.5.x and Kunena 1.0.x.

2.Perhaps this site will help you : www.joomlaperformance.com/ , do you have think to cache datas ?

Do you have SSH access to your site?

Log in and write:

top

It shows you CPU usage, how many running processes you have (CPU > 1%) and it will tell you how much memory all the processes are using (M orders them by memory).

There are usually 3 possibilities:
1) mysqld is on the top most of the time using all/most available CPU
2) there are huge amount of httpd processes running (CPU 1-30%)
3) both 1 and 2

here is a screenshot of the top command. it fluctuates a fair bit but this seems to be the average sort of values.

the site at the moment is pretty quiet (this time of day isnt usually too busy - even though kunena says 28 users in the forum)

can you tell me what this means? and if there is anything i can do in the meantime? thankyou!!

Looks ok, but I suppose that you don't have enough load to saturate the server. It also shows that your server has used more resources than available for not so long time ago.

Look at the first line, there is "Load average" and three numbers: now, short history, long history. They should stay below 2 for most of the time, even on peak hours.

Cpu(s): 13.9%us, 39.8%sy, 0.0%ni, 1.0%id, 44.6%wa, 0.5%hi, 0.2%si, 0.0%st
Tells how much time is spent on:
They may reveal what is going on (if the problem is in I/O or lack of CPU time)

%CPU and %MEM for each process are also useful to look at..

Now you should wait for peak hour and look what happens. I suspect that something is taking all CPU or I/O time and causes number of Apache processes to grow so much that the server will run out of memory. But the question is what it is.

ok thanks!!! i will wait til it gets super busy and take another screenshot.

do you think K1.6 will alleviate these issues? or do i need to do something to my setup/server?