FreeBSD

xolod. · Отправлено: **19:13, 31-08-2009** | #2

Народ не проходите мимо....в чём же может быть дело?

WhitePangolin · Отправлено: **08:35, 01-09-2009** | #3

Цитата xolod.:

Народ не проходите мимо....в чём же может быть дело? »

ну а чего проходить то?

Цитата xolod.:

Aug 30 23:11:22.960921 [WARNING] fpm_request_check_timed_out(), line 146: child 596, script '/usr/local/www/web1/index.php' (pool default) executing too slow (5.069391 sec), logg »

скрипт выполняется 5.069391 sec а это слишком долго. Либо увеличьте таймаут, либо ищите ошибку в скрипте. Причем ошибка в скрипте наиболее вероятна, потому никто и не отвечает. Был бы код, можно было бы подумать, а так...

xolod. · Отправлено: **11:29, 01-09-2009** | #4

ee /usr/local/www/web1/index.php

Код:

<?php

/*
	This file is part of TorrentPier

	TorrentPier is free software: you can redistribute it and/or modify
	it under the terms of the GNU General Public License as published by
	the Free Software Foundation, either version 3 of the License, or
	(at your option) any later version.

	TorrentPier is distributed in the hope that it will be useful,
	but WITHOUT ANY WARRANTY; without even the implied warranty of
	MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
	GNU General Public License for more details.

	A copy of the GPL 2.0 should have been included with the program.
	If not, see http://www.gnu.org/licenses/

	Official SVN repository and contact information can be found at
	http://code.google.com/p/torrentpier/
 */

define('IN_PHPBB',   true);
define('BB_SCRIPT', 'index');
define('BB_ROOT', './');
$phpEx = substr(strrchr(__FILE__, '.'), 1);
require(BB_ROOT ."common.$phpEx");

$page_cfg['load_tpl_vars'] = array(
	'post_icons',
);

$show_last_topic	= true;
$last_topic_max_len = 28;
$show_online_users  = true;
$show_subforums	 = true;

$datastore->enqueue(array(
	'stats',
	'moderators',
));
if ($bb_cfg['show_latest_news'])
{
	$datastore->enqueue('latest_news');
}

// Init userdata
$user->session_start();

// Init main vars
$viewcat = isset($_GET['c']) ? (int) $_GET['c'] : 0;
$lastvisit = (IS_GUEST) ? TIMENOW : $userdata['user_lastvisit'];

// Caching output
$req_page = 'index_page';
$req_page .= ($viewcat) ? "_c{$viewcat}" : '';

define('REQUESTED_PAGE', $req_page);
caching_output(IS_GUEST, 'send', REQUESTED_PAGE .'_guest');

// Topics read tracks
$tracking_topics = get_tracks('topic');
$tracking_forums = get_tracks('forum');

// Statistics
$stats = $datastore->get('stats');

// Forums data
$forums = $datastore->get('cat_forums');
$cat_title_html = $forums['cat_title_html'];
$forum_name_html = $forums['forum_name_html'];

$anon = ANONYMOUS;
$excluded_forums_csv = $user->get_excluded_forums(AUTH_VIEW);
$only_new = $user->opt_js['only_new'];

// Validate requested category id
if ($viewcat AND !$viewcat =& $forums['c'][$viewcat]['cat_id'])
{
	redirect("index.$phpEx");
}
// Forums
$forums_join_sql = 'f.cat_id = c.cat_id';
$forums_join_sql .= ($viewcat) ? "
	AND f.cat_id = $viewcat
" : '';
$forums_join_sql .= ($excluded_forums_csv) ? "
	AND f.forum_id NOT IN($excluded_forums_csv)
	AND f.forum_parent NOT IN($excluded_forums_csv)
" : '';

// Posts
$posts_join_sql = "p.post_id = f.forum_last_post_id";
$posts_join_sql .= ($only_new == ONLY_NEW_POSTS) ? "
	AND p.post_time > $lastvisit
" : '';
$join_p_type = ($only_new == ONLY_NEW_POSTS) ? 'INNER JOIN' : 'LEFT JOIN';

