SmartCJ Support Forum

Здравствуйте.
Подскажите, есть ли какой запрос в MySQL, чтобы удалило галеры помеченные к удалению? Очень долго удаляет, оно будет месяц удалять с такой скоростью. Ведь можно их грохнуть через мускуль?

Одно знапроса нет и они разные в зависимсоти от того что и как удаляется.
А что знает медленно удаляет ?
покажите плз rot.log часть с удалением.

Мы пометили на удаление 131к видео. В сутки удаляет 3-4к всего очень медленно.
Саппорт адвансед хостер пишет что 1 тумба удаляется примерно 2,5 секунды. Таким образом удаление будет идти очень долго. Новое видео не доавляем пока в базу. Может есть вариант как то ускорить ? Попробывали так:
если надо удалить “прямо сейчас” - запускаем rot.php с параметром process_deleted=true

cd /PATH_TO_/scj/bin/; env HTTP_HOST=yourdomain.com php rot.php process_deleted=true


Вот таким образом и идет удаление. Еси способо как то в мускуле выделить помеченные к удалению и удалить скопом сразу все их ?

2014-01-16 14:10 Deleted 46470 (140286.32708788, 0.021121978759766)
2014-01-16 14:10 Deleting thumb 941381 (157.95691299438, 3.5837941169739)
2014-01-16 14:10 Deleting thumb 3194409 (140289.95229483, 3.6252069473267)
2014-01-16 14:10 Deleting thumb 3194409 (161.86677694321, 3.909863948822)
2014-01-16 14:10 Deleting thumb 3194419 (140293.58732891, 3.6350340843201)
2014-01-16 14:10 Deleting thumb 3194419 (165.50791501999, 3.6411380767822)
2014-01-16 14:10 Deleted 40 (165.51595306396, 0.0080380439758301)
2014-01-16 14:10 Deleting thumb 960761 (140297.03362989, 3.446300983429)
2014-01-16 14:10 Deleting thumb 960761 (169.19455599785, 3.6786029338837)
2014-01-16 14:11 Deleting thumb 960762 (140300.48967004, 3.4560401439667)
2014-01-16 14:11 Deleting thumb 960762 (172.62176799774, 3.4272119998932)
2014-01-16 14:11 Deleting thumb 960763 (140303.78891993, 3.2992498874664)
2014-01-16 14:11 Deleting thumb 960763 (175.94458699226, 3.3228189945221)
2014-01-16 14:11 Deleting thumb 960764 (140307.13985491, 3.3509349822998)
2014-01-16 14:11 Deleting thumb 960764 (179.52979397774, 3.5852069854736)
2014-01-16 14:11 Deleting thumb 960765 (140311.2007339, 4.0608789920807)
2014-01-16 14:11 Deleting thumb 960765 (183.5444290638, 4.0146350860596)
2014-01-16 14:11 Deleting thumb 960766 (140315.07497501, 3.8742411136627)
2014-01-16 14:11 Deleting thumb 960766 (187.17821192741, 3.6337828636169)
2014-01-16 14:11 Deleting thumb 960767 (140319.46440196, 4.38942694664)
2014-01-16 14:11 Deleting thumb 960767 (192.4631049633, 5.2848930358887)
2014-01-16 14:11 Deleting thumb 960768 (140324.54371905, 5.0793170928955)
2014-01-16 14:11 Deleted 46480 (140324.56477904, 0.021059989929199)
2014-01-16 14:11 Deleting thumb 960768 (198.56392288208, 6.1008179187775)
2014-01-16 14:11 Deleting thumb 3194421 (140330.39790487, 5.8331258296967)
2014-01-16 14:11 Deleting thumb 3194421 (202.50453305244, 3.9406101703644)
2014-01-16 14:11 Deleting thumb 3194469 (140333.83122301, 3.4333181381226)
2014-01-16 14:11 Deleting thumb 3194469 (205.80816102028, 3.3036279678345)
2014-01-16 14:11 Deleted 50 (205.81936597824, 0.011204957962036)
2014-01-16 14:11 Deleting thumb 960769 (140336.95033288, 3.1191098690033)
2014-01-16 14:11 Deleting thumb 960769 (208.84079885483, 3.0214328765869)
2014-01-16 14:11 Deleting thumb 960770 (140340.24850202, 3.2981691360474)
2014-01-16 14:11 Deleting thumb 960770 (212.12013101578, 3.2793321609497)
2014-01-16 14:11 Deleting thumb 1038041 (140343.08135295, 2.832850933075)
2014-01-16 14:11 Deleting thumb 1038041 (214.99014306068, 2.8700120449066)
2014-01-16 14:11 Deleting thumb 1038042 (140345.75648093, 2.6751279830933)
2014-01-16 14:11 Deleting thumb 1038042 (217.53349900246, 2.5433559417725)
2014-01-16 14:11 Deleting thumb 1038044 (140348.44498205, 2.6885011196136)
2014-01-16 14:11 Deleting thumb 1038044 (220.18879199028, 2.6552929878235)
2014-01-16 14:11 Deleting thumb 1038046 (140351.18590999, 2.7409279346466)
2014-01-16 14:11 Deleting thumb 1038046 (223.0825150013, 2.8937230110168)
2014-01-16 14:11 Deleting thumb 1038048 (140353.99413395, 2.8082239627838)
2014-01-16 14:11 Deleting thumb 1038048 (225.80284690857, 2.7203319072723)
2014-01-16 14:11 Deleting thumb 1038050 (140356.72940683, 2.7352728843689)
2014-01-16 14:11 Deleted 46490 (140356.74692297, 0.017516136169434)
2014-01-16 14:11 Deleting thumb 1038050 (228.60053896904, 2.7976920604706)
2014-01-16 14:11 Deleting thumb 3194499 (140359.50611186, 2.7591888904572)
2014-01-16 14:12 Deleting thumb 3194499 (231.24547505379, 2.6449360847473)
2014-01-16 14:12 Deleting thumb 3194519 (140362.33912683, 2.8330149650574)
2014-01-16 14:12 Deleting thumb 3194519 (234.1628010273, 2.9173259735107)
2014-01-16 14:12 Deleted 60 (234.17813491821, 0.015333890914917)
2014-01-16 14:12 Deleting thumb 1038052 (140365.57849884, 3.2393720149994)
2014-01-16 14:12 Deleting thumb 1038052 (238.93135499954, 4.7532200813293)
2014-01-16 14:12 Deleting thumb 1038054 (140370.99281001, 5.414311170578)
2014-01-16 14:12 Deleting thumb 1038054 (244.85686802864, 5.9255130290985)
2014-01-16 14:12 Deleting thumb 1038056 (140376.47658706, 5.4837770462036)
2014-01-16 14:12 Deleting thumb 1038056 (250.32392597198, 5.4670579433441)
2014-01-16 14:12 Deleting thumb 1038058 (140382.00205183, 5.5254647731781)
2014-01-16 14:12 Deleting thumb 1038058 (255.81815695763, 5.4942309856415)
2014-01-16 14:12 Deleting thumb 1099561 (140387.17318106, 5.1711292266846)
2014-01-16 14:12 Deleting thumb 1099561 (260.09506702423, 4.2769100666046)
2014-01-16 14:12 Deleting thumb 1099562 (140391.23316884, 4.059987783432)
2014-01-16 14:12 Deleting thumb 1099562 (264.09308004379, 3.9980130195618)
2014-01-16 14:12 Deleting thumb 1099563 (140395.11703396, 3.8838651180267)
2014-01-16 14:12 Deleting thumb 1099563 (267.50280284882, 3.4097228050232)
2014-01-16 14:12 Deleting thumb 1099564 (140398.40981984, 3.2927858829498)
2014-01-16 14:12 Deleted 46500 (140398.42838502, 0.01856517791748)
2014-01-16 14:12 Deleting thumb 1099564 (270.67025899887, 3.1674561500549)
2014-01-16 14:12 Deleting thumb 3194559 (140401.74243593, 3.3140509128571)
2014-01-16 14:12 Deleting thumb 3194559 (274.16665792465, 3.4963989257812)
2014-01-16 14:12 Deleting thumb 3194561 (140405.11728883, 3.3748528957367)
2014-01-16 14:12 Deleting thumb 3194561 (277.56589102745, 3.3992331027985)
2014-01-16 14:12 Deleted 70 (277.57427787781, 0.0083868503570557)
2014-01-16 14:12 Deleting thumb 1099565 (140408.42366695, 3.3063781261444)
2014-01-16 14:12 Deleting thumb 1099565 (281.02538585663, 3.4511079788208)
2014-01-16 14:12 Deleting thumb 1099566 (140411.94809198, 3.5244250297546)
2014-01-16 14:12 Deleting thumb 1099566 (285.2334048748, 4.2080190181732)
2014-01-16 14:12 Deleting thumb 1099567 (140416.03524494, 4.0871529579163)
2014-01-16 14:12 Deleting thumb 1099567 (288.89851999283, 3.6651151180267)
2014-01-16 14:12 Deleting thumb 1099568 (140419.585742, 3.5504970550537)
2014-01-16 14:13 Deleting thumb 1099568 (293.49816393852, 4.599643945694)
2014-01-16 14:13 Deleting thumb 1099569 (140424.34758401, 4.7618420124054)
2014-01-16 14:13 Deleting thumb 1099569 (298.66243100166, 5.1642670631409)
2014-01-16 14:13 Deleting thumb 1099570 (140429.58767796, 5.2400939464569)
2014-01-16 14:13 Deleting thumb 1099570 (303.43345594406, 4.7710249423981)
2014-01-16 14:13 Deleting thumb 1102519 (140434.04437304, 4.4566950798035)
2014-01-16 14:13 Deleting thumb 1102519 (308.02966594696, 4.5962100028992)
2014-01-16 14:13 Deleting thumb 1102520 (140439.04890394, 5.0045309066772)
2014-01-16 14:13 Deleted 46510 (140439.07138085, 0.0224769115448)
2014-01-16 14:13 Deleting thumb 1102520 (312.75662493706, 4.726958990097)
2014-01-16 14:13 Deleting thumb 3194592 (140443.77108002, 4.6996991634369)
2014-01-16 14:13 Deleting thumb 3194592 (316.83498597145, 4.0783610343933)
2014-01-16 14:13 Deleting thumb 3194611 (140447.99565792, 4.2245779037476)
2014-01-16 14:13 Deleting thumb 3194611 (319.98259902, 3.1476130485535)
2014-01-16 14:13 Deleted 80 (319.99223208427, 0.0096330642700195)
2014-01-16 14:13 Deleting thumb 1102521 (140450.93946791, 2.9438099861145)
2014-01-16 14:13 Deleting thumb 1102521 (322.72562408447, 2.7333920001984)
2014-01-16 14:13 Deleting thumb 1102522 (140453.87800694, 2.9385390281677)
2014-01-16 14:13 Deleting thumb 1102522 (325.35798406601, 2.6323599815369)
2014-01-16 14:13 Deleting thumb 1102523 (140456.26910496, 2.3910980224609)
2014-01-16 14:13 Deleting thumb 1102523 (327.77043390274, 2.412449836731)
2014-01-16 14:13 Deleting thumb 1102526 (140458.75998902, 2.4908840656281)
2014-01-16 14:13 Deleting thumb 1102526 (330.42697691917, 2.6565430164337)
2014-01-16 14:13 Deleting thumb 1102528 (140461.51690984, 2.7569208145142)
2014-01-16 14:13 Deleting thumb 1102528 (333.31657385826, 2.8895969390869)
2014-01-16 14:13 Deleting thumb 1102530 (140464.32129192, 2.8043820858002)
2014-01-16 14:13 Deleting thumb 1102530 (336.09035086632, 2.7737770080566)
2014-01-16 14:13 Deleting thumb 1102532 (140467.1002419, 2.7789499759674)
2014-01-16 14:13 Deleting thumb 1102532 (339.03041601181, 2.9400651454926)
2014-01-16 14:13 Deleting thumb 1111536 (140469.98541784, 2.8851759433746)
2014-01-16 14:13 Deleted 46520 (140470.01579499, 0.030377149581909)
2014-01-16 14:13 Deleting thumb 1111536 (342.52764487267, 3.4972288608551)
2014-01-16 14:13 Deleting thumb 3194612 (140473.55906701, 3.5432720184326)
2014-01-16 14:13 Deleting thumb 3194612 (346.07312393188, 3.5454790592194)
2014-01-16 14:13 Deleting thumb 3194634 (140477.08442283, 3.5253558158875)
2014-01-16 14:14 Deleting thumb 3194634 (349.69821000099, 3.6250860691071)
2014-01-16 14:14 Deleted 90 (349.71232485771, 0.014114856719971)
2014-01-16 14:14 Deleting thumb 1111537 (140480.80356002, 3.7191371917725)
2014-01-16 14:14 Deleting thumb 1111537 (353.70940208435, 3.9970772266388)
2014-01-16 14:14 Deleting thumb 1111538 (140484.82045984, 4.0168998241425)
2014-01-16 14:14 Deleting thumb 1111538 (357.41819691658, 3.7087948322296)
2014-01-16 14:14 Deleting thumb 1111539 (140488.60580993, 3.7853500843048)
2014-01-16 14:14 Deleting thumb 1111539 (361.2933318615, 3.8751349449158)
2014-01-16 14:14 Deleting thumb 1111540 (140492.48141384, 3.8756039142609)
2014-01-16 14:14 Deleting thumb 1111540 (364.97622394562, 3.6828920841217)
2014-01-16 14:14 Deleting thumb 1111541 (140496.15920806, 3.6777942180634)
2014-01-16 14:14 Deleting thumb 1111541 (368.69251489639, 3.7162909507751)
2014-01-16 14:14 Deleting thumb 1111542 (140500.46298099, 4.3037729263306)
2014-01-16 14:14 Deleting thumb 1111542 (372.91602897644, 4.2235140800476)
2014-01-16 14:14 Deleting thumb 1111543 (140504.68405294, 4.2210719585419)
2014-01-16 14:14 Deleting thumb 1111543 (377.13249707222, 4.2164680957794)
2014-01-16 14:14 Deleting thumb 1111544 (140508.94339895, 4.2593460083008)
2014-01-16 14:14 Deleted 46530 (140508.96600699, 0.022608041763306)
2014-01-16 14:14 Deleting thumb 1111544 (381.6983499527, 4.5658528804779)
2014-01-16 14:14 Deleting thumb 3194657 (140513.68346, 4.7174530029297)
2014-01-16 14:14 Deleting thumb 3194657 (386.50036001205, 4.8020100593567)
2014-01-16 14:14 Deleting thumb 3194675 (140518.49471092, 4.8112509250641)
2014-01-16 14:14 Deleting thumb 3194675 (391.23057484627, 4.7302148342133)
2014-01-16 14:14 Deleted 100 (391.26388001442, 0.033305168151855)
2014-01-16 14:14 Deleting thumb 1111545 (140523.22640491, 4.731693983078)
2014-01-16 14:14 Deleting thumb 1111545 (396.27513003349, 5.0112500190735)
2014-01-16 14:14 Deleting thumb 1712256 (140528.35960484, 5.133199930191)
2014-01-16 14:14 Deleting thumb 1712256 (401.1482489109, 4.8731188774109)
2014-01-16 14:14 Deleting thumb 1712257 (140533.36499286, 5.0053880214691)
2014-01-16 14:14 Deleting thumb 1712257 (405.42709708214, 4.2788481712341)
2014-01-16 14:14 Deleting thumb 1712258 (140537.76825404, 4.4032611846924)
2014-01-16 14:15 Deleting thumb 1712258 (410.1253259182, 4.6982288360596)
2014-01-16 14:15 Deleting thumb 1712259 (140542.50377202, 4.7355179786682)
2014-01-16 14:15 Deleting thumb 1712259 (414.64749598503, 4.5221700668335)
2014-01-16 14:15 Deleting thumb 1712260 (140547.52178502, 5.0180130004883)
2014-01-16 14:15 Deleting thumb 1712260 (419.5746588707, 4.9271628856659)
2014-01-16 14:15 Deleting thumb 1712261 (140552.56013489, 5.0383498668671)
2014-01-16 14:15 Deleting thumb 1712261 (424.40401792526, 4.8293590545654)
2014-01-16 14:15 Deleting thumb 1712262 (140556.481987, 3.9218521118164)
2014-01-16 14:15 Deleted 46540 (140556.50090194, 0.018914937973022)
2014-01-16 14:15 Deleting thumb 1712262 (428.05755591393, 3.6535379886627)
2014-01-16 14:15 Deleting thumb 3194676 (140560.17042994, 3.6695280075073)
2014-01-16 14:15 Deleting thumb 3194676 (431.51528096199, 3.4577250480652)
2014-01-16 14:15 Deleting thumb 3194694 (140563.53376102, 3.363331079483)
2014-01-16 14:15 Deleting thumb 3194694 (434.44525003433, 2.9299690723419)
2014-01-16 14:15 Deleted 110 (434.45312404633, 0.0078740119934082)
2014-01-16 14:15 Deleting thumb 1712263 (140566.71005392, 3.1762928962708)
2014-01-16 14:15 Deleting thumb 1712263 (437.71820902824, 3.2650849819183)
2014-01-16 14:15 Deleting thumb 1712264 (140570.67697096, 3.9669170379639)
2014-01-16 14:15 Deleting thumb 1712264 (440.83071398735, 3.1125049591064)
2014-01-16 14:15 Deleting thumb 1712265 (140573.78958201, 3.1126110553741)
2014-01-16 14:15 Deleting thumb 1712265 (443.71296095848, 2.8822469711304)
2014-01-16 14:15 Deleting thumb 2052829 (446.6074860096, 2.8945250511169)
2014-01-16 14:15 Deleting thumb 2052829 (140576.99317384, 3.2035918235779)
2014-01-16 14:15 Deleting thumb 2052830 (449.42796802521, 2.8204820156097)
2014-01-16 14:15 Deleting thumb 2052830 (140580.09027004, 3.0970962047577)
2014-01-16 14:15 Deleting thumb 2052831 (452.31800699234, 2.8900389671326)
2014-01-16 14:15 Deleting thumb 2052831 (140583.01579094, 2.9255208969116)
2014-01-16 14:15 Deleting thumb 2052832 (455.15337085724, 2.8353638648987)
2014-01-16 14:15 Deleting thumb 2052832 (140585.96279788, 2.9470069408417)
2014-01-16 14:15 Deleting thumb 2052833 (458.34663391113, 3.193263053894)
2014-01-16 14:15 Deleting thumb 2052833 (140589.15846395, 3.1956660747528)
2014-01-16 14:15 Deleted 46550 (140589.16721702, 0.0087530612945557)
2014-01-16 14:15 Deleting thumb 3194695 (461.6314060688, 3.2847721576691)
2014-01-16 14:15 Deleting thumb 3194695 (140592.49847484, 3.3312578201294)
2014-01-16 14:15 Deleting thumb 3194736 (464.89319801331, 3.2617919445038)
2014-01-16 14:15 Deleted 120 (464.91632294655, 0.023124933242798)
2014-01-16 14:15 Deleting thumb 3194736 (140595.58267999, 3.0842051506042)
2014-01-16 14:15 Deleting thumb 2052834 (467.84267497063, 2.9263520240784)
2014-01-16 14:15 Deleting thumb 2052834 (140598.73655486, 3.153874874115)
2014-01-16 14:16 Deleting thumb 2052835 (471.40561485291, 3.5629398822784)
2014-01-16 14:16 Deleting thumb 2052835 (140602.16474104, 3.4281861782074)
2014-01-16 14:16 Deleting thumb 2052836 (474.77719402313, 3.3715791702271)
2014-01-16 14:16 Deleting thumb 2052836 (140605.85797691, 3.693235874176)
2014-01-16 14:16 Deleting thumb 2052837 (478.89137101173, 4.1141769886017)
2014-01-16 14:16 Deleting thumb 2052837 (140610.17050695, 4.312530040741)
2014-01-16 14:16 Deleting thumb 2052838 (483.45004487038, 4.5586738586426)
2014-01-16 14:16 Deleting thumb 2052838 (140614.76670599, 4.5961990356445)
2014-01-16 14:16 Deleting thumb 2158734 (488.2977399826, 4.8476951122284)
2014-01-16 14:16 Deleting thumb 2158734 (140619.83473396, 5.068027973175)
2014-01-16 14:16 Deleting thumb 2158736 (493.08473205566, 4.7869920730591)
2014-01-16 14:16 Deleting thumb 2158736 (140624.31008792, 4.4753539562225)
2014-01-16 14:16 Deleting thumb 2158737 (496.7750480175, 3.6903159618378)
2014-01-16 14:16 Deleting thumb 2158737 (140628.31963801, 4.0095500946045)
2014-01-16 14:16 Deleted 46560 (140628.3292079, 0.0095698833465576)
2014-01-16 14:16 Deleting thumb 3194737 (501.29677987099, 4.5217318534851)
2014-01-16 14:16 Deleting thumb 3194737 (140632.89631891, 4.5671110153198)
2014-01-16 14:16 Deleting thumb 3194756 (505.65191793442, 4.3551380634308)
2014-01-16 14:16 Deleted 130 (505.67915797234, 0.027240037918091)
2014-01-16 14:16 Deleting thumb 3194756 (140636.98451495, 4.0881960391998)
2014-01-16 14:16 Deleting thumb 2158738 (509.48374986649, 3.8045918941498)
2014-01-16 14:16 Deleting thumb 2158738 (140640.59070587, 3.6061909198761)
2014-01-16 14:16 Deleting thumb 2158739 (513.22252988815, 3.7387800216675)
2014-01-16 14:16 Deleting thumb 2158739 (140644.19913888, 3.608433008194)
2014-01-16 14:16 Deleting thumb 2158740 (516.75435900688, 3.5318291187286)
2014-01-16 14:16 Deleting thumb 2158740 (140647.79506397, 3.5959250926971)
2014-01-16 14:16 Deleting thumb 2158741 (520.14140605927, 3.3870470523834)
2014-01-16 14:16 Deleting thumb 2158741 (140651.12985682, 3.3347928524017)
2014-01-16 14:16 Deleting thumb 2158742 (523.965695858, 3.8242897987366)
2014-01-16 14:16 Deleting thumb 2158742 (140655.01970506, 3.8898482322693)
2014-01-16 14:16 Deleting thumb 2158743 (527.94291400909, 3.9772181510925)
2014-01-16 14:16 Deleting thumb 2158743 (140658.83350492, 3.8137998580933)
2014-01-16 14:17 Deleting thumb 2158744 (532.05815887451, 4.1152448654175)
2014-01-16 14:17 Deleting thumb 2158744 (140662.96834588, 4.134840965271)
2014-01-16 14:17 Deleting thumb 2187406 (535.65479493141, 3.5966360569)
2014-01-16 14:17 Deleting thumb 2187406 (140666.51334786, 3.5450019836426)
2014-01-16 14:17 Deleted 46570 (140666.52309704, 0.009749174118042)
2014-01-16 14:17 Deleting thumb 3194757 (539.26194691658, 3.6071519851685)
2014-01-16 14:17 Deleting thumb 3194757 (140670.24766088, 3.7245638370514)
2014-01-16 14:17 Deleting thumb 3194758 (543.35177087784, 4.0898239612579)
2014-01-16 14:17 Deleted 140 (543.37094306946, 0.019172191619873)
2014-01-16 14:17 Deleting thumb 3194758 (140674.38977599, 4.1421151161194)
2014-01-16 14:17 Deleting thumb 2187407 (547.73489403725, 4.3639509677887)
2014-01-16 14:17 Deleting thumb 2187407 (140678.58321905, 4.1934430599213)
2014-01-16 14:17 Deleting thumb 2187408 (553.21088695526, 5.4759929180145)
2014-01-16 14:17 Deleting thumb 2187408 (140683.54260588, 4.9593868255615)
2014-01-16 14:17 Deleting thumb 2187409 (140688.37886286, 4.836256980896)
2014-01-16 14:17 Deleting thumb 2187409 (558.28721904755, 5.0763320922852)
2014-01-16 14:17 Deleting thumb 2187410 (140692.81558299, 4.4367201328278)
2014-01-16 14:17 Deleting thumb 2187410 (562.8034889698, 4.5162699222565)
2014-01-16 14:17 Deleting thumb 2187411 (140697.11585593, 4.3002729415894)
2014-01-16 14:17 Deleting thumb 2187411 (567.22820496559, 4.4247159957886)
2014-01-16 14:17 Deleting thumb 2187412 (140701.22649097, 4.1106350421906)
2014-01-16 14:17 Deleting thumb 2187412 (571.23230099678, 4.004096031189)
2014-01-16 14:17 Deleting thumb 2187413 (140705.28653693, 4.0600459575653)
2014-01-16 14:17 Deleting thumb 2187413 (575.39867401123, 4.1663730144501)
2014-01-16 14:17 Deleting thumb 2187414 (140709.86479783, 4.5782608985901)
2014-01-16 14:17 Deleted 46580 (140709.90932393, 0.044526100158691)
2014-01-16 14:17 Deleting thumb 2187414 (579.93084001541, 4.5321660041809)
2014-01-16 14:17 Deleting thumb 3194775 (140714.35544801, 4.4461240768433)
2014-01-16 14:17 Deleting thumb 3194775 (584.54805493355, 4.6172149181366)
2014-01-16 14:17 Deleting thumb 3194831 (140718.76154399, 4.4060959815979)
2014-01-16 14:17 Deleting thumb 3194831 (588.75242304802, 4.2043681144714)
2014-01-16 14:17 Deleted 150 (588.77064704895, 0.018224000930786)
2014-01-16 14:18 Deleting thumb 2187415 (140723.37452197, 4.6129779815674)
2014-01-16 14:18 Deleting thumb 2187415 (593.39382100105, 4.6231739521027)
2014-01-16 14:18 Deleting thumb 2529890 (140728.727072, 5.3525500297546)
2014-01-16 14:18 Deleting thumb 2529890 (598.72847485542, 5.3346538543701)
2014-01-16 14:18 Deleting thumb 2529891 (140734.45039392, 5.7233219146729)
2014-01-16 14:18 Deleting thumb 2529891 (604.53154087067, 5.8030660152435)
2014-01-16 14:18 Deleting thumb 2529892 (140739.6432209, 5.1928269863129)
2014-01-16 14:18 Deleting thumb 2529892 (609.80917692184, 5.277636051178)
2014-01-16 14:18 Deleting thumb 2529893 (140744.99168897, 5.3484680652618)
2014-01-16 14:18 Deleting thumb 2529893 (615.19715499878, 5.3879780769348)
2014-01-16 14:18 Deleting thumb 2529894 (140749.44398093, 4.4522919654846)
2014-01-16 14:18 Deleting thumb 2529894 (619.40306305885, 4.2059080600739)
2014-01-16 14:18 Deleting thumb 2529895 (140753.52781606, 4.0838351249695)
2014-01-16 14:18 Deleting thumb 2529895 (623.72820591927, 4.3251428604126)
2014-01-16 14:18 Deleting thumb 2529896 (140757.73628092, 4.2084648609161)
2014-01-16 14:18 Deleted 46590 (140757.79168105, 0.055400133132935)
2014-01-16 14:18 Deleting thumb 2529896 (627.81073498726, 4.0825290679932)
2014-01-16 14:18 Deleting thumb 3194832 (631.6309800148, 3.8202450275421)
2014-01-16 14:18 Deleting thumb 3194832 (140761.85263991, 4.0609588623047)
2014-01-16 14:18 Deleting thumb 3194852 (635.35055589676, 3.719575881958)
2014-01-16 14:18 Deleted 160 (635.37743592262, 0.026880025863647)
2014-01-16 14:18 Deleting thumb 3194852 (140765.77466893, 3.9220290184021)
2014-01-16 14:18 Deleting thumb 2529897 (638.77456903458, 3.3971331119537)
2014-01-16 14:18 Deleting thumb 2529897 (140769.15949798, 3.384829044342)
2014-01-16 14:18 Deleting thumb 2529898 (642.40462303162, 3.6300539970398)
2014-01-16 14:18 Deleting thumb 2529898 (140772.70690298, 3.5474050045013)
2014-01-16 14:18 Deleting thumb 2529899 (646.17020893097, 3.765585899353)
2014-01-16 14:18 Deleting thumb 2529899 (140776.49845004, 3.7915470600128)
2014-01-16 14:19 Deleting thumb 2572084 (650.01424694061, 3.8440380096436)
2014-01-16 14:19 Deleting thumb 2572084 (140780.41536283, 3.9169127941132)
2014-01-16 14:19 Deleting thumb 2572085 (654.28517198563, 4.2709250450134)
2014-01-16 14:19 Deleting thumb 2572085 (140785.01973987, 4.6043770313263)
2014-01-16 14:19 Deleting thumb 2572086 (659.21582889557, 4.9306569099426)
2014-01-16 14:19 Deleting thumb 2572086 (140790.15302205, 5.1332821846008)
2014-01-16 14:19 Deleting thumb 2572087 (664.15921401978, 4.9433851242065)
2014-01-16 14:19 Deleting thumb 2572087 (140794.78230906, 4.6292870044708)
2014-01-16 14:19 Deleting thumb 2572088 (668.80639791489, 4.6471838951111)
2014-01-16 14:19 Deleting thumb 2572088 (140799.55556393, 4.7732548713684)
2014-01-16 14:19 Deleted 46600 (140799.57020402, 0.014640092849731)
2014-01-16 14:19 Deleting thumb 3194873 (673.1400680542, 4.3336701393127)
2014-01-16 14:19 Deleting thumb 3194873 (140803.95538306, 4.3851790428162)
2014-01-16 14:19 Deleting thumb 3194891 (677.0585539341, 3.9184858798981)
2014-01-16 14:19 Deleted 170 (677.08407688141, 0.025522947311401)
2014-01-16 14:19 Deleting thumb 3194891 (140807.65681887, 3.7014358043671)
2014-01-16 14:19 Deleting thumb 2572089 (680.69114589691, 3.6070690155029)
2014-01-16 14:19 Deleting thumb 2572089 (140811.24510002, 3.5882811546326)
2014-01-16 14:19 Deleting thumb 2572090 (684.45739102364, 3.7662451267242)
2014-01-16 14:19 Deleting thumb 2572090 (140815.05599999, 3.8108999729156)
2014-01-16 14:19 Deleting thumb 2572091 (688.26109099388, 3.8036999702454)
2014-01-16 14:19 Deleting thumb 2572091 (140819.21307588, 4.157075881958)
2014-01-16 14:19 Deleting thumb 2598929 (692.37260985374, 4.1115188598633)
2014-01-16 14:19 Deleting thumb 2598929 (140823.02101803, 3.8079421520233)
2014-01-16 14:19 Deleting thumb 2598930 (695.72082901001, 3.3482191562653)
2014-01-16 14:19 Deleting thumb 2598930 (140826.41746783, 3.396449804306)
2014-01-16 14:19 Deleting thumb 2598931 (699.05620002747, 3.3353710174561)
2014-01-16 14:19 Deleting thumb 2598931 (140829.75093484, 3.3334670066833)
2014-01-16 14:19 Deleting thumb 2598932 (702.67609000206, 3.6198899745941)
2014-01-16 14:19 Deleting thumb 2598932 (140833.55544305, 3.8045082092285)
2014-01-16 14:19 Deleting thumb 2598933 (706.29786896706, 3.6217789649963)
2014-01-16 14:19 Deleting thumb 2598933 (140836.79024005, 3.234797000885)
2014-01-16 14:19 Deleted 46610 (140836.79893684, 0.0086967945098877)
2014-01-16 14:19 Deleting thumb 3194892 (709.30349707603, 3.0056281089783)
2014-01-16 14:20 Deleting thumb 3194892 (140839.67408204, 2.8751451969147)
2014-01-16 14:20 Deleting thumb 3194893 (712.43877601624, 3.1352789402008)
2014-01-16 14:20 Deleted 180 (712.45530605316, 0.01653003692627)
2014-01-16 14:20 Deleting thumb 3194893 (140843.03893495, 3.3648529052734)
2014-01-16 14:20 Deleting thumb 2598934 (715.31107091904, 2.8557648658752)
2014-01-16 14:20 Deleting thumb 2598934 (140846.11975098, 3.0808160305023)
2014-01-16 14:20 Deleting thumb 2598935 (718.41390895844, 3.1028380393982)
2014-01-16 14:20 Deleting thumb 2598935 (140849.21763301, 3.0978820323944)
2014-01-16 14:20 Deleting thumb 2598936 (721.67204904556, 3.2581400871277)
2014-01-16 14:20 Deleting thumb 2598936 (140852.12726998, 2.9096369743347)
2014-01-16 14:20 Deleting thumb 2598937 (724.63757586479, 2.9655268192291)
2014-01-16 14:20 Deleting thumb 2598937 (140855.21444201, 3.0871720314026)
2014-01-16 14:20 Deleting thumb 2598938 (727.6179459095, 2.9803700447083)
2014-01-16 14:20 Deleting thumb 2598938 (140858.37815189, 3.1637098789215)
2014-01-16 14:20 Deleting thumb 2607544 (730.98329091072, 3.3653450012207)
2014-01-16 14:20 Deleting thumb 2607544 (140861.22717404, 2.8490221500397)
2014-01-16 14:20 Deleting thumb 2607545 (140864.06999183, 2.8428177833557)
2014-01-16 14:20 Deleting thumb 2607545 (734.00008702278, 3.0167961120605)
2014-01-16 14:20 Deleting thumb 2607546 (140867.6876719, 3.6176800727844)
2014-01-16 14:20 Deleted 46620 (140867.70570397, 0.018032073974609)
2014-01-16 14:20 Deleting thumb 2607546 (737.53764200211, 3.5375549793243)
2014-01-16 14:20 Deleting thumb 3196283 (740.37663888931, 2.838996887207)
2014-01-16 14:20 Deleting thumb 3196283 (140870.66056895, 2.9548649787903)
2014-01-16 14:20 Deleting thumb 3196313 (743.18071007729, 2.804071187973)
2014-01-16 14:20 Deleted 190 (743.1952688694, 0.014558792114258)
2014-01-16 14:20 Deleting thumb 3196313 (140873.44463801, 2.7840690612793)
2014-01-16 14:20 Deleting thumb 2607547 (746.00420689583, 2.8089380264282)
2014-01-16 14:20 Deleting thumb 2607547 (140876.25013399, 2.8054959774017)
2014-01-16 14:20 Deleting thumb 2607548 (748.86731886864, 2.8631119728088)
2014-01-16 14:20 Deleting thumb 2607548 (140879.10525203, 2.8551180362701)
2014-01-16 14:20 Deleting thumb 2607549 (751.82215189934, 2.9548330307007)
2014-01-16 14:20 Deleting thumb 2607549 (140882.09395504, 2.9887030124664)
2014-01-16 14:20 Deleting thumb 2607550 (140884.66439986, 2.5704448223114)
2014-01-16 14:20 Deleting thumb 2607550 (754.480645895, 2.6584939956665)
2014-01-16 14:20 Deleting thumb 2607551 (140887.315207, 2.6508071422577)
2014-01-16 14:20 Deleting thumb 2607551 (757.1622300148, 2.6815841197968)
2014-01-16 14:20 Deleting thumb 2607552 (760.9764559269, 3.8142259120941)
2014-01-16 14:20 Deleting thumb 2607552 (140891.44359589, 4.1283888816833)
2014-01-16 14:20 Deleting thumb 2607553 (764.88905787468, 3.9126019477844)
2014-01-16 14:20 Deleting thumb 2607553 (140895.24988294, 3.8062870502472)
2014-01-16 14:20 Deleting thumb 2676856 (140898.32258987, 3.0727069377899)
2014-01-16 14:20 Deleted 46630 (140898.35318899, 0.030599117279053)
2014-01-16 14:20 Deleting thumb 2676856 (768.15314507484, 3.2640872001648)
2014-01-16 14:21 Deleting thumb 3196323 (140901.25208783, 2.8988988399506)
2014-01-16 14:21 Deleting thumb 3196323 (771.10087585449, 2.9477307796478)
2014-01-16 14:21 Deleting thumb 3196344 (773.84462785721, 2.7437520027161)
2014-01-16 14:21 Deleted 200 (773.85880208015, 0.014174222946167)
2014-01-16 14:21 Processing preload ... (773.86339688301, 0.0045948028564453)
2014-01-16 14:21 Preload Total: 0 (773.86559486389, 0.0021979808807373)
2014-01-16 14:21 Deleting thumb 3196344 (140904.11998487, 2.8678970336914)
2014-01-16 14:21 Deleting thumb 2676857 (140906.898844, 2.7788591384888)
2014-01-16 14:21 Deleting thumb 2676858 (140909.93570685, 3.0368628501892)
2014-01-16 14:21 Deleting thumb 2676859 (140912.71546602, 2.7797591686249)
2014-01-16 14:21 Deleting thumb 2676860 (140915.92717099, 3.2117049694061)
2014-01-16 14:21 Deleting thumb 2676861 (140918.79878688, 2.8716158866882)
2014-01-16 14:21 Deleting thumb 2676862 (140921.58295894, 2.7841720581055)
2014-01-16 14:21 Deleting thumb 2676863 (140924.24263597, 2.659677028656)
2014-01-16 14:21 Deleting thumb 2676864 (140926.89801002, 2.6553740501404)
2014-01-16 14:21 Deleted 46640 (140926.91150284, 0.013492822647095)
2014-01-16 14:21 Deleting thumb 3196370 (140929.26229095, 2.3507881164551)
2014-01-16 14:21 Deleting thumb 3196381 (140931.660532, 2.3982410430908)
2014-01-16 14:21 Deleting thumb 2676865 (140934.15910292, 2.4985709190369)
2014-01-16 14:21 Deleting thumb 2808362 (140936.63225985, 2.4731569290161)
2014-01-16 14:21 Deleting thumb 2808363 (140938.85840988, 2.2261500358582)
2014-01-16 14:21 Deleting thumb 2808364 (140940.91659093, 2.0581810474396)
2014-01-16 14:21 Deleting thumb 2808365 (140942.95662594, 2.0400350093842)
2014-01-16 14:21 Deleting thumb 2808366 (140945.05070901, 2.094083070755)
2014-01-16 14:21 Deleting thumb 2808367 (140947.12365484, 2.0729458332062)
2014-01-16 14:21 Deleting thumb 2808368 (140949.41144085, 2.2877860069275)
2014-01-16 14:21 Deleted 46650 (140949.42282796, 0.01138710975647)
2014-01-16 14:21 Deleting thumb 3196393 (140951.86090899, 2.4380810260773)
2014-01-16 14:21 Deleting thumb 3196409 (140954.40536499, 2.5444560050964)
2014-01-16 14:21 Deleting thumb 2808369 (140956.928828, 2.523463010788)
2014-01-16 14:21 Deleting thumb 2808370 (140959.40931392, 2.4804859161377)
2014-01-16 14:22 Deleting thumb 2808371 (140962.10716701, 2.6978530883789)
2014-01-16 14:22 Deleting thumb 3162648 (140964.6559, 2.5487329959869)
2014-01-16 14:22 Deleting thumb 3162649 (140967.33364606, 2.6777460575104)
2014-01-16 14:22 Rotation Started (0.061429977416992, 0.061429977416992)
2014-01-16 14:22 Process clicks (0.074159860610962, 0.01272988319397)
2014-01-16 14:22 Check shift point (0.076211929321289, 0.0020520687103271)
2014-01-16 14:22 Check if we have to create Rotation - Pages (0.077354907989502, 0.0011429786682129)
2014-01-16 14:22 Delete thumbs marked for deletion (0.083976984024048, 0.0066220760345459)
2014-01-16 14:22 Deleting thumb 3162650 (140970.30153584, 2.9678897857666)
2014-01-16 14:22 Deleting thumb 3162650 (2.8672959804535, 2.7833189964294)
2014-01-16 14:22 Deleted 0 (2.8788590431213, 0.011563062667847)
2014-01-16 14:22 Deleting thumb 3162651 (140973.26384401, 2.9623081684113)
2014-01-16 14:22 Deleting thumb 3162651 (5.5090048313141, 2.6301457881927)
2014-01-16 14:22 Deleting thumb 3162652 (140975.99691606, 2.7330720424652)
2014-01-16 14:22 Deleted 46660 (140976.01314402, 0.016227960586548)
2014-01-16 14:22 Deleting thumb 3162652 (8.1348338127136, 2.6258289813995)
2014-01-16 14:22 Deleting thumb 3196439 (140978.86152601, 2.8483819961548)
2014-01-16 14:22 Deleting thumb 3196439 (11.134012937546, 2.9991791248322)
2014-01-16 14:22 Deleting thumb 3196503 (140981.85170889, 2.9901828765869)
2014-01-16 14:22 Deleting thumb 3196503 (14.811812877655, 3.6777999401093)
2014-01-16 14:22 Deleting thumb 3162653 (140985.58612585, 3.7344169616699)
2014-01-16 14:22 Deleting thumb 3162653 (18.582708835602, 3.7708959579468)
2014-01-16 14:22 Deleting thumb 3162654 (140988.98484898, 3.3987231254578)
2014-01-16 14:22 Deleting thumb 3162654 (22.298977851868, 3.7162690162659)
2014-01-16 14:22 Deleting thumb 3162655 (140992.69179392, 3.7069449424744)
2014-01-16 14:22 Deleting thumb 3162655 (25.939246892929, 3.6402690410614)
2014-01-16 14:22 Deleting thumb 3162656 (140996.09905601, 3.4072620868683)
2014-01-16 14:22 Deleting thumb 3162656 (29.60860490799, 3.6693580150604)
2014-01-16 14:22 Deleting thumb 3162657 (140999.92756295, 3.8285069465637)
2014-01-16 14:22 Deleting thumb 3162657 (33.000831842422, 3.392226934433)
2014-01-16 14:22 Deleting thumb 1021657 (141003.77910399, 3.8515410423279)
2014-01-16 14:22 Deleting thumb 1021657 (37.275627851486, 4.2747960090637)
2014-01-16 14:22 Deleted 10 (37.286155939102, 0.010528087615967)
2014-01-16 14:22 Deleting thumb 1021658 (141010.16430902, 6.3852050304413)
2014-01-16 14:22 Deleting thumb 1021658 (41.46448802948, 4.1783320903778)
2014-01-16 14:22 Deleting thumb 1021659 (141013.49760795, 3.3332989215851)
2014-01-16 14:22 Deleted 46670 (141013.50975704, 0.012149095535278)

