WHMCS slows to a crawl or stops working if the server is up over a day

[SeanShepardWI]

I'm having to reboot the server every day. Everything else on my website runs fine, but anything that seems to access a database from whmcs (like logging in or doing something in admin) is slower than molasses or times out. Rebooting the server fixes this.

 

Any clue what's going on? I'd rather not have to setup a cron job to reboot the server every night.

[XN-Matt]

How big is your WHMCS database?

[SeanShepardWI]

We aren't live yet, 3 users.

 

edit: and it's actually been happening since the first day

[XN-Matt]

Well, I could safely say it's not WHMCS. Our WHMCS database is over 600mb and has no speed issues at all.

 

What server are you running on? Web server? PHP version and how is it running? FCGI? suPHP? dso?

[SeanShepardWI]

You can safely say it's not WHMCS but it only happens on WHMCS. So whatever is affecting it is only affecting WHMCS, so it has something to do with WHMCS

 

mysql (5.0.67-community)

httpd (2.2.11 (Unix))

Server Load 0.00 (8 cpus)

Memory Used 1.3 %

Swap Used 0.00 %

 

PHP 4.2.3

Perl 5.8.0

 

I don't really know how to find the rest. I don't think database size is the only thing that can cause this problem. It would seem to me like a database problem though, like something being configured improperly.

[bluetreehost]

That seems strange to me, that WHMCS would be the only thing having problems. It is a piece of software accessing a database just like any other application on your server.

 

Have you checked your /etc/resolv.conf file to make sure your DNS servers are working? I've seen slowness like this that could be followed back to a DNS timeout.

[SeanShepardWI]

its just got my 2 ips listed that i use for nameservers

 

i seem to have goofy problems like this because im on a VPS that i've never had on a dedicated server, i need to switch as soon as i get some revenue

[Lawrence]

That seems strange to me, that WHMCS would be the only thing having problems. It is a piece of software accessing a database just like any other application on your server.

 

Have you checked your /etc/resolv.conf file to make sure your DNS servers are working? I've seen slowness like this that could be followed back to a DNS timeout.

 

He should also update his PHP version, as 4.2.3 is quite old and has a number of bugs in it that could allow hackers to exploit his server(s).

[simplybe]

what does top show in ssh when you are using whmcs ? could also be an issue with an outdated version of php running along with mysql 5. Update to php5

[redrat]

You say you have a VPS so how much RAM have you got available to you? I reckon this is your issue. WHMCS will run like an old dog on less than 256MB downhill at the best of times. If you have 512+MB then there are other problems. Otherwise just get more RAM.