// Topics
$topics_join_sql = "t.topic_last_post_id = p.post_id";
$topics_join_sql .= ($only_new == ONLY_NEW_TOPICS) ? "
	AND t.topic_time > $lastvisit
" : '';
$join_t_type = ($only_new == ONLY_NEW_TOPICS) ? 'INNER JOIN' : 'LEFT JOIN';

$sql = "
	SELECT SQL_CACHE
		f.cat_id, f.forum_id, f.forum_status, f.forum_parent, f.show_on_index,
		p.post_id AS last_post_id, p.post_time AS last_post_time,
		t.topic_id AS last_topic_id, t.topic_title AS last_topic_title,
		u.user_id AS last_post_user_id,
		IF(p.poster_id = $anon, p.post_username, u.username) AS last_post_username
	FROM	   ". CATEGORIES_TABLE ." c
	INNER JOIN ". FORUMS_TABLE	 ." f ON($forums_join_sql)
	$join_p_type ". POSTS_TABLE	  ." p ON($posts_join_sql)
	$join_t_type ". TOPICS_TABLE	 ." t ON($topics_join_sql)
	 LEFT JOIN ". USERS_TABLE	  ." u ON(u.user_id = p.poster_id)
	ORDER BY c.cat_order, f.forum_order
";
$cat_forums = array();

$replace_in_parent = array(
	'last_post_id',
	'last_post_time',
	'last_post_user_id',
	'last_post_username',
	'last_topic_title',
	'last_topic_id',
);

foreach ($db->fetch_rowset($sql) as $row)
{
	if (!$cat_id = $row['cat_id'] OR !$forum_id = $row['forum_id'])
	{
		continue;
	}

	if ($parent_id = $row['forum_parent'])
	{
		if (!$parent =& $cat_forums[$cat_id]['f'][$parent_id])
		{
			$parent = $forums['f'][$parent_id];
			$parent['last_post_time'] = 0;
		}
		if ($row['last_post_time'] > $parent['last_post_time'])
		{
			foreach ($replace_in_parent as $key)
			{
				$parent[$key] = $row[$key];
			}
		}
		if ($show_subforums && $row['show_on_index'])
		{
			$parent['last_sf_id'] = $forum_id;
		}
		else
		{
			continue;
		}
	}
	else
	{
		$f =& $forums['f'][$forum_id];
		$row['forum_desc']   = $f['forum_desc'];
		$row['forum_posts']  = $f['forum_posts'];
		$row['forum_topics'] = $f['forum_topics'];
	}

	$cat_forums[$cat_id]['f'][$forum_id] = $row;
}
unset($forums);
$datastore->rm('cat_forums');

// Obtain list of moderators
$moderators = array();
$mod = $datastore->get('moderators');

foreach ($mod['mod_users'] as $forum_id => $user_ids)
{
	foreach ($user_ids as $user_id)
	{
		$moderators[$forum_id][] = '<a href="'. (PROFILE_URL . $user_id) .'">'. $mod['name_users'][$user_id] .'</a>';
	}
}
foreach ($mod['mod_groups'] as $forum_id => $group_ids)
{
	foreach ($group_ids as $group_id)
	{
		$moderators[$forum_id][] = '<a href="'. (GROUP_URL . $group_id) .'">'. $mod['name_groups'][$group_id] .'</a>';
	}
}

unset($mod);
$datastore->rm('moderators');

if (!$forums_count = count($cat_forums) AND $viewcat)
{
	redirect("index.$phpEx");
}

