SmartCJ Support Forum

pvp777 wrote: Wed Feb 17, 2021 8:15 am По таблицам, самые нагруженные out_ips и ips их можно в InnoDB сконвертить?

pvp777 wrote: Wed Feb 17, 2021 8:08 am еще по базе запрос такой в конце куча 'S','S они сюда не влезут даже
разве в файл прикрепить полный
запрос выполняется от 1-2 до 10 секунд по разному

это при таких настройках слоулога
slow-query-log = 1
long_query_time = 1
log-queries-not-using-indexes = 1

Reading mysql slow query log from /var/log/mysql-slow.log
Count: 1 Time=10.88s (10s) Lock=0.02s (0s) Rows=0.0 (0), smart47[smart47]@localhost
UPDATE IGNORE rot_gallery_stats41 SET
total_shows = current_shows + shows0 + shows1 + shows2 + shows3 + shows4,
total_clicks = current_clicks + clicks0 + clicks1 + clicks2 + clicks3 + clicks4,
total_points = current_points + points0 + points1 + points2 + points3 + points4,
total_ctr = if ( (current_shows + shows0 + shows1 + shows2 + shows3 + shows4 ) > N, (current_points*N + points0 + points1 + points2 + points3 + points4)/(current_shows + shows0 + shows1 + shows2 + shows3 + shows4 )/N, N )
WHERE thumb_id IN ('S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S