Slowing Down of Site

[RJM]

We are working to fix the recent slowing down of the site caused by an overload of database connections.

@Cino is attending to it from his hospital bed!

He says that the Westhost server does not supply the number of server connections recommended by XenForo

Please be patient just for now, guys

 

[Cino]

That sounds so dramatic!

I'm actually grateful to get to do something interesting for a change. Hospital life can get a bit monotonous...

I hope our hosting service will follow through with our requests, which will hopefully resolve the occasional database error messages.

 

[Tony Bristow-Stagg]

That sounds so dramatic!

I'm actually grateful to get to do something interesting for a change. Hospital life can get a bit monotonous...

I hope our hosting service will follow through with our requests, which will hopefully resolve the occasional database error messages.

All the best Cino.

Regards Tony

 

[RJM]

It may take a few days while Westhost responds and hopefully targets the action requested -- meantime apologies for the slow service, but we at least know the site will not go down altogether, which was the first concern ...

 

[juantoo3]

Thanks for all you do! Especially Cino!

And get well soon, Cino!

 

[JustGeorge]

Good luck with it!

 

[RJM]

We seem to be back up to speed now? Hope it lasts

 

[Niblo]

That sounds so dramatic!

I'm actually grateful to get to do something interesting for a change. Hospital life can get a bit monotonous...

I hope our hosting service will follow through with our requests, which will hopefully resolve the occasional database error messages.

Some sites will go to any extreme to hinder my wondrous postings .

Get well soon, Brother.

Blessings.

 

[Cino]

So how's the site holding up? I've been a bit out of touch yesterday.

 

[RJM]

So how's the site holding up? I've been a bit out of touch yesterday.

It seems to be fine now

 

[Cino]

It seems to be fine now

Great, this is good news.

 

[Craz]

@Cino
Up until today it took 4 or 5 goes to even login. Now seems normal.
Cheers and hope you are feeling better.

 

[muhammad_isa]

Great, this is good news.

Indeed .. it's a lot better..
Is it that the website traffic has increased, causing the database backend to struggle?
..or something else?

I understand that max. connections has been increased ..
"max_user_connections = 30" [ in /etc/my.cnf ] should be plenty.

Hope all is well with you, and you will be home soon.

 

[JustGeorge]

Its back to super slow for me.

 

[RJM]

Its back to super slow for me.

Really? Still ok here

Westhost will not increase the connections limit from 10 to 25.

So what next?

 

[RJM]

I'll run another database repair ...

 

[RJM]

Nothing to see there, unfortunately it doesn't seem to be the problem:

 

[RJM]

But my speed here in the UK is still back to normal. Are others experiencing another slow down?

 

[muhammad_isa]

Nothing to see there, unfortunately it doesn't seem to be the problem:

View attachment 3764

"For larger XenForo installations, it can be advantageous to define a cache in order to save on processing time and database queries.
XenForo has the ability to store and retrieve various data from a cache, which can be configured in your src/config.php file"

It might help .. but it could be due to processes getting "stuck", and not closing sockets to db.

 

[wil]

Still on the road....off the playa, but if $€ are needed holler.