проблема с mysql
Posted: Sat Dec 14, 2013 1:40 pm
mysql перегружается однотипными запросами к бд вида:
Результат везде 502 Bad Gateway.
В админке есть предупреждения:
Что с этим делать? Желательно подробную пошаговую инструкцию. БД трогать побаиваюсь.
Code: Select all
| 8824 | cj_sext | localhost | cj_sext | Query | 1779 | Locked | SELECT id, gallery_slug, g.gallery_md5, sponsor_id, url, source_url, rot_content_id, embed_template, thumb_url, embed_code,
flv_url, flv_size_x, flv_size_y, flv_thumb_url, tags, type, rgroup, content, content_type,
duration, date, activation_date, casts, clicks, rating, priority, crop_profile_id, status,
alt, description, custom_var1, custom_var2, custom_var3
FROM rot_galleries as g
JOIN rot_gallery_info as gi ON gi.gallery_md5 = g.gallery_md5
JOIN rot_gallery_data as gd ON gd.gallery_md5 = g.gallery_md5
WHERE id IN (144604,243004,16648,246669,167845,246635,112102,130108,135920,205635,170005,246398) |В админке есть предупреждения:
Code: Select all
You do not use any modern cache engine - This is not an error. Everything will work, but default cache engine is filecache and it's a bit slow compared to Couchbase or Redis. It's a good idea to use them to improve your server's performance.
Mysql Table Engine: looks like mysql DB tables (rot_galleries,rot_gallery_stats) are not of InnoD format. it's good idea to tune mysql and use innodb table format for rot_* tables. Please, read wiki for mysql tuning hints.