$template->assign_vars(array(
	'SHOW_FORUMS'		   => $forums_count,
	'PAGE_TITLE'			=> $lang['Index'],
	'NO_FORUMS_MSG'		 => ($only_new) ? $lang['NO_NEW_POSTS'] : $lang['NO_FORUMS'],

	'TOTAL_TOPICS'		  => sprintf($lang['Posted_topics_total'], $stats['topiccount']),
	'TOTAL_POSTS'		   => sprintf($lang['Posted_articles_total'], $stats['postcount']),
	'TOTAL_USERS'		   => sprintf($lang['Registered_users_total'], $stats['usercount']),
	'NEWEST_USER'		   => sprintf($lang['Newest_user'], '<a href="'. PROFILE_URL . $stats['newestuser']['user_id'] .'">', $stats['newestuser']['username'], '</a>'),

	// Tracker stats
	'TORRENTS_STAT'		 => sprintf($lang['Torrents_stat'], $stats['torrentcount'], humn_size($stats['size'])),
	'PEERS_STAT'			=> sprintf($lang['Peers_stat'], $stats['peers'], $stats['seeders'], $stats['leechers']),
	'SPEED_STAT'			=> sprintf($lang['Speed_stat'], humn_size($stats['speed']) .'/s'),

	'FORUM_IMG'			 => $images['forum'],
	'FORUM_NEW_IMG'		 => $images['forum_new'],
	'FORUM_LOCKED_IMG'	  => $images['forum_locked'],

	'SHOW_ONLY_NEW_MENU'	=> true,
	'ONLY_NEW_POSTS_ON'	 => ($only_new == ONLY_NEW_POSTS),
	'ONLY_NEW_TOPICS_ON'	=> ($only_new == ONLY_NEW_TOPICS),

	'U_SEARCH_NEW'		  => "search.$phpEx?new=1",
	'U_SEARCH_SELF_BY_MY'   => "search.$phpEx?uid={$userdata['user_id']}&o=1",
	'U_SEARCH_LATEST'	   => "search.$phpEx?search_id=latest",
	'U_SEARCH_UNANSWERED'   => "search.$phpEx?search_id=unanswered",

	'SHOW_LAST_TOPIC'	   => $show_last_topic,
));

// Build index page
foreach ($cat_forums as $cid => $c)
{
	$template->assign_block_vars('c', array(
		'CAT_ID'	=> $cid,
		'CAT_TITLE' => $cat_title_html[$cid],
		'U_VIEWCAT' => "index.$phpEx?c=$cid",
	));

	foreach ($c['f'] as $fid => $f)
	{
		if (!$fname_html =& $forum_name_html[$fid])
		{
			continue;
		}
		$is_sf = $f['forum_parent'];

		$new = is_unread($f['last_post_time'], $f['last_topic_id'], $f['forum_id']) ? '_new' : '';
		$folder_image = ($is_sf) ? $images["icon_minipost{$new}"] : $images["forum{$new}"];

		if ($f['forum_status'] == FORUM_LOCKED)
		{
			$folder_image = ($is_sf) ? $images['icon_minipost'] : $images['forum_locked'];
		}

		if ($is_sf)
		{
			$template->assign_block_vars('c.f.sf', array(
				'SF_ID'   => $fid,
				'SF_NAME' => $fname_html,
				'SF_NEW'  => $new ? ' new' : '',
			));
			continue;
		}

		$template->assign_block_vars('c.f',	array(
			'FORUM_FOLDER_IMG' => $folder_image,

			'FORUM_ID'   => $fid,
			'FORUM_NAME' => $fname_html,
			'FORUM_DESC' => $f['forum_desc'],
			'POSTS'	  => commify($f['forum_posts']),
			'TOPICS'	 => commify($f['forum_topics']),
			'LAST_SF_ID' => isset($f['last_sf_id']) ? $f['last_sf_id'] : null,

			'MODERATORS'  => isset($moderators[$fid]) ? join(', ', $moderators[$fid]) : '',
			'FORUM_FOLDER_ALT' => ($new) ? 'new' : 'old',
		));

		if ($f['last_post_id'])
		{
			$template->assign_block_vars('c.f.last', array(
				'LAST_TOPIC_ID'	   => $f['last_topic_id'],
				'LAST_TOPIC_TIP'	  => $f['last_topic_title'],
				'LAST_TOPIC_TITLE'	=> wbr(str_short($f['last_topic_title'], $last_topic_max_len)),

				'LAST_POST_TIME'	  => create_date($bb_cfg['last_post_date_format'], $f['last_post_time']),
				'LAST_POST_USER_ID'   => ($f['last_post_user_id'] != ANONYMOUS) ? $f['last_post_user_id'] : false,
				'LAST_POST_USER_NAME' => ($f['last_post_username']) ? str_short($f['last_post_username'], 15) : $lang['Guest'],
			));
		}
	}
}

