Протестировав сайт понял что он также и долго открывается
Сайт: slavyanskaya-kultura.ru
Хост: Питерхост
Версия двига: 1.6.2
Трафик: 1500 в сутки
Причем что самое «плохое» трафик неуклонно растет, что конечно приведет к еще большим тормозам и еще большему неудовольствию хостера, который по тихонько уже начинает закидывать мою почту недовольными предупреждениями.
Наконец задался вопросом перехода на версию 1.8 но при этом хочется в начале узнать насколько более быстрее и оптимизированей новый релиз? Будет ли сайт работать быстрей?
Также хочу привести частичный фаил ошибок базы, в принципе из-за которой основные и тормоза
# User@Host: dbu_15[dbu_15] @ [192.168.5.74]
# Query_time: 2 Lock_time: 0 Rows_sent: 1 Rows_examined: 942108
SELECT id FROM cms_stats WHERE (ip = '178.154.162.29' AND page = '/blogs/staroslavjanskie-kapisha-kak-oni-vygljadeli-i-chto-na-nih-nahodilos');
# Time: 110528 23:47:09
# User@Host: dbu_15[dbu_15] @ [192.168.5.74]
# Query_time: 4 Lock_time: 0 Rows_sent: 5 Rows_examined: 802673
SELECT con.*,
con.pubdate as fdate,
u.nickname as author,
u.login as author_login,
IFNULL(COUNT(cm.id), 0) as comments
FROM cms_category cat, cms_users u, cms_content con
LEFT JOIN cms_comments cm ON cm.target='article' AND cm.target_id=con.id
WHERE con.published = 1 AND con.showlatest = 1 AND con.user_id = u.id
AND (con.is_end=0 OR (con.is_end=1 AND con.enddate >= '2011-05-28 23:47:05' AND con.pubdate <= '2011-05-28 23:47:05'))
AND con.category_id = cat.id
GROUP BY con.id
ORDER BY con.pubdate DESC
LIMIT 45, 5;
# Time: 110528 23:47:22
# User@Host: dbu_15[dbu_15] @ [192.168.5.74]
# Query_time: 5 Lock_time: 0 Rows_sent: 5 Rows_examined: 802703
SELECT con.*,
con.pubdate as fdate,
u.nickname as author,
u.login as author_login,
IFNULL(COUNT(cm.id), 0) as comments
FROM cms_category cat, cms_users u, cms_content con
LEFT JOIN cms_comments cm ON cm.target='article' AND cm.target_id=con.id
WHERE con.published = 1 AND con.showlatest = 1 AND con.user_id = u.id
AND (con.is_end=0 OR (con.is_end=1 AND con.enddate >= '2011-05-28 23:47:17' AND con.pubdate <= '2011-05-28 23:47:17'))
AND con.category_id = cat.id
GROUP BY con.id
ORDER BY con.pubdate DESC
LIMIT 75, 5;
# Time: 110528 23:47:32
# User@Host: dbu_15[dbu_15] @ [192.168.5.74]
# Query_time: 5 Lock_time: 0 Rows_sent: 5 Rows_examined: 802708
SELECT con.*,
con.pubdate as fdate,
u.nickname as author,
u.login as author_login,
IFNULL(COUNT(cm.id), 0) as comments
FROM cms_category cat, cms_users u, cms_content con
LEFT JOIN cms_comments cm ON cm.target='article' AND cm.target_id=con.id
WHERE con.published = 1 AND con.showlatest = 1 AND con.user_id = u.id
AND (con.is_end=0 OR (con.is_end=1 AND con.enddate >= '2011-05-28 23:47:27' AND con.pubdate <= '2011-05-28 23:47:27'))
AND con.category_id = cat.id
GROUP BY con.id
ORDER BY con.pubdate DESC
LIMIT 80, 5;
# Time: 110528 23:48:05
# User@Host: dbu_15[dbu_15] @ [192.168.5.74]
# Query_time: 2 Lock_time: 0 Rows_sent: 100 Rows_examined: 2150
SELECT c.id as id,
c.target as target,
c.target_id as target_id,
c.target_link as target_link,
c.content as content,
c.guestname,
c.pubdate as fpubdate,
IFNULL(c.user_id, 0) as user_id,
IFNULL(u.nickname, '') as author,
IFNULL(u.login, '') as author_login,
IFNULL(v.total_rating, 0) as rating
FROM cms_users u, cms_comments c
LEFT JOIN cms_ratings_total v ON v.item_id=c.id AND v.target='comment'
WHERE (c.user_id=u.id OR c.guestname<>'') AND c.published=1 AND (c.target="article" OR c.target="blog" OR c.target="palbum" OR c.target="photo" OR c.target="userphoto" OR c.target="catalog" OR c.target="boarditem" OR c.target="faq" OR c.target="shopitem")
GROUP BY c.id
ORDER BY c.pubdate DESC
LIMIT 100;
# Time: 110528 23:48:14
# User@Host: dbu_15[dbu_15] @ [192.168.5.74]
# Query_time: 2 Lock_time: 0 Rows_sent: 100 Rows_examined: 2150
use db_gdtb_15;
SELECT c.id as id,
c.target as target,
c.target_id as target_id,
c.target_link as target_link,
c.content as content,
c.guestname,
c.pubdate as fpubdate,
IFNULL(c.user_id, 0) as user_id,
IFNULL(u.nickname, '') as author,
IFNULL(u.login, '') as author_login,
IFNULL(v.total_rating, 0) as rating
FROM cms_users u, cms_comments c
LEFT JOIN cms_ratings_total v ON v.item_id=c.id AND v.target='comment'
WHERE (c.user_id=u.id OR c.guestname<>'') AND c.published=1 AND (c.target="article" OR c.target="blog" OR c.target="palbum" OR c.target="photo" OR c.target="userphoto" OR c.target="catalog" OR c.target="boarditem" OR c.target="faq" OR c.target="shopitem")
GROUP BY c.id
ORDER BY c.pubdate DESC
LIMIT 100;
# Time: 110528 23:48:52
# User@Host: dbu_15[dbu_15] @ [192.168.5.74]
# Query_time: 3 Lock_time: 0 Rows_sent: 0 Rows_examined: 942115
SELECT id FROM cms_stats WHERE (ip = '95.37.40.111' AND page = '/main/pages-11');
# Time: 110528 23:48:53
# User@Host: dbu_gdtb_15[dbu_gdtb_15] @ [192.168.5.74]
# Query_time: 4 Lock_time: 0 Rows_sent: 100 Rows_examined: 2150
SELECT c.id as id,
c.target as target,
c.target_id as target_id,
c.target_link as target_link,
c.content as content,
c.guestname,
c.pubdate as fpubdate,
IFNULL(c.user_id, 0) as user_id,
IFNULL(u.nickname, '') as author,
IFNULL(u.login, '') as author_login,
IFNULL(v.total_rating, 0) as rating
FROM cms_users u, cms_comments c
LEFT JOIN cms_ratings_total v ON v.item_id=c.id AND v.target='comment'
WHERE (c.user_id=u.id OR c.guestname<>'') AND c.published=1 AND (c.target="article" OR c.target="blog" OR c.target="palbum" OR c.target="photo" OR c.target="userphoto" OR c.target="catalog" OR c.target="boarditem" OR c.target="faq" OR c.target="shopitem")
GROUP BY c.id
ORDER BY c.pubdate DESC
LIMIT 100;
# Time: 110528 23:49:30
# User@Host: dbu_15[dbu_15] @ [192.168.5.74]
# Query_time: 2 Lock_time: 0 Rows_sent: 1 Rows_examined: 942117
SELECT id FROM cms_stats WHERE (ip = '178.49.36.212' AND page = '/rss/content/1/feed.rss');
# Time: 110528 23:49:48