Hi, I have VPS and im having problems with it, its overloading to 100% each day and causing it to shutdown on SolusVM (which i have to boot it each time), because its unmanaged i have to fix the problem myself.. They said i ether have to optimize mysql or my scripts etc.. Does anyone have any solutions on this ??
You need to figure out where the bottleneck is. Are you running a heavy mysql site(s)? Odds are you need to optimize your web server and your mysql server for your hardware specs. Chris
Monitor the output of 'top' through your ssh terminal, and see what the big hitter is. That will give you a place to start. You can also take a look at your log files to see if there is anything out of the ordinary.
There are PHP functions which will allow to test how many resources every script uses. Using these stats you can find the problem and optimize your script.
First figure out your requirement with current server status. If you are using mysql in ur page try to reuse it and minimize the no.of query (still you have the problem then go for memcache) according to page make the process as simple you can. Look at this doc http://developer.yahoo.com/performance/rules.html If possible increase RAM
anything that is disk IO heavy will cause this with virtualization.... if their hardware / drives are slow as well , that is the most likely bottleneck
What exactly was their response? They can give you much more information than anyone on here. Did you have this problem on a previous VPS provider or are they your first?
Torrents site with mysql only for tags? hmm, what kind of source are you using? Start with mysql and your webserver, I bet that will help alot, then u can optimize scripts. If have some problems, I can help, have experience specially in torrent sites.
Mysql performance is greatly affected by RAM, processor cores. If you have larger database, i recommend you to upgrade the RAM. have you optimized my.cnf file?
ofcourse, all want's to earn money by offering some other services, optimize sql server. And i dont think that even my.cnf is edited.
The best idea I think. If you stay with current dedicated server solution I think you will waste a lot of your time.
Maybe one of your scripts are using many RAM and CPU resources. Review your script(s) and optimize them as your serer have good RAM and CPU.