[LCWO LOGO]  

Login

User name:
Password:


Language
Български Português brasileiro
Bosanski Català
繁體中文 Česky
Dansk Deutsch
English Español
Suomi Français
Ελληνικά Hrvatski
Magyar Italiano
日本語 Bahasa Melayu
Nederlands Norsk
Polski Português
Română Русский
සිංහල Slovenščina
Srpski Svenska
ภาษาไทย Türkçe
Українська 简体中文

Who is online? (19)


LCWO Discussion Forum [Atom LCWO Forum Feed]

This is a simple discussion forum for LCWO users. Feel free to use it for any kind of discussion related to this website.

Thread: site availability

Back to the Forum

AuthorText


Posted: 2011-08-05 16:35
Hi Fabian,

FYI: Do you know lcwo.net is sometimes unreachable for a few minutes? Sometimes really unreachable (no ping), sometimes I get an error after a delay:

Warning: mysql_connect() [function.mysql-connect]: User d00801bf already has more than 'max_user_connections' active connections in /www/htdocs/v135911/lcwo/connectdb.php on line 8

Cheers,
Joep
Administrator


Posted: 2011-08-06 07:51
Hi Joep,

I just experienced this effect. Observed it once a few months ago, but it never happened again, so I didn't think abou it any further. But since it now seems to occur more often, it's something I need to investigate.

Thanks for the hint & 73,
Fabian


Posted: 2011-08-06 16:04
Fabian,

Another thing that seems to have changed recently is that my login times out several times a day. It looks like something to do with cookie handling has changed.

Colin
Administrator


Posted: 2011-08-10 19:17
Mh, the session lifetime should not have changed, it still sits at 12h, but a session is destroyed if the IP address changes. Maybe I should finally learn how to set permanent cookies :-).

The database problem seems to be a problem with the scalability of the highscore generation. There are close to one million results in the database now, and the generation of the highscore lists happens on-the-fly. Depending on the server load this may take some time, and during that time the server seems not to be very responsive. Consequently a lot of requests will pile up and after a while the maximum number of database connections is reached. I will use some caching and use pre-calculated highscore results (at least for the Koch course, where the generation of the results is most complicated).

I will be on vacation for the next week with somewhat limited net access, but after that I will allocate some time for work LCWO again :-)

73
Fabian DJ1YFK


Posted: 2011-08-21 09:52
Hi Fabian,

It looks like selecting 'high scores' from the top menu is an effective way to bring the site down...
You might consider disabling this option until you have time to fix this.

Joep
Administrator


Posted: 2011-08-21 10:33
Thanks Joep,

I just disabled the highscores for the Koch course only and it seems to have improved the situation significantly already. I will modify the highscore lists to be pre-calculated at regular intervals.

73
Fabian DJ1YFK

Back to the Forum

You must be logged in to post a message.

$Id: forum.php 62 2015-01-12 17:34:44Z fabian $