[Jaffery]

I have small PLigg site, every now and then it faces server load issue, earlier on 9.9.0, tried every possible method to reduce server load and host was co-operative enough to give it another chance but finally got kicked out of server. The site can't afford dedicated server and shared host do not allow it as it makes server cry.

I updated to Pligg 1.0 in hope that it will be faster and it seems nothing is changed, its like 50% of load of server is only due to my pligg site which has less than 1K impresssion daily.

To my surprise, it made server almost die when I try to fetch full RSS ie. site.com/rss/all

Server load went 200% from 4-5% and I know only because of full RSS, then I checked category specific Feeds and still was not very good idea, as again.. it made server load to go high .. this went to 15% from 4% .

Server is Quad Core .. 2.5GHz each - 4GB RAM, hence was able to return normal after 200% load else would have been server lockup if was some single core processor in live environment.

Now I wonder, Pligg 1.0 is still server intensive ?

[Yankidank]

We spent a great deal of time making Pligg 1.0.0 much less. I haven't had any bad experience running Pligg on 2 test "shared hosting" servers on DreamHost and Gigapros. Many shared hosts are even offering Pligg CMS as a one click install now, so I assume that those hosts have both tested and approved Pligg. I suggest that you either switch to another shared host if you are concerned about the amount of server, or even upgrade a VPS host.

Care to share the name of your web host?

[Jaffery]

Well, I do see that on normal surfing its better than before but when I was pulling RSS feed... and only with full RSS feed.

Anyways, almost every host also provide one click install of wordpress, it is highly evolved and mature product but you know what, when it starts getting little traffic, most of the host get pissed and send you mail to either go VPS or dedicated. Then Plugins like SUPERCache saves the user.

What I meant to say that giving one click install is easy as how many sites in real get good traffic ? So out of thousands install only few gets traffic and hence causes server load problem and only those gets the mail from host.. So giving one click install option is not really means = that product is very server efficient.

I am not saying pligg is bad but there are still areas where PLIGG need to work regarding server loads.. anyways.. instead of denying facts all at once by finding fault in host or server, I think should give proper look on it.

Meanwhile I was trying to find one bigg database PLIGG 1.0 site and only found few with very small size, there full RSS was not issue.

Also doing test on shared hosting with almost blank database is not really a TEST for such issues. May test with a site having 40000+ link in database can reveal real story !

[desinformado]

Help with the massive server usage by the search.php file, can I get some help? Please

[Yankidank]

Are you still running Beta 9.9.5 as your profile says, or have you upgraded to the latest version? We have made a number of significant improvements since the beta series and even since releasing 1.0.0 which was a year ago when this thread was started.

[feezesc]

I'm having the same problem with massive server usage by search.php file that causes my server to overload. I am using pligg 1.0.3. Am I under some sort of attack or something else?

Please help..

[cybertooth]

my version is 1.04 and its killing my server .... is there anyway to lessen the cpu usage?

[Dionysus]

I am having the same issues..


Hi,

We have found that your account is causing a server load again due to
lots of mysql processes.

===================================

# User@Host: korean_dionysus[korean_dionysus] @ localhost []
# Query_time: 29 Lock_time: 0 Rows_sent: 10 Rows_examined: 558947
SELECT link_id, link_category, link_title, link_title_url,
COUNT(tag_link_id) AS relevance, tag_link_id
FROM pligg_tags, pligg_links
WHERE tag_words IN
('news','moon','geun','young','because','taec','ye on','idol','','distant','feeling','him','nice','pe rson')
AND tag_link_id=link_id AND (link_status='published' OR
link_status='queued') AND link_id!=118787
GROUP BY tag_link_id
ORDER BY relevance DESC
LIMIT 10;
# User@Host: korean_dionysus[korean_dionysus] @ localhost []
# Query_time: 22 Lock_time: 0 Rows_sent: 10 Rows_examined: 552161
SELECT link_id, link_category, link_title, link_title_url,
COUNT(tag_link_id) AS relevance, tag_link_id
FROM pligg_tags, pligg_links
WHERE tag_words IN
('kim','hyun','joong','swine','flu','','ss','membe rs','tested') AND
tag_link_id=link_id AND (link_status='published' OR
link_status='queued') AND link_id!=78735
GROUP BY tag_link_id
ORDER BY relevance DESC
LIMIT 10;
# User@Host: korean_dionysus[korean_dionysus] @ localhost []
# Query_time: 23 Lock_time: 0 Rows_sent: 10 Rows_examined: 550850
SELECT link_id, link_category, link_title, link_title_url,
COUNT(tag_link_id) AS relevance, tag_link_id
FROM pligg_tags, pligg_links
WHERE tag_words IN
('photos','celebrities','arrive','late','actor','p ark','yonghas','wake','service','')
AND tag_link_id=link_id AND (link_status='published' OR
link_status='queued') AND link_id!=142455
GROUP BY tag_link_id
ORDER BY relevance DESC
LIMIT 10;
# Time: 100630 22:31:31
# User@Host: korean_dionysus[korean_dionysus] @ localhost []
# Query_time: 20 Lock_time: 0 Rows_sent: 10 Rows_examined: 550798
SELECT link_id, link_category, link_title, link_title_url,
COUNT(tag_link_id) AS relevance, tag_link_id
FROM pligg_tags, pligg_links
WHERE tag_words IN
('kim','taehee','','rest','iris','casts','airport' ) AND
tag_link_id=link_id AND (link_status='published' OR
link_status='queued') AND link_id!=135819
GROUP BY tag_link_id
ORDER BY relevance DESC
LIMIT 10;

===================================

| 1584480 | korean_dionysus | localhost | korean_pligg | Query
| 4 | Copying to tmp table | SELECT link_id, link_category,
link_title, link_title_url, COUNT(tag_link_id) AS relevance, tag_link
|
| 1584481 | korean_dionysus | localhost | korean_pligg | Query
| 4 | Copying to tmp table | SELECT link_id, link_category,
link_title, link_title_url, COUNT(tag_link_id) AS relevance, tag_link
|
| 1584484 | korean_dionysus | localhost | korean_pligg | Query
| 1 | Copying to tmp table | SELECT link_id FROM pligg_links
LEFT JOIN pligg_groups ON pligg_links.link_group_id = pligg_groups. |
| 1584485 | korean_dionysus | localhost | korean_pligg | Query
| 2 | Copying to tmp table | SELECT link_id, link_category,
link_title, link_title_url, COUNT(tag_link_id) AS relevance, tag_link
|

===================================

We have disabled the webaccess at the moment to prevent further
issues.

[chuckroast]

Originally Posted by Dionysus

I am having the same issues..


Hi,

We have found that your account is causing a server load again due to
lots of mysql processes.

We have disabled the webaccess at the moment to prevent further
issues.

No information provided but what the host told you? Thanks..
For all we know you have 50,00 users on a godaddy account.
Most likely you are attempting to be a massive social network on a shared hosting account.

You can't possible think that you can be the next twitter, facebook, or digg, on basic shared hosting account.
This isn't 1995.