My MySQL database kills host's cpu

[realest]

nah it screwed the site :\ now the voting doesnt work bcz of some wrong key and access to user.php gives error.

I have a backup so....
Is there something i can do to prevent the pageviews table to grow bigger on 9.0 with digitalnature template??

[realest]

i did something by my self but im not sure if its okay...
i commented in libs/pageview.php the:

function last_viewers($viewercount = 1){
global $db, $current_user;
$sql = "SELECT DISTINCT pv_user_id FROM " . table_pageviews . "
WHERE pv_type='$this->type' AND pv_page_id=$this->page_id AND pv_user_id > 0
ORDER BY pv_datetime DESC LIMIT " . $viewercount;
$last_viewers = $db->get_col($sql);
return $last_viewers;
}

and than error came up in user.php line 62 so i commented that to
and now at least user profiles is working without last 5 user.
can that be good anyone?

[nothingman]

Hi Ashdigg, another quick question on the pageviews table. I'm migrating to a new host, and I've noticed that my sql backup file has about a 101904 lines of insert queries in the pageviews table. As I've removed the function altogether, can I do away with these queries?
Many thanks

[wwwOLIONDORcom]

I also have server issues and I guess it's because of Pligg, has this been fixed in latest version ?

Thanks.

[tariqali]

I just truncated the whole table. It was killing my server all day today.

[fhelik]

this problem is fixed in 9.9?

[r3ddr]

I would guess this is fixed alread in 9.8, therefore also in 9.9

anyone guess confirm this? :D

[fingerprn]

Having the "Show the last 5 people to view a profile" is a nice feature, but I don't understand why all pageviews have to be dumped into one table. If profile views were a separate table, you could still have the feature with a much lower CPU load.

[maiti]

Originally Posted by nothingman

realest, I have done the following and well, i think it has worked.
Go to the the sourceforge repository that ashdigg talked about. Once there, do the following:

Step1: Download the sourceforge files and replace your current templates/yget/user_center.tpl, and <siteroot>/user.php files.
Step2: Also replace the /install/upgrade.php, under your install folder (i.e. assuming it is stil there.
Step3: Execute /install/upgrade.php

That worked for me and it'd help if the pligg masters confirmed it :)

When i`ve done this i got critical error in upgrade.php line 95

[maiti]

Hello i think i fix it :smile: my pligg_pageviews table is not getting bigger anymore

If i fix it.... here is the way how i did it

(it worked for me on Pligg 9.8)

first copy your user.php and story.php files somewhere.

root/user.php delete

1. line 64

root/libs/story.php delete

lines from 60 to 74

:pfew: i hope i helped