Тут явная ошибка в подсчетах.
Если для простоты и в соотв с логом взять 3 секунды на удаление то получается 28 000 в день, а никак не 3 000.

У нас не получается 28к удалить за сутки вот счас сутки прошли я засекал получается всего 2к удалило. Вчера в это же время смотрел. Есть все же вариант какой то сразу убить тумбы эти ? может подскажете в мускуле запрос чтобы удалить сразу

Как имено вы засекаете ?
Можете по логу посчитать за пару часов - там уже будет 2к.

По базе - смотрите rot_galleries - там отмечены на удаление статусом.
по gallery_md5 удаляйте соответствия из всех остальных таблиц.
варианты разные могут быть в зависимости от того как вы удаляете.
но я бы не занимался этим, тк останутся тумбы и тп.
лучше разобраться как вы считаете эти 2к удаленных если по логу и то больше.

Я периодично захожу http://gyazo.com/eab493f5d407b4ad0b7aa019c1384359

каждый час смотрю на 200 тумб всего становиться меньше

Да, 2 миллиона тумб всунуть это серьезно )

Может вы смотрите на кол-во галер, а не тумб.

Можете пробовать удалять из базы, мне не кажется это удачным вариантом, соатвлять сотни тысяч бесхозных тумб.

В любом случае сверьтесь с логом в первую очередь.

Время деньги. Стоимость 1 дня примерно 250 евро. Дорого получается. Есть ли инструмент который может сразу убрать это из базы чтобы ничего не осталось от удаленных тубм галлер и т.д. Как удалить сразу все мгновенно ?