Раздельная ротация по группам

[hrulik]

не удается включить данную фичу на слейве. При выполении каманды "php rot.php action=start_separate_thumb2group_stats" выпадает дясятикилометровая простыня

Code: Select all

() Mysql error:: 0 () (db_link) in query insert into rot_gallery_stats3 (thumb_id, group_id, best_thumb, current_index, current_shows, current_clicks, current_points, shows0, clicks0, points0, shows1, clicks1, points1, shows2, clicks2, points2, shows3, clicks3, points3, shows4, clicks4, points4, shows5, clicks5, points5, shows6, clicks6, points6, shows7, clicks7, points7, shows8, clicks8, points8, shows9, clicks9, points9, total_shows, total_clicks, total_points, total_ctr) values ('217943', '4', 'yes', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.000000'). () Mysql error:: 0 () (db_link) in query insert into rot_gallery_stats3 (thumb_id, group_id, best_thumb, current_index, current_shows, current_clicks, current_points, shows0, clicks0, points0, shows1, clicks1, points1, shows2, clicks2, points2, shows3, clicks3, points3, shows4, clicks4, points4, shows5, clicks5, points5, shows6, clicks6, points6, shows7, clicks7, points7, shows8, clicks8, points8, shows9, clicks9, points9, total_shows, total_clicks, total_points, total_ctr) values ('217953', '4', 'yes', '0', '6', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '6', '0', '0', '0.000000'). () Mysql error:: 0 () (db_link) in query insert into rot_gallery_stats3 (thumb_id, group_id, best_thumb, current_index, current_shows, current_clicks, current_points, shows0, clicks0, points0, shows1, clicks1, points1, shows2, clicks2, points2, shows3, clicks3, points3, shows4, clicks4, points4, shows5, clicks5, points5, shows6, clicks6, points6, shows7, clicks7, points7, shows8, clicks8, points8, shows9, clicks9, points9, total_shows, total_clicks, total_points, total_ctr) values ('217967', '4', 'yes', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.000000'). () Mysql error:: 0 () (db_link) in query insert into rot_gallery_stats3 (thumb_id, group_id, best_thumb, current_index, current_shows, current_clicks, current_points, shows0, clicks0, points0, shows1, clicks1, points1, shows2, clicks2, points2, shows3, clicks3, points3, shows4, clicks4, points4, shows5, clicks5, points5, shows6, clicks6, points6, shows7, clicks7, points7, shows8, clicks8, points8, shows9, clicks9, points9, total_shows, total_clicks, total_points, total_ctr) values ('217968', '4', 'no', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.000000'). () Mysql error:: 0 () (db_link) in query insert into rot_gallery_stats3 (thumb_id, group_id, best_thumb, current_index, current_shows, current_clicks, current_points, shows0, clicks0, points0, shows1, clicks1, points1, shows2, clicks2, points2, shows3, clicks3, points3, shows4, clicks4, points4, shows5, clicks5, points5, shows6, clicks6, points6, shows7, clicks7, points7, shows8, clicks8, points8, shows9, clicks9, points9, total_shows, total_clicks, total_points, total_ctr) values ('217969', '4', 'no', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.000000'). () Mysql error:: 0 () (db_link) in query insert into rot_gallery_stats3 (thumb_id, group_id, best_thumb, current_index, current_shows, current_clicks, current_points, shows0, clicks0, points0, shows1, clicks1, points1, shows2, clicks2, points2, shows3, clicks3, points3, shows4, clicks4, points4, shows5, clicks5, points5, shows6, clicks6, points6, shows7, clicks7, points7, shows8, clicks8, points8, shows9, clicks9, points9, total_shows, total_clicks, total_points, total_ctr) values ('217970', '4', 'no', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.000000'). () Mysql error:: 0 () (db_link) in query insert into rot_gallery_stats3 (thumb_id, group_id, best_thumb, current_index, current_shows, current_clicks, current_points, shows0, clicks0, points0, shows1, clicks1, points1, shows2, clicks2, points2, shows3, clicks3, points3, shows4, clicks4, points4, shows5, clicks5, points5, shows6, clicks6, points6, shows7, clicks7, points7, shows8, clicks8, points8, shows9, clicks9, points9, total_shows, total_clicks, total_points, total_ctr) values ('217971', '4', 'no', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.000000'). () Mysql error:: 0 () (db_link) in query insert into rot_gallery_stats3 (thumb_id, group_id, best_thumb, current_index, current_shows, current_clicks, current_points, shows0, clicks0, points0, shows1, clicks1, points1, shows2, clicks2, points2, shows3, clicks3, points3, shows4, clicks4, points4, shows5, clicks5, points5, shows6, clicks6, points6, shows7, clicks7, points7, shows8, clicks8, points8, shows9, clicks9, points9, total_shows, total_clicks, total_points, total_ctr) values ('217972', '4', 'no', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.000000'). () Mysql error:: 0 () (db_link) in query insert into rot_gallery_stats3 (thumb_id, group_id, best_thumb, current_index, current_shows, current_clicks, current_points, shows0, clicks0, points0, shows1, clicks1, points1, shows2, clicks2, points2, shows3, clicks3, points3, shows4, clicks4, points4, shows5, clicks5, points5, shows6, clicks6, points6, shows7, clicks7, points7, shows8, clicks8, points8, shows9, clicks9, points9, total_shows, total_clicks, total_points, total_ctr) values ('217973', '4', 'no', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.000000'). () Mysql error:: 0 () (db_link) in query insert into rot_gallery_stats3 (thumb_id, group_id, best_thumb, current_index, current_shows, current_clicks, current_points, shows0, clicks0, points0, shows1, clicks1, points1, shows2, clicks2, points2, shows3, clicks3, points3, shows4, clicks4, points4, shows5, clicks5, points5, shows6, clicks6, points6, shows7, clicks7, points7, shows8, clicks8, points8, shows9, clicks9, points9, total_shows, total_clicks, total_points, total_ctr) values ('217974', '4', 'no', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.000000'). () Mysql error:: 0 () (db_link) in query insert into rot_gallery_stats3 (thumb_id, group_id, best_thumb, current_index, current_shows, current_clicks, current_points, shows0, clicks0, points0, shows1, clicks1, points1, shows2, clicks2, points2, shows3, clicks3, points3, shows4, clicks4, points4, shows5, clicks5, points5, shows6, clicks6, points6, shows7, clicks7, points7, shows8, clicks8, points8, shows9, clicks9, points9, total_shows, total_clicks, total_points, total_ctr) values ('217975', '4', 'no', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.000000'). () Mysql error:: 0 () (db_link) in query insert into rot_gallery_stats3 (thumb_id, group_id, best_thumb, current_index, current_shows, current_clicks, current_points, shows0, clicks0, points0, shows1, clicks1, points1, shows2, clicks2, points2, shows3, clicks3, points3, shows4, clicks4, points4, shows5, clicks5, points5, shows6, clicks6, points6, shows7, clicks7, points7, shows8, clicks8, points8, shows9, clicks9, points9, total_shows, total_clicks, total_points, total_ctr) values ('217976', '4', 'no', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.000000'). () Mysql error:: 0 () (db_link) in query insert into rot_gallery_stats3 (thumb_id, group_id, best_thumb, current_index, current_shows, current_clicks, current_points, shows0, clicks0, points0, shows1, clicks1, points1, shows2, clicks2, points2, shows3, clicks3, points3, shows4, clicks4, points4, shows5, clicks5, points5, shows6, clicks6, points6, shows7, clicks7, points7, shows8, clicks8, points8, shows9, clicks9, points9, total_shows, total_clicks, total_points, total_ctr) values ('217977', '4', 'no', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.000000'). 

