IPS 4 Extremely Slow

[Kurt De Pauw]

After the update to the last version I have several problems

The forum is extremely SLOW, and I say SLOOOOOWWWWW

So slow that 9 of 10 times is get an error

504 Gateway Time-out

---

nginx

 

I have a VPS (not some shared hosting ) with 8 GB memory so .... that is not a problem

 

Also sometimes the forum just stops working completely and throws me the error message

 

An error occurred (500 Error)

We're sorry, but a temporary technical error has occurred which means we cannot display this site right now. 

You can try again by clicking the button below, or try again later. 

Try again

 

When I then go to the /admin URL I got below URL

Quote

admin/?adsess=samt8kv8v8cdd5bihji5ksqju1&app=core&module=system&controller=login&error=Too+many+connections&ref=

 

then after some time it just works again ....

 

I must say ... IPS has done a great job on the new look of the board and although I can't find anything anymore in the adminCP , I really like it.

But the performance is just not that .... I can't imagine that I need to upgrade my VPS just by changing version.

 

 

Regards,

Kurt 

 

[Ahmad E.]

You'd have to hunt down what is causing this in the first place. Might be a configuration error as-well. My site(s) are hosted on a 2GB VPS (4x3.3GHz/2x3.1GHz 2VPS' for different sites) and are pretty fast.

Ram usage is ~900MB.

[Kurt De Pauw]

LOL ( well actually it is not fun anymore )

 

Just when I post this message I have it again

 

An error occurred (500 Error)

We're sorry, but a temporary technical error has occurred which means we cannot display this site right now. 

You can try again by clicking the button below, or try again later. 

Try again

[Ahmad E.]

Check server logs (nginx).

[Kurt De Pauw]

Is there somewhere in the new adminCP the option to do some checks .... like we'd have before in 3.X

So I can see the errors there .... although not possible to access it due to the error

[Ahmad E.]

Other than running the support tool, no. But it does all the checks as-well (AFAIK).

[Kurt De Pauw]

Okay ... just tried to open the PLESK to connect to the Server and I get below error

ERROR: Zend_Db_Adapter_Exception: SQLSTATE[08004] [1040] Too many connections (Abstract.php:144)

and this one 

ERROR: PleskDBException: Unable to connect to database: mysql_connect(): Too many connections (Error code: 1040) (Abstract.php:69)

It will be indeed something to do with the connections to the SQL , but on the other hand it looks like that the upgrade changed something how it handels these connections

or my forum just magically increased by users :-)

 

[Ahmad E.]

Might be a DoS attack maybe? Seen it before.

Again, would have to check logs to see what is causing this

[Kurt De Pauw]

changed the SQL connection to 500 :-) for now  --> there was a max of 251 connections.

set global max_connections = 500;

[Ahmad E.]

2 minutes ago, Kurt De Pauw said:

changed the SQL connection to 500 :-) for now

set global max_connections = 500;

Not the best long-term solution but I guess it's fine for a temporary workaround.

[Kurt De Pauw]

High MySQL usage

[Ahmad E.]

Yup, but you need to figure out what caused this. It's very unlikely that visitors increased so fast.

[bassangler]

What version of MySQL are you using?  PHP version?

[tnn]

@Kurt De Pauw Did you optimize the database? With phpmyadmin what I do is optimize, then run a repair, then optimize again.

I don't think that will cure it but it's something to look at for starters

 

[Marcher Technologies]

I actually had something similar happen working on something for a client, try turning *off* prefetching in your browser. Specifically, if you are using FireFox, it makes a literal ton of connections during normal browsing by default: https://support.mozilla.org/en-US/kb/how-stop-firefox-making-automatic-connections

I mention this as I haven't seen another browser be this aggressive in prefetching by default, and it is so aggressive it will trigger a block from any sane CSF config.

[tnn]

And here's a tibit of information regarding the "ERROR: PleskDBException" http://talk.plesk.com/threads/error-pleskdbexception-unable.335861/

[Kurt De Pauw]

i can now see for the last 24h that all is normal .... well the usage of the sql process is higher then version 3.4 but it is normal