problem of overload from 1yr!

I have a vivvo site stats are as follows:
You are currently running Vivvo CMS v4.0.3 build 2578.

# Database size: 270.12 MB
# Cache size: 42.85 MB
* Total of 14 categories.
* Total of 0 tags.
* Total of 50209 articles posted (34700 active, 0 pending).
* Total of 773402 article views.
* Total of 76 comments posted.
* Total of 28 registered members.

Today statistics
* Total of 67264 article views.
* Total of 1 comments posted.
* New users 0.
* Currently 18 visitors on site.

i dont know that 67K today visitor bots are also counted as for my site in real i have on vivvo site only 400-500 visitors a day right now days..

so thing is this i have 400-500 visitors and its on a LIQUID WEB 2nd VPS PLAN WHICH IS RECOMMENDED BY VIVVO TOO...

now what is the issue:
ans: 90% of time my server whm's serverload is 3 times to normal allowed..


i am really surprised why it goes with me while there is no any big peoples saying same regarding overload ???

i just having in my whm load approx. 2.7 at time of taking screenshot while normally it works in range of 10-18 my god!

i adding screenshot right now at 2.7 load work time.. as right now there is just me as a visitors as its not my timezone time for visitors.

also according to my server peoples vps goes overheating as vivvo eat cpu via its mysql queries this is what they saying all time to me...

will anybody help me how can i fix it!

Originally Posted by b4uindia

Today statistics
* Total of 67264 article views.
* Total of 1 comments posted.
* New users 0.
* Currently 18 visitors on site.

i dont know that 67K today visitor bots are also counted as for my site in real i have on vivvo site only 400-500 visitors a day right now days..

Actually, those are 67K article views, not visitors. Mark the difference.

[shketuljko]

I recommend you using cron for cleaning session table.
You can read this thread:
http://www.vivvo.net/forums/showthread.php?t=3599

I think that will be very helpful.

Originally Posted by andy77

Actually, those are 67K article views, not visitors. Mark the difference.

i can see 67k are article views but belive me i have just 200-300 visitors a day this all are bots and whatever to face the issue i have turn on cache too already...


regards!
anand

Originally Posted by shketuljko

I recommend you using cron for cleaning session table.
You can read this thread:
http://www.vivvo.net/forums/showthread.php?t=3599

I think that will be very helpful.

i did this too but not make much difference i know i read the post and i think its too good to give more breath to servers but still problem is same

right now my vps root whm login says load status as:
* Load Averages: 16.62 15.93 15.53

14282 mysql 0 62.8% cpu
5.3 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/host.b4uindia.com.pid --skip-external-locking


which is more than the abnormal i think


regards!
anand

You should find out which file causes this overload. I had a similar issue about a year ago:
http://www.vivvo.net/forums/showthread.php?t=2233

If you define which file causes the problem, you can narrow the possible sources of the overload.

Originally Posted by erdsiger

You should find out which file causes this overload. I had a similar issue about a year ago:
http://www.vivvo.net/forums/showthread.php?t=2233

If you define which file causes the problem, you can narrow the possible sources of the overload.

will anybody help me to find out which file is causing such issues..

is it crop.php?

i really appreciate any help by heart...

regards!
anand

Hi Anand,

What you can try to do is examen the process or kill the process!

Go to WHM

Steps to follow:

• Main >> System Health >> Show Current CPU Usage

• Click on the PID [14282] with the high load

• Then >> Trace Process

If you can't find whats the exact problem, do the following:

• Kill Process

Now the load have to go back to normal...

I hope this will help, this is not the best solution but it cant harm you..

Martin

Originally Posted by b4uindia

14282 mysql 0 62.8% cpu
5.3 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/host.b4uindia.com.pid --skip-external-locking


which is more than the abnormal i think


regards!
anand

I just investigated with my data center liquidweb they said me as follows:

All of the queries seem to be related to one db, here is a snapshot of the
currently running queries:

555671 | b4upscom_b4unews | localhost | b4upscom_b4unews | Query | 5 | Sending
data | SELECT count( * ) as count FROM newvArticles WHERE feed_data =
'486d4a6945c7fad5740d52cd31f9bbda' LI |




will anybody please have a look what best we can try here in this case.

regards!
anand

[boccio]

Try turning off NewsFeed importer and see what happens...