Upcoming downtime

[Akka]

Connection Problems
Sorry, SMF was unable to connect to the database. This may be caused by the server being busy. Please try again later.

 

Only for a few seconds though.

[1714776707]

1714776707

[theymos]

Yeah, I restarted the database so I can maybe see what's happening.

It looks like there's more than enough free memory. free reports 1250 MB free memory minus buffers, and smem gives similar stats. But for some reason Linux uses swap a lot (causing slowness) and occasionally the OOM killer kills php-fpm processes (causing 502 errors), so I guess there isn't actually enough memory. Anyone know what might be causing this?

[paraipan]

Yeah, I restarted the database so I can maybe see what's happening.

It looks like there's more than enough free memory. free reports 1250 MB free memory minus buffers, and smem gives similar stats. But for some reason Linux uses swap a lot (causing slowness) and occasionally the OOM killer kills php-fpm processes (causing 502 errors), so I guess there isn't actually enough memory. Anyone know what might be causing this?

Try mysqltuner theymos, you may have improper size buffers set. After that just install memcached, method is different depending on the OS, and enable the option in the SMF admin area. Mysql will be more than grateful after that 

[theymos]

I'm already using that.

I may have improved the situation by decreasing the maximum amount of memory that php-fpm and mysql can use.

[dree12]

I'm already using that.

I may have improved the situation by decreasing the maximum amount of memory that php-fpm and mysql can use.

Why not just install more memory with the forum's funds?

[cedivad]

A properly configured 100€/month ovh server would fit whatever load this website has... Please admin, give us something we can build a currency on.

[paraipan]

I'm already using that.

I may have improved the situation by decreasing the maximum amount of memory that php-fpm and mysql can use.

Got it

[greyhawk]

502s again from 21:01 to 21:02 CET

[Akka]

502s again from 21:01 to 21:02 CET

Me too.

[Phinnaeus Gage]

Another 502 about 30 seconds ago.

[Maged]

502

[theymos]

Strangely enough I have only ever gotten one 502 in the last few days. What browsers are you all using?

I'm going to find some way of upgrading the hardware. There's probably some way to get more performance out of this hardware, but I don't know how.

[21after2]

I experienced a lot of 502 errors about 2-3 days ago, but since then I've had a perfectly fine connection. Maybe even quicker than usual, though it may just seem that way since it was loading pretty damn slow during those couple days.

[theymos]

The error log has too many trivial errors. I wasn't able to immediately find the 502s. I may look into it more later.

[repentance]

Strangely enough I have only ever gotten one 502 in the last few days. What browsers are you all using?

I'm going to find some way of upgrading the hardware. There's probably some way to get more performance out of this hardware, but I don't know how.

Chrome Version 24.0.1312.57 m with Win 7.

I have the most problem with errors between about 1900 and 2200 UTC but the forum is often very laggy during the day my time (which is overnight UTC).

[greyhawk]

Strangely enough I have only ever gotten one 502 in the last few days. What browsers are you all using?

Chrome 24.0.1312.57 on Win7 Home Premium SP1
Chrome 18.0.1025469 on Android 4.2.1 GNex Build JOP40D

When the 502 problem appears, it's on both devices.

[cedivad]

I'm going to find some way of upgrading the hardware. There's probably some way to get more performance out of this hardware, but I don't know how.

If you tell us everything you know i would be happy to help.
And yes, upgrading the hardware is certainly the right thing to do.

The error log has too many trivial errors. I wasn't able to immediately find the 502s. I may look into it more later.

Most probably the 502s are caused by the php-fpm daemon, you won't find a lot of info on nginx/logs/error.log, it will just say "your php-fpm sucks".

[greyhawk]

502s again at 15:15 CET on IE 8.0.7601.17514 (don't judge  ) / Windows 7 Enterprise SP1

[Akka]

502s again at 15:15 CET on IE 8.0.7601.17514 (don't judge   ) / Windows 7 Enterprise SP1

That's interesting.

I have none. Yesterday I had some during the same time as you with my normal connection (from Germany)

Today US proxy and none.

Probably just coincidence.

[greyhawk]

I don't think it's connection related. I'm connected via X-WiN/GÉANT 2/Internet2 right now.