most of you have encountered the "User monumentaltrees already has more than 'max_user_connections' active connections" issue lately and I have gotten quite a few mails about this.
I wanted to let you know that I am aware of this, and I am thinking of a solution. In the meantime, some image lists might not contain photographs. The photographs are not gone, they are just not listed for the moment.
Details for those interested:
The mean reason is that at any given moment only a limited number of users can connect to the database behind the website, and lately, due to increasing visitor numbers there are more connections, but also (which I only discovered recently) due to an increasing number of registered species and photographs some calculations (the ordering of the images) takes up more and more time, causing connections to be locked and blocking access for other visitors.
I have already prohibited access for Chinese bots, and I'm thinking of a complete rewrite of the way these long running calculations are done.
The result would be is that the site will be faster, and have less of these "max_user_connections" errors. To avoid the errors for now, I have disabled these long running calculations that determine which images (and in which order) should be shown in the lists. So until I rewrite this, some lists might remain empty and others will not be updated.
Thank you for your patience.
um eine Überlastung der Webseite zu vermeiden, rate ich allen Nutzern die Fotos nicht in voller Auflösung hoch zu laden.
Wir sollten die Fotos auf eine maximale Kantenlänge von zum Beispiel 1300 dpi begrenzen!
Das lässt sich mit jeder, auch Freeware-Software leicht mit wenigen Klicks machen.
viele Grüße Frank
the size of the images does not matter. The number of bytes transferred is not the problem. Big photos do not stress the system. It is the number of connections made to the database and that can only be influenced by me (by making code changes) or by having less visitors. Please continue to upload photos in the largest resolution you have. In another 5 years photos uploaded now of say 3 MB or less can be impractically small.