New version 1.6.27 intermittent problems to conection to database

[BusAmerica]

Hello

Since I updated to version 1.6.27, the gallery has intermittent connection issues:

"Coppermine critical error:
Unable to connect to database !

MySQLi said: 1203 : User u547111826_busamericaH already has more than 'max_user_connections' active connections"

Could it be the new version?

Greetings and thanks to the volunteers who make Coppermine

Alejandro

[ron4mac]

Assuming you were previously running CPG 1.6.26, there is no change with 1.6.27 that would cause any such error.

[BusAmerica]

Thank Ron

Yes, I used the 1.6.26 version, and change for de 1.6.27 version. With these started the problems.

Testing solutions, is it possible to restore version 1.6.26?
Well, it became non-operational due to these problems.

And thank you for keeping Coppermine alive and helping us.

Best regards

---------------------

Gracias.
Sí, usé la versión 1.6.26 y la cambié por la 1.6.27. Con esto empezaron los problemas.
Probando soluciones ¿es posible restaurar la version 1.6.26?
Pues se volvió no operativa por estos problemas

I gracias por mantener vivo a Coppermine y ayudarnos

Saludos

[phill104]

The error says it all. It is not the version that is your problem, but how many people are using your site. In PHP you can set a limit to the number of connections to the database you can have. This is for a number of reasons including to help stop spam ddos type attacks, to keep memory usage or CPU usage under control, to improve speed etc. It can be increased via the php.ini file but you will probably have to ask your host how to do that.

[BusAmerica]

Thanks Phill

Your message guides me

The hosting also indicates that it could be an attack.
I thought about restoring the site to its previous version a month ago to test options, but if it was an attack, it wouldn't work. The hosting seemed fine.

Now I see where to proceed with the issue: "php.ini"

Question: If it's an attack, should it be increased? Well, aren't those attacking it going to increase the number of connections even more?

A few months ago, a programmer from another similar site contacted me, suggesting I scrap Coppermine.
I suggested he collaborate with Coppermine Gallery instead, to help improve it if he had the knowledge.

Thanks again Phill to you and everyone who volunteers to help Coppermine.


******************

Gracias Phill
Tu mensaje me orienta

El hosting también indica que podría ser un ataque

Yo pensé en restaurar el sitio a su versión de un mes atrás, para probar opciones, pero si era un ataque no funcionaria. Al hosting le pareció bien.

Ahora veo por donde seguir el tema: "php.ini"
Consulta, si es un ataque conviene aumentarlo? pues los que atacana ¿no van incrementar aun mas las conexiones?

Hace unos meses se contactó un programador de otro sitio parecido proponiendo que  descartara Coppermine.
Yo le propuse que mejor colaborara con Coppermine Gallery, para ayudar a mejorarlo si tenía el conocimiento.

Gracias Phill una vez mas a vos y todos los que voluntariamente ayudan a Coppermine

[ron4mac]

Your site has so much content (categories,albums,photos) that loading some pages is quite slow. If, during this time, other requests are being made, then other database opens will happen all concurrently ... causing the problem.

You could try using a theme caching plugin to greatly reduce database access. The one downside is that 'random' images will show the same for at least one day (or whatever time period you have set for caching).

[BusAmerica]

Hello Ron

It's true that the Gallery has a lot of content and it slows it down.
But up until three or four weeks ago, it worked fine; now it doesn't.

I'll probably install the "Theme caching plugin" soon.
And then I'll let you know if the performance improves.

Thank you for your response and your work.

Best regards.

*********************

Hola

Es cierto que la Galeria tiene mucho contenido y la vuelve lenta.
Pero hasta hace tres o cuatro semanas funcionaba bien, ahora no.

Seguramente instalare el "Theme caching plugin" en breve.
y después les cuento si mejoró el rendimiento


Agradecido por tu respuesta y tu tarea
Saludos