Bonjour,
J'ai reçu un avertissement de la part de mon hébergeur disant que mes sites web Xoops consomment beaucoup trop de ressources de leur server. Voici ce qu'ils ont envoyé:
We have noticed that the database "bdwebtchangue" which is consuming excessive resources on our database servers. Due to this performance of the server goes down.
Database: bdwebtchangue
7 Day Traffic Info: 30786 Avg Queries / hr, 14 long queries logged, 1 long queries killed
I would suggest you to take the necessary action to avoid the issue.
Sample queries you can find below.
select * from camerxlive_config where (conf_modid = 'S' and conf_catid = 'S') order by conf_order asc
select sess_data, sess_ip from tchangue_session where sess_id = 'S'
select * from colombe_config where (conf_modid = 'S' and conf_catid = 'S') order by conf_order asc
select mid from tchangue_modules where dirname like 'S'
select sess_data, sess_ip from camerxlive_session where sess_id = 'S'
update colombe_session set sess_updated = N, sess_data = 'S' where sess_id = 'S'
delete from fraternite_protector_access where expire < unix_timestamp()
bdwebtchangue est la base de données Xoops du site web
www.tchangue.comMon compte est menacé d'être fermé si je ne résous pas le problème.
Quelle est la solution? D'où viennent ces requêtes excessives?
Merci