Hola, mando esto a la lista por los problemas que estamos teniendo con el servidor, nos han remitido un reporter y nos dicen que el problema es nuestro, que consume todos los recursos de la m‡quina, (que es potente por cierto y nos advierten que aumentarla es retrasar simplemente el problema) y nosotros todas las webs las tenemos con spip, as’ que no sŽ como tratarlo, si a alguien le ha ocurrido algo parecido o tiene idea de quŽ va.
Ejemplo de fallo de una de las bases de datos
Id User Host db Command Time State Info
71310 XXXX XXXX XXXX Query 85 Copying to tmp table SELECT articles.id_rubrique, articles.id_article, articles.titre, articles.texte, articles.chapo, articles.descriptif, articles.lang\nFROM `XXXX`.spip_mots_articles AS `L1`, `qbt386`.spip_articles AS `articles`\nWHERE (L1.id_mot = '119')\n\tAND ((articles.id_article NOT IN (0,26506,26949,26971,26960,26953,26954,26947)))\n\tAND (articles.statut = "publie")\n\tAND (articles.date < NOW())\n\tAND articles.id_article=L1.id_article\nORDER BY articles.date DESC\nLIMIT 0,1
Ejemplo de otra base de datos
71338 XXX XXXX2 XXX Query 54 Copying to tmp table SELECT articles.id_article, articles.titre, articles.lang\nFROM `qci835`.spip_mots_articles AS `L1`, `qci835`.spip_mots AS `L2`, `XXX`.spip_articles AS `articles`\nWHERE (L2.titre = 'Última hora')\n\tAND ((articles.id_article NOT IN (0)))\n\tAND (articles.statut = "publie")\n\tAND (articles.date <= '2009-05-14 12:32:59')\n\tAND L1.id_mot=L2.id_mot\n\tAND articles.id_article=L1.id_article\nGROUP BY articles.id_article\nORDER BY articles.date DESC
Ejemplo de una tercera base de datosÉ
71340 XXXX XXXXX XXXX Query 86 Sorting result SELECT articles.id_article, articles.descriptif, articles.titre, articles.lang\nFROM `XXXX`.spip_articles AS `articles`\nWHERE ((articles.id_rubrique IN (89,29,32,33,34,35,38,36,37)))\n\tAND (articles.statut = "publie")\nORDER BY articles.titre DESC
o tambiŽn en esta misma base de datos
71339 XXX XXXX qbt408 Query 89 Sorting result SELECT syndic_articles.url, syndic_articles.titre, syndic_articles.descriptif, syndic_articles.id_syndic_article\nFROM `XXXX`.spip_syndic_articles AS `syndic_articles`, `qbt408`.spip_syndic AS `J1`\nWHERE (syndic_articles.id_syndic = '1')\n\tAND ((syndic_articles.id_syndic_article NOT IN (0)))\n\tAND (syndic_articles.id_syndic = J1.id_syndic)\n\tAND (syndic_articles.statut = "publie")\n\tAND (J1.statut = "publie")\nORDER BY syndic_articles.date DESC\nLIMIT 0,15
Salud y gracias
Carlos PE–a