если в админке переключить, то вся статистика по тумбам нули

[admin]

Поправлено в апдейте.

[hrulik]

Простыни теперь нет. команда "php rot.php action=start_separate_thumb2group_stats" выполняется подозрительно быстро.
если выставляю в админке "Separate stats for each thumb in each category" в yes
то вся статистика по тумбам обнулена, всё тумбы становятся новыми.

[admin]

Да, на мастере раньше оно делало и для слейва разделение.

ЦТР 0 - да, по группам то они не набрали ничего.

[hrulik]

т.е. это сейчас вся база должна по новой отротироватся штоли?
а нельзя разве при инициализации раздельной статсы скопировать из общей в статсы группы, чтобы не переротировать по новой всю базу?

[admin]

В принципе можно, но тога будет вопрос с ротацией тк например CTR Recalculation period стоит 50к, тумба набрала 50к, потом расоединили, например у нас 400 групп, 50к показов тумба в группе в среднем получается наберет за 20 М посещений - и это только тумбы на первой старнице категории.

[hrulik]

Мне кажется всё равно лучше от какого то отротированного установившегося значения отталкиватся. А дельта как раз со временем плавно и нарастет. Чем просто взять и сбросить всю статсу

[coooler]

+1
кроме того мне кажется будет более правильным организовать раздельную ротацию следующим образом: пока тумба в статусе новой, она крутится только в главной категории и получает там первоначальный цтр. когда статус новой заканчивается, она начинает крутиться в остальных категориях с уже набранным цтром, который уже коректируется в зависимости от категории. если это конечно реально реализовать

[admin]

те показывается только в в главной ? этак тумбы не наберут вообще цтр потому что большинство из них будут показываться только в категории все же.

[coooler]

под главной я имею в виду Main Group