[Soft] Kinokpk.com releaser 3.00
- Автор темы Freddy_CRACKER
- Дата начала
- Статус
apofiz
Создатель
- Регистрация
- 22 Июн 2009
- Сообщения
- 23
- Реакции
- 0
apofiz
Создатель
- Регистрация
- 22 Июн 2009
- Сообщения
- 23
- Реакции
- 0
Tinymce Пашет нормально, а вот на счет загрузки сервака вот:
Страница сгенерирована за 0.599668 секунд. Выполнено 6 запросов (30.02% PHP / 69.98% MySQL)
Сервак на xeon'ах ос Debian Apache+nginx
ilyuzhko
Постоялец
- Регистрация
- 5 Май 2009
- Сообщения
- 58
- Реакции
- 21
там снизу в полном дебаге должно быть написано какой запрос грузит запрос или же пых напрягается?
можно по - подробнее...
apofiz
Создатель
- Регистрация
- 22 Июн 2009
- Сообщения
- 23
- Реакции
- 0
Вот если возможно посмотрите и скажите что не так
[1] => 0.000730991363525 [SELECT users.*,stylesheets.uri FROM users LEFT JOIN stylesheets ON users.stylesheet = stylesheets.id WHERE users.id = 3 AND confirmed=1]
[2] => 0.000324010848999 [UPDATE LOW_PRIORITY users SET last_access = 1274204217 WHERE id=3]
[3] => 0.000463008880615 [INSERT INTO sessions (sid, uid, username, class, ip, time, url, useragent) VALUES ('7ee3d5ba043f307af0649629637a50f0', 3, 'Imhotep', 6, '10.58.119.247', 1274204217, '/', 'Opera/9.80 (Windows NT 6.1; U; ru) Presto/2.5.24 Version/10.53') ON DUPLICATE KEY UPDATE sid = '7ee3d5ba043f307af0649629637a50f0', uid = 3, username = 'Imhotep', class = 6, ip = '10.58.119.247', time = 1274204217, url = '/', useragent = 'Opera/9.80 (Windows NT 6.1; U; ru) Presto/2.5.24 Version/10.53']
[4] => 0.303239107132 [SELECT (SELECT GROUP_CONCAT(id) FROM messages WHERE location=1 AND receiver=3 AND unread=1) AS unread, (SELECT GROUP_CONCAT(id) FROM messages WHERE location=1 AND receiver=3) AS inbox, (SELECT GROUP_CONCAT(id) FROM messages WHERE saved=1 AND sender=3) AS outbox, (SELECT GROUP_CONCAT(id) FROM torrents WHERE id NOT IN (8283) AND added>1274195932) AS torrents, (SELECT GROUP_CONCAT(id) FROM comments WHERE id NOT IN (34052) AND added>1274195932) AS comments, (SELECT GROUP_CONCAT(id) FROM pollcomments WHERE added>1274195932) AS pollcomments, (SELECT GROUP_CONCAT(id) FROM newscomments WHERE added>1274195932) AS newscomments, (SELECT GROUP_CONCAT(id) FROM usercomments WHERE added>1274195932) AS usercomments, (SELECT GROUP_CONCAT(id) FROM reqcomments WHERE added>1274195932) AS reqcomments, (SELECT GROUP_CONCAT(id) FROM rgcomments WHERE added>1274195932) AS rgcomments, (SELECT GROUP_CONCAT(id) FROM pages WHERE added>1274195932 AND class <= 6) AS pages, (SELECT GROUP_CONCAT(id) FROM pagecomments WHERE added>1274195932) AS pagecomments, (SELECT GROUP_CONCAT(id) FROM friends WHERE friendid=3 AND confirmed=0) AS friends, (SELECT GROUP_CONCAT(id) FROM users WHERE added>1274195932) AS users, (SELECT GROUP_CONCAT(id) FROM reports) AS reports, (SELECT GROUP_CONCAT(id) FROM torrents WHERE moderatedby=0) AS unchecked]
[5] => 9.29832458496E-5 [SELECT tid, posts, title, icon_id, description, starter_name, last_poster_name, views FROM ibf_topics WHERE (forum_id NOT IN (1)) ORDER BY last_post DESC LIMIT 0, 5]
[6] => 0.0105791091919 [SELECT userid FROM peers GROUP by userid]
[7] => 0.0106699466705 [(SELECT SUM(1) AS peers FROM peers WHERE seeder=1) UNION (SELECT SUM(1) AS peers FROM peers WHERE seeder=0)]
[8] => 0.000125169754028 [SELECT * FROM cron WHERE cron_name IN ('rating_freetime','rating_enabled')]
[9] => 0.738795042038 [SELECT (SELECT SUM(1) FROM peers WHERE seeder=1 AND userid=3) AS seeding, (SELECT SUM(1) FROM snatched LEFT JOIN torrents ON snatched.torrent=torrents.id WHERE snatched.finished=1 AND torrents.free=0 AND NOT FIND_IN_SET(torrents.freefor,userid) AND userid=3 AND torrents.owner<>3) AS downloaded]
[10] => 0.0088210105896 [SELECT uid, time FROM sessions WHERE uid<>-1 AND time < 1274200618]
[11] => 0.000210046768188 [DELETE FROM sessions WHERE time < 1274200618]
[12] => 7.39097595215E-5 [SELECT * FROM cron WHERE cron_name IN ('last_cleanup','in_cleanup','in_remotecheck','num_cleaned','num_checked','remotecheck_disabled','last_remotecheck','autoclean_interval','remotecheck_interval')]
Все запросы к базе данных заняли 1.07412433624 секунд
Очистка БД в режиме ожидания
Проверка удаленных пиров отключена
- Статус