MySql CPU Overload

[tugacari]

Dears,

I bought vshare a couple of months ago and I'm very happy with it, I already have 500 videos and 800 users

Although, since a couple of days ago, I'm having an issue with mysql consuming most part of cpu resources. Is this a known bug ?

I deactivated all other scripts that use mysql, but the issue continues and site is running slow.
I'm ussing vshare on a dedicated server with 2gb or ram, intel 2.4 and 100 Mb upload, so I guess that I'm not running low on resources.

I would like to get some advice on the best mysql configuration, and, if possible, to have a vshare employee looking at in on the server, of course that I'm willing to pay for it.

Please let me know if someone from vshare can do it.

Regards

Tugacari

[hostonnet]

When site get more traffic, MySQL usage increase it is normal for dynamic web sites.

You can login and check MySQL query with

show processlist

command on MySQL prompt to see sql commands mysql server runs.

Once mysql is loaded, if you disable other scripts, it take some time to become normal, better stop mysql, wait for load become normal, then start it. Now run only vshare site, so you will be able to track MySQL usage.

[RAMMSTEIN]

you have t delete all data that you have at guest_info table.
To achieve that you have to enter from your server. then you have to make an optimization to you database,

I have also a site that has the same problems. I think next version will deactivate those issues,

[RAMMSTEIN]

edit "\include\smarty\libs\Smarty.class.php"

[touchsaver]

what line need to be modified?


edit "\include\smarty\libs\Smarty.class.php" :