Привет всем!
После обновления ПО сервера возникла проблема с одним из древних сайтов.
Периодически процесс mysqld вызывает 100%+ загрузку процессора, при этом SHOW PROCESSLIST показывает множество копий одного и того же запроса к базе в состоянии Sending data:
В скрипте проблемный запрос выглядит так:
1.
2.
3.
4.
5.
6.
7.
8.
$result=mysql_query('SELECT DISTINCT LEFT(datearticle,10) as date, titlearticle, subtitlearticle, photoauthor, fio, author.idauthor, regalion, link, source, reviewarticle, textarticle, category.idcategory,category.urlname as urlname
FROM article,source,typearticle,author,subcategory,category
WHERE article.idsubcategory=subcategory.idsubcategory
AND subcategory.idcategory=category.idcategory
AND article.idsource=source.idsource
AND article.idauthor=author.idauthor
AND article.idtypearticle=typearticle.idtypearticle
AND article.idarticle='.$_GET['idarticle'].' LIMIT 1');
Так в логах:
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
SELECT DISTINCT LEFT(datearticle,10) as date, titlearticle, subtitlearticle, photoauthor, fio, author.idauthor, regalion, link, source, reviewarticle, textarticle, category.idcategory,category.urlname as urlname FROM article,source,typearticle,author,subcategory,category WHERE article.idsubcategory=subcategory.idsubcategory AND subcategory.idcategory=category.idcategory AND article.idsource=source.idsource AND article.idauthor=author.idauthor AND article.idtypearticle=typearticle.idtypearticle AND article.idarticle=011582 or 1=(/**/sElEcT 1 /**/fRoM(/**/sElEcT count(*),/**/cOnCaT((/**/sElEcT(/**/sElEcT /**/uNhEx(/**/hEx(/**/cOnCaT(0x217e21,0x4142433134355a5136324457514146504f4959434644,0x217e21)))) /**/fRoM information_schema./**/tAbLeS /**/lImIt 0,1),floor(rand(0)*2))x /**/fRoM information_schema./**/tAbLeS /**/gRoUp/**/bY x)a) and 1=1 LIMIT 1
SELECT DISTINCT LEFT(datearticle,10) as date, titlearticle, subtitlearticle, photoauthor, fio, author.idauthor, regalion, link, source, reviewarticle, textarticle, category.idcategory,category.urlname as urlname FROM article,source,typearticle,author,subcategory,category WHERE article.idsubcategory=subcategory.idsubcategory AND subcategory.idcategory=category.idcategory AND article.idsource=source.idsource AND article.idauthor=author.idauthor AND article.idtypearticle=typearticle.idtypearticle AND article.idarticle=011582 or 1=(/**/sElEcT 1 /**/fRoM(/**/sElEcT count(*),/**/cOnCaT((/**/sElEcT(/**/sElEcT /**/uNhEx(/**/hEx(/**/cOnCaT(0x217e21,0x4142433134355a5136324457514146504f4959434644,0x217e21)))) /**/fRoM information_schema./**/tAbLeS /**/lImIt 0,1),floor(rand(0)*2))x /**/fRoM information_schema./**/tAbLeS /**/gRoUp/**/bY x)a) and 1=1 LIMIT 1
SELECT DISTINCT LEFT(datearticle,10) as date, titlearticle, subtitlearticle, photoauthor, fio, author.idauthor, regalion, link, source, reviewarticle, textarticle, category.idcategory,category.urlname as urlname FROM article,source,typearticle,author,subcategory,category WHERE article.idsubcategory=subcategory.idsubcategory AND subcategory.idcategory=category.idcategory AND article.idsource=source.idsource AND article.idauthor=author.idauthor AND article.idtypearticle=typearticle.idtypearticle AND article.idarticle=011582 or 1=(/**/sElEcT 1 /**/fRoM(/**/sElEcT count(*),/**/cOnCaT((/**/sElEcT(/**/sElEcT /**/uNhEx(/**/hEx(/**/cOnCaT(0x217e21,0x4142433134355a5136324457514146504f4959434644,0x217e21)))) /**/fRoM information_schema./**/tAbLeS /**/lImIt 0,1),floor(rand(0)*2))x /**/fRoM information_schema./**/tAbLeS /**/gRoUp/**/bY x)a) and 1=1 LIMIT 1
SELECT DISTINCT LEFT(datearticle,10) as date, titlearticle, subtitlearticle, photoauthor, fio, author.idauthor, regalion, link, source, reviewarticle, textarticle, category.idcategory,category.urlname as urlname FROM article,source,typearticle,author,subcategory,category WHERE article.idsubcategory=subcategory.idsubcategory AND subcategory.idcategory=category.idcategory AND article.idsource=source.idsource AND article.idauthor=author.idauthor AND article.idtypearticle=typearticle.idtypearticle AND article.idarticle=011582 or 1=(/**/sElEcT 1 /**/fRoM(/**/sElEcT count(*),/**/cOnCaT((/**/sElEcT(/**/sElEcT /**/uNhEx(/**/hEx(/**/cOnCaT(0x217e21,0x4142433134355a5136324457514146504f4959434644,0x217e21)))) /**/fRoM information_schema./**/tAbLeS /**/lImIt 0,1),floor(rand(0)*2))x /**/fRoM information_schema./**/tAbLeS /**/gRoUp/**/bY x)a) and 1=1 LIMIT 1
SELECT DISTINCT LEFT(datearticle,10) as date, titlearticle, subtitlearticle, photoauthor, fio, author.idauthor, regalion, link, source, reviewarticle, textarticle, category.idcategory,category.urlname as urlname FROM article,source,typearticle,author,subcategory,category WHERE article.idsubcategory=subcategory.idsubcategory AND subcategory.idcategory=category.idcategory AND article.idsource=source.idsource AND article.idauthor=author.idauthor AND article.idtypearticle=typearticle.idtypearticle AND article.idarticle=011582 or 1=(/**/sElEcT 1 /**/fRoM(/**/sElEcT count(*),/**/cOnCaT((/**/sElEcT(/**/sElEcT /**/uNhEx(/**/hEx(/**/cOnCaT(0x217e21,0x4142433134355a5136324457514146504f4959434644,0x217e21)))) /**/fRoM information_schema./**/tAbLeS /**/lImIt 0,1),floor(rand(0)*2))x /**/fRoM information_schema./**/tAbLeS /**/gRoUp/**/bY x)a) and 1=1 LIMIT 1
SELECT DISTINCT LEFT(datearticle,10) as date, titlearticle, subtitlearticle, photoauthor, fio, author.idauthor, regalion, link, source, reviewarticle, textarticle, category.idcategory,category.urlname as urlname FROM article,source,typearticle,author,subcategory,category WHERE article.idsubcategory=subcategory.idsubcategory AND subcategory.idcategory=category.idcategory AND article.idsource=source.idsource AND article.idauthor=author.idauthor AND article.idtypearticle=typearticle.idtypearticle AND article.idarticle=011582 or 1=(/**/sElEcT 1 /**/fRoM(/**/sElEcT count(*),/**/cOnCaT((/**/sElEcT(/**/sElEcT /**/uNhEx(/**/hEx(/**/cOnCaT(0x217e21,0x4142433134355a5136324457514146504f4959434644,0x217e21)))) /**/fRoM information_schema./**/tAbLeS /**/lImIt 0,1),floor(rand(0)*2))x /**/fRoM information_schema./**/tAbLeS /**/gRoUp/**/bY x)a) and 1=1 LIMIT 1
Заранее спасибо за помощь! |