// Set tpl vars for bt_userdata
if ($bb_cfg['bt_show_dl_stat_on_index'] && !IS_GUEST)
{
	show_bt_userdata($userdata['user_id']);
}

// Latest news
if ($bb_cfg['show_latest_news'])
{
	$latest_news = $datastore->get('latest_news');

	$template->assign_vars(array(
		'SHOW_LATEST_NEWS' => true,
	));

	foreach ($latest_news as $news)
	{
		$template->assign_block_vars('news', array(
			'NEWS_TOPIC_ID' => $news['topic_id'],
			'NEWS_TITLE'	=> $news['topic_title'],
			'NEWS_TIME'	 => create_date('d-M', $news['topic_time']),
			'NEWS_IS_NEW'   => $news['topic_time'] > $lastvisit,
		));
	}
}
// Allow cron
if (IS_ADMIN || IS_MOD)
{
	if (@file_exists(CRON_RUNNING)) {
		if (@file_exists(CRON_ALLOWED))
		{
			unlink (CRON_ALLOWED);
		}
		rename(CRON_RUNNING, CRON_ALLOWED);
	}
}

// Display page
define('SHOW_ONLINE', $show_online_users);

print_page('index.tpl');

WhitePangolin · Отправлено: **12:32, 01-09-2009** | #5

Забавно... ошибки в скрипте нет... причем повисает в таком месте где и зависнуть то нечему, 6 элементов всего...
Могу предположить что машинка слабовата или перегружена запросами в связи с чем медленно выполняет скрипт и тупо не успевает за отведенный промежуток времени.

dmitryst · Конфигурация компьютера

можно попробовать закомментировать все операции с файлами, и проверить лог.

WhitePangolin · Отправлено: **14:55, 01-09-2009** | #7

Я тут чего подумал...

Цитата xolod.:

fastcgi_pass 127.0.0.1:9000; »

а если попробовать через сокеты?

dmitryst · Конфигурация компьютера

второй вариант - сделать замер, сколько выполняется запрос к базе данных (вывести одну из строк запроса на экран, и скопировать в консольный клиент). Вполне возможно, тормоза именно на этом этапе, SELECT-то нехилый

xolod. · Отправлено: **15:13, 01-09-2009** | #9

- Сделал релиз через сокеты
- Тестировал на 2 ПК
- удалил eAccelerator
-железо Celero1000, 512RAM (на серверее я один...)

Судя по логам всё то же самое, сайт так же грузиться ~30 Секунд

xolod. · Отправлено: **15:45, 01-09-2009** | #10

После смены интервала с 5s на 60s
появилось следующее:
Sep 01 16:37:15.760002 [NOTICE] fpm_unix_init_main(), line 284: getrlimit(nofile): max:7207, cur:7207
Sep 01 16:37:15.798769 [NOTICE] fpm_event_init_main(), line 88: libevent: using kqueue
Sep 01 16:37:15.799337 [NOTICE] fpm_init(), line 52: fpm is running, pid 595
Sep 01 16:37:15.908277 [NOTICE] fpm_children_make(), line 352: child 599 (pool default) started
Sep 01 16:37:15.912196 [NOTICE] fpm_children_make(), line 352: child 614 (pool default) started
Sep 01 16:37:15.922960 [NOTICE] fpm_children_make(), line 352: child 615 (pool default) started
Sep 01 16:37:15.926873 [NOTICE] fpm_children_make(), line 352: child 616 (pool default) started
Sep 01 16:37:15.930914 [NOTICE] fpm_children_make(), line 352: child 617 (pool default) started
Sep 01 16:37:15.931565 [NOTICE] fpm_event_loop(), line 107: libevent: entering main loop