VBsupport перешел с домена .ORG на родной .RU
Ура!
Пожалуйста, обновите свои закладки - VBsupport.ru
Блок РКН снят, форум доступен на всей территории России, включая новые терртории, без VPN
На форуме введена премодерация ВСЕХ новых пользователей
Почта с временных сервисов, типа mailinator.com, gawab.com и/или прочих, которые предоставляют временный почтовый ящик без регистрации и/или почтовый ящик для рассылки спама, отслеживается и блокируется, а так же заносится в спам-блок форума, аккаунты удаляются
Если вы хотите приобрести какой то скрипт/продукт/хак из каталогов перечисленных ниже: Каталог модулей/хаков
Ещё раз обращаем Ваше внимание: всё, что Вы скачиваете и устанавливаете на свой форум, Вы устанавливаете исключительно на свой страх и риск.
Сообщество vBSupport'а физически не в состоянии проверять все стили, хаки и нули, выкладываемые пользователями.
Помните: безопасность Вашего проекта - Ваша забота. Убедительная просьба: при обнаружении уязвимостей или сомнительных кодов обязательно отписывайтесь в теме хака/стиля
Спасибо за понимание
Cyb - Advanced Forum Statistics
Cyb - Sub-Forum Manager
DI - BBCode [spoiler]
Ld - Монетизатор
MDM - Быстрое цитирование
Multiple Account Detection & Prevention
NoSpam!
passiveVid
Prevent DoublePosts MDM
TCattd - The Image Resizer
vB Optimise
vBadvanced CMPS
Yo Extended Reputation System
Комментарий Админа / Модера
Кто посетил наш форум сегодня
Управления именами пользователей
Система Благодарностей за сообщения
Система Фууу! за сообщения
Скрытие ссылок
Таблица (BB код)
Улучшение быстрого редактора
---------------
Мучаюсь уже полгода, сайт еле живой уже от падений =\
Хостер: iphoster.ru, обычный хостинг, не vds\vps.
Gucci добавил 15.07.2011 в 00:26
Извините за даблпост. На Mail ещё приходят сразу такие письма:
MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Thursday, July 14th 2011 @ 10:08:59 PM
Error Date : Thursday, July 14th 2011 @ 10:09:33 PM
Script : http://мой_сайт.ру/форум
Referrer : http://мой_сайт.ру
IP Address : 95.26.78.31
Username : Abrikos
Classname : vB_Database
MySQL Version :
Last edited by Gucci : 07-15-2011 at 01:26 AM.
Reason: Добавлено сообщение
Создаёт проблемы, если есть темы с большим кол-ом сообщений (больше 1000), удалите на время его тоже и проанализируйте. Если попустит, но не ждите что прям сразу.
Оптимизируйте и исправьте таблицы форума предварительно сделав бекап форума.
И обновиться желательно.
OldEr
Специалист
Join Date: Jun 2007
Награды в конкурсах:
Posts: 4,731
Версия vB: 3.8.x
Пол:
Reputation:
Мастер 4229
Репутация в разделе: 2623
1
Установите продукт "Debug mode" (от kerk) и скопируйте сюда результаты, отображаемые на главной страницы, страницы раздела и страницы темы.
@Gucci
Простоузер
Join Date: May 2009
Location: localhost
Posts: 61
Версия vB: 3.8.4
Пол:
Reputation:
Novice 5
Репутация в разделе: 5
0
Quote:
Originally Posted by OldEr
Установите продукт "Debug mode" (от kerk) и скопируйте сюда результаты, отображаемые на главной страницы, страницы раздела и страницы темы.
SELECT moderator.*, user.username,
IF(user.displaygroupid = 0, user.usergroupid, user.displaygroupid) AS displaygroupid, infractiongroupid
FROM moderator AS moderator
INNER JOIN user AS user USING(userid)
WHERE moderator.userid = 1
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE user const PRIMARY PRIMARY 4 const 1
1 SIMPLE moderator ref userid_forumid userid_forumid 4 const 1
Time Before: 0.06420 seconds
Time After: 0.06444 seconds
Time Taken: 0.00024 seconds
SELECT noticeid
FROM noticedismissed AS noticedismissed
WHERE noticedismissed.userid = 1
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE Impossible WHERE noticed after reading const tables
Time Before: 0.05542 seconds
Time After: 0.05548 seconds
Time Taken: 0.00006 seconds
Memory Before: 8,336.883 KB
Memory After: 8,337.891 KB
Memory Used: 1.008 KB
End call of global.php: 0.0570049285889
SQL Query
(SELECT permissions, permissions2, FIND_IN_SET(forumid, '178,136,135,-1') AS pos, forumid
FROM moderator
WHERE userid = 1 AND forumid IN (178,136,135,-1)
ORDER BY pos ASC
LIMIT 1)
UNION
(SELECT permissions, permissions2, 0, forumid
FROM moderator
WHERE userid = 1 AND forumid = -1
)
Time Before: 0.07283 seconds
Time After: 0.07293 seconds
Time Taken: 0.00010 seconds
SELECT
post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS isdeleted,
user.*, userfield.*, usertextfield.*,
icon.title as icontitle, icon.iconpath,
avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight,
spamlog.postid AS spamlog_postid,
deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason,
editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline,
editlog.reason AS edit_reason, editlog.hashistory,
postparsed.pagetext_html, postparsed.hasimages,
sigparsed.signatureparsed, sigparsed.hasimages AS sighasimages,
sigpic.userid AS sigpic, sigpic.dateline AS sigpicdateline, sigpic.width AS sigpicwidth, sigpic.height AS sigpicheight,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid
FROM post AS post
LEFT JOIN user AS user ON(user.userid = post.userid)
LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid)
LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid = user.userid)
LEFT JOIN icon AS icon ON(icon.iconid = post.iconid)
LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
LEFT JOIN spamlog AS spamlog ON(spamlog.postid = post.postid)
LEFT JOIN deletionlog AS deletionlog ON(post.postid = deletionlog.primaryid AND deletionlog.type = 'post')
LEFT JOIN editlog AS editlog ON(editlog.postid = post.postid)
LEFT JOIN postparsed AS postparsed ON(postparsed.postid = post.postid AND postparsed.styleid = 41 AND postparsed.languageid = 2)
LEFT JOIN sigparsed AS sigparsed ON(sigparsed.userid = user.userid AND sigparsed.styleid = 41 AND sigparsed.languageid = 2)
LEFT JOIN sigpic AS sigpic ON(sigpic.userid = post.userid)
WHERE post.postid IN (0,203869,203875,203876,203877)
ORDER BY post.dateline
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE avatar system PRIMARY 0 const row not found
1 SIMPLE spamlog system PRIMARY 0 const row not found
1 SIMPLE post range PRIMARY PRIMARY 4 5 Using where; Using filesort
1 SIMPLE user eq_ref PRIMARY PRIMARY 4 Loco148.post.userid 1
1 SIMPLE deletionlog eq_ref PRIMARY,type PRIMARY 5 Loco148.post.postid,const 1
1 SIMPLE editlog eq_ref PRIMARY PRIMARY 4 Loco148.post.postid 1
1 SIMPLE postparsed eq_ref PRIMARY PRIMARY 8 Loco148.post.postid,const,const 1
1 SIMPLE sigparsed eq_ref PRIMARY PRIMARY 8 Loco148.user.userid,const,const 1
1 SIMPLE sigpic eq_ref PRIMARY PRIMARY 4 Loco148.post.userid 1
1 SIMPLE customavatar eq_ref PRIMARY PRIMARY 4 Loco148.user.userid 1
1 SIMPLE userfield eq_ref PRIMARY PRIMARY 4 Loco148.user.userid 1
1 SIMPLE usertextfield eq_ref PRIMARY PRIMARY 4 Loco148.user.userid 1
1 SIMPLE icon eq_ref PRIMARY PRIMARY 2 Loco148.post.iconid 1
Time Before: 0.08024 seconds
Time After: 0.08117 seconds
Time Taken: 0.00093 seconds
SELECT * FROM post_thanks AS post_thanks INNER JOIN user AS user USING (userid) WHERE post_thanks.postid IN (0,203869,203875,203876,203877) ORDER BY post_thanks.username ASC
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE post_thanks range postid postid 4 6 Using where; Using filesort
1 SIMPLE user eq_ref PRIMARY PRIMARY 4 Loco148.post_thanks.userid 1 Using where
Time Before: 0.08420 seconds
Time After: 0.08458 seconds
Time Taken: 0.00038 seconds
SELECT * FROM post_groan AS post_groan INNER JOIN user AS user USING (userid) WHERE post_groan.postid IN (0,203869,203875,203876,203877) ORDER BY post_groan.username ASC
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE post_groan range postid postid 4 5 Using where; Using filesort
1 SIMPLE user eq_ref PRIMARY PRIMARY 4 Loco148.post_groan.userid 1 Using where
Time Before: 0.08622 seconds
Time After: 0.08654 seconds
Time Taken: 0.00032 seconds
SELECT userid, oldusername FROM mh_unm_history
WHERE userid IN (360)
ORDER BY userid, dateline DESC
LIMIT 1
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE mh_unm_history ref PRIMARY PRIMARY 4 const 1 Using where
Time Before: 0.10056 seconds
Time After: 0.10062 seconds
Time Taken: 0.00006 seconds
Memory Before: 10,449.922 KB
Memory After: 10,450.898 KB
Memory Used: 0.977 KB
Time after parsing all posts: 0.104789018631 Memory After: 10,430KB
SQL Query
SELECT user.username, user.usergroupid, user.membergroupids,
session.userid, session.inthread, session.lastactivity, session.badlocation,
IF(user.displaygroupid = 0, user.usergroupid, user.displaygroupid) AS displaygroupid, infractiongroupid,
IF(user.options & 512, 1, 0) AS invisible
FROM session AS session
LEFT JOIN user AS user ON(user.userid = session.userid)
WHERE session.lastactivity > 1310718388
ORDER BY username ASC, lastactivity DESC
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE session ALL 112 Using where; Using temporary; Using filesort
1 SIMPLE user eq_ref PRIMARY PRIMARY 4 Loco148.session.userid 1
Time Before: 0.10521 seconds
Time After: 0.10580 seconds
Time Taken: 0.00059 seconds
SELECT smilieid, smilietext, smiliepath, smilie.title,
imagecategory.title AS category
FROM smilie AS smilie
LEFT JOIN imagecategory AS imagecategory USING(imagecategoryid)
ORDER BY imagecategory.displayorder, imagecategory.title, smilie.displayorder
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE smilie ALL 234 Using temporary; Using filesort
1 SIMPLE imagecategory eq_ref PRIMARY PRIMARY 2 Loco148.smilie.imagecategoryid 1
Time Before: 0.10879 seconds
Time After: 0.10891 seconds
Time Taken: 0.00012 seconds
FROM forum AS forum
LEFT JOIN subscribeforum AS subscribeforum ON (subscribeforum.forumid = forum.forumid AND subscribeforum.userid = 1)
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE forum ALL 162
1 SIMPLE subscribeforum eq_ref subindex,forumid subindex 6 const,Loco148.forum.forumid 1
Time Before: 0.04435 seconds
Time After: 0.04450 seconds
Time Taken: 0.00016 seconds
SELECT moderator.*, user.username,
IF(user.displaygroupid = 0, user.usergroupid, user.displaygroupid) AS displaygroupid, infractiongroupid
FROM moderator AS moderator
INNER JOIN user AS user USING(userid)
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE moderator ALL userid_forumid 25
1 SIMPLE user eq_ref PRIMARY PRIMARY 4 Loco148.moderator.userid 1
Time Before: 0.04768 seconds
Time After: 0.04776 seconds
Time Taken: 0.00008 seconds
SELECT
announcement.announcementid, startdate, title, announcement.views,
user.username, user.userid, user.usertitle, user.customtitle, user.usergroupid,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid
, NOT ISNULL(announcementread.announcementid) AS readannounce
FROM announcement AS announcement
LEFT JOIN announcementread AS announcementread ON (announcementread.announcementid = announcement.announcementid AND announcementread.userid = 1)
LEFT JOIN user AS user ON(user.userid = announcement.userid)
WHERE startdate <= 1310719425
AND enddate >= 1310719425
AND forumid IN (8,1,-1)
ORDER BY startdate DESC, announcement.announcementid DESC
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE announcement range forumid,startdate startdate 6 2 Using where; Using filesort
1 SIMPLE announcementread eq_ref PRIMARY,userid PRIMARY 8 Loco148.announcement.announcementid,const 1 Using index
1 SIMPLE user eq_ref PRIMARY PRIMARY 4 Loco148.announcement.userid 1
Time Before: 0.05828 seconds
Time After: 0.05860 seconds
Time Taken: 0.00032 seconds
SELECT
IF(votenum >= 1, votenum, 0) AS votenum,
IF(votenum >= 1 AND votenum > 0, votetotal / votenum, 0) AS voteavg,
post.pagetext AS preview,
thread.threadid, thread.title AS threadtitle, thread.forumid, pollid, open, postusername, postuserid, thread.iconid AS threadiconid,
thread.dateline, notes, thread.visible, sticky, votetotal, thread.attach, thread.lastpost, thread.lastposter, thread.lastpostid, thread.replycount, IF(thread.views<=thread.replycount, thread.replycount+1, thread.views) AS views,
thread.prefixid, thread.taglist, hiddencount, deletedcount
, NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed
, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason
, threadredirect.expires
FROM thread AS thread
LEFT JOIN deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND deletionlog.type = 'thread')
LEFT JOIN subscribethread AS subscribethread ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 1 AND canview = 1)
LEFT JOIN post AS post ON(post.postid = thread.firstpostid)
LEFT JOIN threadredirect AS threadredirect ON(thread.open = 10 AND thread.threadid = threadredirect.threadid)
WHERE thread.threadid IN (0,3244,3724,4157,3405,2707,214,624,2533,3345,3245)
ORDER BY sticky DESC, lastpost DESC
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE threadredirect system PRIMARY 0 const row not found
1 SIMPLE thread range PRIMARY PRIMARY 4 11 Using where; Using filesort
1 SIMPLE deletionlog eq_ref PRIMARY,type PRIMARY 5 Loco148.thread.threadid,const 1
1 SIMPLE subscribethread eq_ref threadid,userid threadid 8 Loco148.thread.threadid,const 1
1 SIMPLE post eq_ref PRIMARY PRIMARY 4 Loco148.thread.firstpostid 1
Time Before: 0.06502 seconds
Time After: 0.06513 seconds
Time Taken: 0.00011 seconds
Высокая нагрузка на сервер [Хостер ругается]
