@DareDevil RE: vsp stats

[Knobby]

Hi buddy hope you are well???

 

ok I have vsp working, was wondering how often to schedule the cron job to update please??

 

Many Thanks

 

 

Knobby

[Matty_c]

You should send him a PM. That way he won't miss your post. Although I am sure he will find this.

[daredevil]

Hi buddy hope you are well???

ok I have vsp working, was wondering how often to schedule the cron job to update please??

Many Thanks

Knobby

 

1. Depending on your host I would suggest to run cron job. Some website host doesn't allow MySQL DB size of more then 100MB.

 

2. If you are hosting your own forums, then I would suggest to keep MySQL size around 500Mb or less then 1GB. Because above it, you will need good MySQL optimization tweaks depending on how many users are using VSP.

 

3. You should also consider to patch it if you haven't. There was one security exploit released for VSP stats.

 

4. If too much table locking happens, drop the indexes if needed and convert the table to InnoDB.

 

Overall it depends. I would say run cron job once every 24 hours. Looking at the slots of your server, you can even run it every 6 hours if website and server is on same machine.

 

You should send him a PM. That way he won't miss your post. Although I am sure he will find this.

 

I don't offer help in PM unless some secret (pass or user id) info is required because if someone is looking for same issue, then I just need to point him to same topic.

 

Used to be 100+ unread PM's before holidays. Got down to 70.

[Matty_c]

 

 

I don't offer help in PM unless some secret (pass or user id) info is required because if someone is looking for same issue, then I just need to point him to same topic.

 

Used to be 100+ unread PM's before holidays. Got down to 70.

 

Oops! Sorry it sounded like you had talked with him before. You can blame the +5 PM's you get after this on me

[Knobby]

1. Depending on your host I would suggest to run cron job. Some website host doesn't allow MySQL DB size of more then 100MB.

 

2. If you are hosting your own forums, then I would suggest to keep MySQL size around 500Mb or less then 1GB. Because above it, you will need good MySQL optimization tweaks depending on how many users are using VSP.

 

3. You should also consider to patch it if you haven't. There was one security exploit released for VSP stats.

 

4. If too much table locking happens, drop the indexes if needed and convert the table to InnoDB.

 

Overall it depends. I would say run cron job once every 24 hours. Looking at the slots of your server, you can even run it every 6 hours if website and server is on same machine.

 

 

 

I don't offer help in PM unless some secret (pass or user id) info is required because if someone is looking for same issue, then I just need to point him to same topic.

 

Used to be 100+ unread PM's before holidays. Got down to 70.

 

Ok cool thanks for that.

 

VSP since last post stopped working giving the following error:

 

PHP Warning: mysql_connect(): User rargamin_knobby already has more than 'max_user_connections' active connections in /home2/rargamin/public_html/vsp/pub/lib/adodb/drivers/adodb-mysql.inc.php on line 339

 

I'm aware and understand the error but not aware of how to apply a correction to it! AGain any help would be very much appreciated thank you

 

btw web server and game server are different :/

 

Knobby

Edited December 13, 2010 by Knobby