pour continuer sur la discussion d’hier à propos des stats de spip et de la destruction de la table spip_referers_articles par mon hebergeur en raison d’un volume occupé trop important,
a noter aussi la disparition (précédente?) d’une autre table stats, spip_visites_articles
voici ce que j’obtiens maintenant dans le fichier log tmp/mysql.log (9ko)
est ce grave docteur ?
Dec 22 16:43:24 82.254.40.143 (pid 23620) GET /spip/spip.php?action=cron
Dec 22 16:43:25 82.254.40.143 (pid 23620) - UPDATE olivier_quenechdu.spip_referers_articles SET visites = visites+1 WHERE (id_article=1728 AND referer_md5=0x71b8dd8b15763db) OR (id_article=2192 AND referer_md5=0x7a796bf393074e9) OR (id_article=411 AND referer_md5=0x7a38a3333e5de27) OR (id_article=3048 AND referer_md5=0x8c42a006d4c570d) OR (id_article=2506 AND referer_md5=0x1c49f7e9a98e800) OR (id_article=1274 AND referer_md5=0xc211006972883e1) OR (id_article=1613 AND referer_md5=0x29e407be495f32f) OR (id_article=930 AND referer_md5=0x795743002e9da54) OR (id_article=823 AND referer_md5=0x2fb390f050efc74) OR (id_article=3239 AND referer_md5=0xe7be6e9153ff8dd) OR (id_article=3080 AND referer_md5=0xf87f719cdac5359)
Dec 22 16:43:25 82.254.40.143 (pid 23620) 1146 Table ‹ olivier_quenechdu.spip_referers_articles › doesn’t exist
Dec 22 17:03:24 38.98.19.67 (pid 23287) GET /spip/spip.php?article1987
Dec 22 17:03:24 38.98.19.67 (pid 23287) - INSERT IGNORE INTO olivier_quenechdu.spip_visites_articles (date, id_article) VALUES (‹ 2007-12-22 ›,2836), (‹ 2007-12-22 ›,2836), (‹ 2007-12-22 ›,3020), (‹ 2007-12-22 ›,2325), (‹ 2007-12-22 ›,1850), (‹ 2007-12-22 ›,1657), (‹ 2007-12-22 ›,1588), (‹ 2007-12-22 ›,1307), (‹ 2007-12-22 ›,2923), (‹ 2007-12-22 ›,2836), (‹ 2007-12-22 ›,2325), (‹ 2007-12-22 ›,2259), (‹ 2007-12-22 ›,2489), (‹ 2007-12-22 ›,1840), (‹ 2007-12-22 ›,2325), (‹ 2007-12-22 ›,2836), (‹ 2007-12-22 ›,632), (‹ 2007-12-22 ›,469), (‹ 2007-12-22 ›,2325), (‹ 2007-12-22 ›,41), (‹ 2007-12-22 ›,2325), (‹ 2007-12-22 ›,1625), (‹ 2007-12-22 ›,665), (‹ 2007-12-22 ›,579), (‹ 2007-12-22 ›,1428), (‹ 2007-12-22 ›,2836), (‹ 2007-12-22 ›,56), (‹ 2007-12-22 ›,2836), (‹ 2007-12-22 ›,1182), (‹ 2007-12-22 ›,1952), (‹ 2007-12-22 ›,1952), (‹ 2007-12-22 ›,632), (‹ 2007-12-22 ›,2319), (‹ 2007-12-22 ›,2980), (‹ 2007-12-22 ›,2600), (‹ 2007-12-22 ›,164), (‹ 2007-12-22 ›,1265), (‹ 2007-12-22 ›,1372), (‹ 2007-12-22 ›,1359), (‹ 2007-12-22 ›,252), (‹ 2007-12-22 ›,1952), (‹ 2007-12-22 ›,961)
Dec 22 17:03:24 38.98.19.67 (pid 23287) 1146 Table ‹ olivier_quenechdu.spip_visites_articles › doesn’t exist
Dec 22 17:03:24 38.98.19.67 (pid 23287) GET /spip/spip.php?article1987
Dec 22 17:03:24 38.98.19.67 (pid 23287) - UPDATE olivier_quenechdu.spip_visites_articles SET visites = visites + 6*((id_article IN (2836))) + 1*((id_article IN (3020,1850,1657,1588,1307,2923,2259,2489,1840,469,41,1625,665,579,1428,56,1182,2319,2980,2600,164,1265,1372,1359,252,961))) + 5*((id_article IN (2325))) + 2*((id_article IN (632))) + 3*((id_article IN (1952))) WHERE date=‹ 2007-12-22 › AND ((id_article IN (2836,3020,2325,1850,1657,1588,1307,2923,2259,2489,1840,632,469,41,1625,665,579,1428,56,1182,1952,2319,2980,2600,164,1265,1372,1359,252,961)))
Dec 22 17:03:24 38.98.19.67 (pid 23287) 1146 Table ‹ olivier_quenechdu.spip_visites_articles › doesn’t exist
Dec 22 17:03:25 38.98.19.67 (pid 23287) GET /spip/spip.php?article1987
Dec 22 17:03:25 38.98.19.67 (pid 23287) - INSERT IGNORE INTO olivier_quenechdu.spip_referers_articles (date, referer, referer_md5, id_article) VALUES (‹ 2007-12-22 ›, ‹ http://www.google.be/search?q=bande+annonce+de+rocky+4&hl=fr&start=30&sa=N ›,
0x73b34e9851c9e22, 1850), (‹ 2007-12-22 ›, ‹ http://www.google.fr/search?sourceid=navclient&hl=fr&ie=UTF-8&rlz=1T4GZEZ_frFR252FR252&q=MUSIQUE+SPIDERMAN+3 ›,
0xbd70db5488afe69, 1588), (‹ 2007-12-22 ›, ‹ http://www.google.fr/search?hl=fr&sa=X&oi=spell&resnum=0&ct=result&cd=1&q=BO+piege+de+cristal&spell=1 ›,
0x2ff241bedc86d27, 1307), (‹ 2007-12-22 ›, ‹ http://www.google.fr/search?hl=fr&q=madmax+musique&meta= ›,
0xbafb37b1b006dcf, 1840), (‹ 2007-12-22 ›, ‹ http://fr.search.yahoo.com/search?ei=UTF-8&rd=r1&fr=yfp-t-501&p=clara+morgane&SpellState=n-746656880_q-OGX6ecUsMzI0S12b5gWC7gAAAA%40%40&fr2=sp-top ›,
0x2bb1b6528c7dc60, 632), (‹ 2007-12-22 ›, ‹ http://www.google.fr/search?sourceid=navclient&hl=fr&ie=UTF-8&rlz=1T4SUNA_fr___FR214&q=Blog+de+musique+de+avril+lavigne ›,
0x33d6e2dccc00717, 41), (‹ 2007-12-22 ›, ‹ http://www.google.co.ma/search?hl=fr&q=la+chanson+dans+le+film+« lolita+malgre+moi »&btnG=Recherche+Google&meta= ›,
0x22c8a6a69d4e818, 1428), (‹ 2007-12-22 ›, ‹ http://www.google.fr/search?hl=fr&q=chanson+de+pirates+de+caraibe&meta= ›,
0xed39f172570d672, 1182), (‹ 2007-12-22 ›, ‹ http://images.search.yahoo.com/search/images/view?back=http%3A%2F%2Fimages.search.yahoo.com%2Fsearch%2Fimages%3Fp%3Deva%2Bgreen%26ei%3DUTF-8%26js%3D1%26ni%3D20%26fr%3Dyfp-t-501%26b%3D401&w=694&h=1238&imgurl=olivier.quenechdu.free.fr%2Fspip%2FIMG%2Fjpg%2Feva-green_29.jpg&rurl=http%3A%2F%2Folivier.quenechdu.free.fr%2Fspip%2Fspip.php%3Farticle1359&size=298.1kB&name=eva-green_29.jpg&p=eva+green&type=jpeg&no=406&tt=26,809&oid=8f651d288ac62294&ei=UTF-8 ›,
0xa8cb03e4bb8c9eb, 1359)
Dec 22 17:03:25 38.98.19.67 (pid 23287) 1146 Table ‹ olivier_quenechdu.spip_referers_articles › doesn’t exist
Dec 22 17:03:25 38.98.19.67 (pid 23287) GET /spip/spip.php?article1987
Dec 22 17:03:25 38.98.19.67 (pid 23287) - UPDATE olivier_quenechdu.spip_referers_articles SET visites = visites+1 WHERE (id_article=1850 AND referer_md5=0x73b34e9851c9e22) OR (id_article=1588 AND referer_md5=0xbd70db5488afe69) OR (id_article=1307 AND referer_md5=0x2ff241bedc86d27) OR (id_article=1840 AND referer_md5=0xbafb37b1b006dcf) OR (id_article=632 AND referer_md5=0x2bb1b6528c7dc60) OR (id_article=41 AND referer_md5=0x33d6e2dccc00717) OR (id_article=1428 AND referer_md5=0x22c8a6a69d4e818) OR (id_article=1182 AND referer_md5=0xed39f172570d672) OR (id_article=1359 AND referer_md5=0xa8cb03e4bb8c9eb)
Dec 22 17:03:25 38.98.19.67 (pid 23287) 1146 Table ‹ olivier_quenechdu.spip_referers_articles › doesn’t exist
Dec 22 17:18:42 38.98.19.68 (pid 26242) GET /spip/spip.php?article390
Dec 22 17:18:42 38.98.19.68 (pid 26242) - INSERT IGNORE INTO olivier_quenechdu.spip_visites_articles (date, id_article) VALUES (‹ 2007-12-22 ›,2836), (‹ 2007-12-22 ›,252), (‹ 2007-12-22 ›,2836), (‹ 2007-12-22 ›,834), (‹ 2007-12-22 ›,1381), (‹ 2007-12-22 ›,2335), (‹ 2007-12-22 ›,2325), (‹ 2007-12-22 ›,2489), (‹ 2007-12-22 ›,367), (‹ 2007-12-22 ›,1278), (‹ 2007-12-22 ›,1031), (‹ 2007-12-22 ›,1278), (‹ 2007-12-22 ›,2325), (‹ 2007-12-22 ›,2162), (‹ 2007-12-22 ›,98), (‹ 2007-12-22 ›,2986), (‹ 2007-12-22 ›,23), (‹ 2007-12-22 ›,2675), (‹ 2007-12-22 ›,2836)
Dec 22 17:18:42 38.98.19.68 (pid 26242) 1146 Table ‹ olivier_quenechdu.spip_visites_articles › doesn’t exist
Dec 22 17:18:42 38.98.19.68 (pid 26242) GET /spip/spip.php?article390
Dec 22 17:18:42 38.98.19.68 (pid 26242) - UPDATE olivier_quenechdu.spip_visites_articles SET visites = visites + 3*((id_article IN (2836))) + 1*((id_article IN (252,834,1381,2335,2489,367,1031,2162,98,2986,23,2675))) + 2*((id_article IN (2325,1278))) WHERE date=‹ 2007-12-22 › AND ((id_article IN (2836,252,834,1381,2335,2325,2489,367,1278,1031,2162,98,2986,23,2675)))
Dec 22 17:18:42 38.98.19.68 (pid 26242) 1146 Table ‹ olivier_quenechdu.spip_visites_articles › doesn’t exist
Dec 22 17:18:42 38.98.19.68 (pid 26242) GET /spip/spip.php?article390
Dec 22 17:18:42 38.98.19.68 (pid 26242) - INSERT IGNORE INTO olivier_quenechdu.spip_referers_articles (date, referer, referer_md5, id_article) VALUES (‹ 2007-12-22 ›, ‹ http://www.google.fr/search?hl=fr&q=les+chevaliers+du+ciel+clara+morgane&meta= ›,
0xa35357ff22c211f, 834), (‹ 2007-12-22 ›, ‹ http://www.google.be/search?hl=fr&q=americain+girls+musique&meta=lr%3Dlang_fr ›,
0x28c5201c3e098d8, 2335), (‹ 2007-12-22 ›, ‹ http://www.google.fr/search?hl=fr&q=Syriana+politique+étrangère+des+Etats-Unis&meta= ›,
0x20ce1c657c6fb10, 1031), (‹ 2007-12-22 ›, ‹ http://www.google.hu/search?hl=hu&q=die+hard+4+ost&meta= ›,
0xe20b73f5d7dae52, 2162)
Dec 22 17:18:42 38.98.19.68 (pid 26242) 1146 Table ‹ olivier_quenechdu.spip_referers_articles › doesn’t exist
Dec 22 17:18:42 38.98.19.68 (pid 26242) GET /spip/spip.php?article390
Dec 22 17:18:42 38.98.19.68 (pid 26242) - UPDATE olivier_quenechdu.spip_referers_articles SET visites = visites+1 WHERE (id_article=834 AND referer_md5=0xa35357ff22c211f) OR (id_article=2335 AND referer_md5=0x28c5201c3e098d8) OR (id_article=1031 AND referer_md5=0x20ce1c657c6fb10) OR (id_article=2162 AND referer_md5=0xe20b73f5d7dae52)
Dec 22 17:18:42 38.98.19.68 (pid 26242) 1146 Table ‹ olivier_quenechdu.spip_referers_articles › doesn’t exist
Thanx