Hi people, I have a VPS server which is used for SMF and it gets me timeout sometime. So, I have decided to use persistent connection to mysql ? What do you thik, is it better then another way, or I should quit it. Also, what is the best solution for max connections for mysql. Thanks in advance.
I wouldn't use a persistent connection because it will use a lot of server resources. What specs does your vps have?
It is not great, but I think it might be enough for SMF forum which has about 50 to 60 online per 5 minutes, or it wouldnt ? Web Space 15GB Traffic (Bandwidth) 400GB Guaranteed RAM 256+ MB Max RAM 16 GB Guaranteed CPU 327.7+ Mhz Max CPU 8 x 1.86 Ghz
Yeah, cPanel need specs like that just to run by itself. Have you ever thought of using something lighter but just as good like DirectAdmin.
Yes I have Cpanel, but I almost doesnt use it, so thats thats why I do not know how it can cause problems. Cpanel is used only by me and nobody else. Does Cpanel hase some running processes even I do not log into ? If Cpanel cause this troubles, please advice me what to do ? Would it be better to get more resources and to go to more advance package ?
Yes, cpanel is now VPS optimised so it is less important to have higher specs, but as said 256mb is the minimum for a VPS. Maybe you can upgrade to next plan ?
Even if you hardly use it, all it's services and processes are still running. I would use DirectAdmin instead.
If you aren't using cPanel 24x7, stop and start it accordingly to free up resources. service cpanel stop Code (markup): service cpanel start Code (markup): Edit: Also make sure you're not running things like EntropyChat or Spamd (SpamAssasin) if you're not using them. Jay
@jayshah Thanks ... I ll do it ... Just one question, where I should type this code in ? @calum Where I need to switch which File Manager I need to use ?
Log into SSH using putty or something then type it in. Since this is a VPS you should have SSH. If you haven't used it, download putty. Open it up, type in your server hostname or ip. When it loads enter "root" and the root password for your vps. I don't really understand what you are saying. In cPanel you can use the new or legacy file manager, if you switch to directadmin that has it's own file manager.
I am using SMF and it has large number of users and posts as well, so it might be problem to use another forum script.
I have just upgraded to next level: Web Space 25GB Traffic (Bandwidth) 700GB Guaranteed RAM 512+ MB Max RAM 16 GB Guaranteed CPU 491.5+ Mhz Max CPU 8 x 1.86 Ghz Code (markup): I hope this can helps. Also, when I accesss to the server via SHH and do command: service cpanel stop Code (markup): I am no longer aviable to access to WHM too, but thats no problems. The main problem is, even if I upgrade to next level when I try to see free memory I have very bad results or: I really do not understand what to do I am having about 30 or 40 or 50 users in 15 minutes online (Even some of them are browsing all over the forum all time and writing posts it should be a problem). Any sugesstion how to make better free memory ?
Yeah, stopping cpanel stops WHM as well, since they are one and the same. That should be more than enough, is SMF caching anything, if not set it to cache. Also, if it is using GZIP compression, turn that off (I think it will be somewhere in the smf admin panel).