WHMCS slowner on server

[prasadnaik15]

I have been experiencing WHMCS application going slower and sometimes faster

 

Load on server is less then 1 on 8GB server

 

The I/o value less then 5 and yet WHMCS appears slower while checkout

 

Any suggestions ?

[hostgate]

Try to optimize your DB, "#mysql -Aor", and after that try to see your MySQL config file (my.conf), see if it's OK and optimize it.

[saasideas]

Any stats for tracking the number of visitors you have? Or even how many logged in using sessions? Maybe if your popular enough you need to invest in alternatives like separating database, multiple servers running instances and using memcache, CDN (look at cloudflare, they have free and paid services), better cloud based hosting (VPS/dedicated) to help you scale on demand if necessary during peak times.

 

Optimize MySQL (query cachine, size of cache, etc.)

Try an opcode cache for PHP as smarty already caches their template stuff (APC?)

Using fastcgi for PHP?

 

You mention you got a lot of RAM which is good, what about CPU, disk speed, etc?

 

Sometimes VPS (if you're on one) still share CPU which isn't good, and if that machine has a lot of traffic and tied up CPU that could be the reason it's intermittent? Even dedicated is the best but you run into limitations eventually that require good configuration, additional services (so you don't need more and more hardware), etc.

 

Just tossing out suggestions. PM me if you need help or want to do some "investigation" to root out the cause.