Extreme site slowdown

[s@squ@tch]

Is(are) the root cause(s) known?

If so, is there a known solution pathway?

I'm seeing a lot of games slowly drying up due to the amount of time it takes to post a reply or view a thread.

 

[Knightfall]

Besides being unreasonably slow, today, I'm getting these errors on a frequent basis:

"Warning: mysql_pconnect() [function.mysql-pconnect]: Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (11) in /shop/Connections/shopdb.php on line 13"

Also, I am seeing just simply "There has been a database error" type screens fairly regularly.

thirded

 

[Rystil Arden]

thirded

Me too. It seems it might be linked to the shop based on some of the text in there. I'm ready to blame a certain special someone

 

[Michael Morris]

Chris' code apparently wants persistent connections to be available. At the time he wrote it the boards had about 1500 users online at a time so this wasn't a problem. Now that the boards hold 3000+ users at a go the server can't hold up. I disabled the option for persistent connections to improve performance, though the occasional error poking through is the unfortunate result.

In short this isn't his fault.

The responsible code is eliminated in EN2.

 

[blargney the second]

Did you get any XP or loot for it?

 

[Knightfall]

Just letting you know the board seems to be firing on all cylinders right now. Really fast.

 

[Michael Morris]

CM has been striped of a lot of query generating fluff, but I think the BIG culprit was the count of online users in the navbar - when I turned that off things when gonzo speedwise.

 

[Nyaricus]

I'm still experiencing EXTREME slowdowns during the daytime. I usually browse exclusively after midnight, however, so this isn't the biggest issue for me - but I do want to check in around noon, it's damn near impossible!

 

[Thaumaturge]

I'm getting frequent "Network Timeout" errors. I don't know if this is just me, or if it is message board-wide. I'm posting this partly to inform Morris, and partly to determine if I have a gremlin in my home network.

Thaumaturge.

 

[Plane Sailing]

FWIW since the CM stuff was turned off I'm seeing equally responsive at all times of day.

Cheers