Op een van onze servers draaid een PHPnuke site die voor een continu hoge serverload veroorzaakt. (2.0)
Dit is voornamelijk een druk bezocht Forum met PHPbb laaste versie voor nuke.
Tevens heb ik zojuist geadviseerd om (alle) pics in de hantekeningen uit te schakelen.
Tevsn zie ik in de phpmyadmin dat er veel connecties in sleep mode blijven hangen. dit hebik in het systeem nu al naar beneden gebracht zodat deze al na 1 sec worden gekilled.
echter we blijven de hoge serverload houden (zakt wel iets)
De databases maakt connectie via pconnect echter dit helpt naar mijn idee ook niks.
hieronder staat de config van de phpnuke site.
wellicht dat iemand hier wat opmerkingen over kan loslaten.
PHP Code:
<?php
// $Id: config.php,v 1.12 2004/04/13 14:54:38 markwest Exp $
// ----------------------------------------------------------------------
// PostNuke Content Management System
// Copyright (C) 2001 by the PostNuke Development Team.
// [url]http://www.postnuke.com/[/url]
// ----------------------------------------------------------------------
// Based on:
// PHP-NUKE Web Portal System - [url]http://phpnuke.org/[/url]
// Thatware - [url]http://thatware.org/[/url]
// ----------------------------------------------------------------------
// LICENSE
//
// This program is free software; you can redistribute it and/or
// modify it under the terms of the GNU General Public License (GPL)
// as published by the Free Software Foundation; either version 2
// of the License, or (at your option) any later version.
//
// This program 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.
//
// To read the license please visit [url]http://www.gnu.org/copyleft/gpl.html[/url]
// ----------------------------------------------------------------------
// Original Author of file: Everyone
// Purpose of file: Configure database
// ----------------------------------------------------------------------
// ----------------------------------------------------------------------
// Database & System Config
//
// dbtype: type of database, currently only mysql
// dbhost: MySQL Database Hostname
// dbuname: MySQL Username
// dbpass: MySQL Password
// dbname: MySQL Database Name
// system: 0 for Unix/Linux, 1 for Windows
// encoded: 0 for MySQL information unenccoded
// 1 for encoded
// pconnect: 0 do not use pconnect (persistent connections)
// 1 use pconnect [class007]
// temp: folder (with optional full path) for temp writable
// temp directory
// ----------------------------------------------------------------------
//
$pnconfig['dbtype'] = 'mysql';
$pnconfig['dbtabletype'] = 'myisam';
$pnconfig['dbhost'] = 'localhost';
$pnconfig['dbuname'] = 'YmVwc3Rlcl9hZG1pbg==';
$pnconfig['dbpass'] = 'blablabla';
$pnconfig['dbname'] = 'gebruiker_cms';
$pnconfig['system'] = '0';
$pnconfig['prefix'] = 'nuke';
$pnconfig['encoded'] = '1';
$pnconfig['pconnect'] = '1';
$pnconfig['temp'] = 'pnTemp';
// ----------------------------------------------------------------------
// For debugging (Pablo Roca)
//
// $debug - debugger windows active
// 0 = No
// 1 = Yes
//
// $debug_sql - show SQL in lens debug
// 0 = No
// 1 = Yes
//
// $pagerendertime - display page render time in page footer
// 0 = No
// 1 = Yes
// ----------------------------------------------------------------------
global $pndebug;
$pndebug['debug'] = 0;
$pndebug['debug_sql'] = 0;
$pndebug['pagerendertime'] = 0;
// ----------------------------------------------------------------------
// You have finished configuring the database. Now you can start to
// change your site settings in the Administration Section.
//
// Thanks for choosing PostNuke.
// ----------------------------------------------------------------------
// ----------------------------------------------------------------------
// if there is a personal_config.php in the folder where is config.php
// we add it. (This HAS to be at the end, after all initialization.)
// ----------------------------------------------------------------------
if (@file_exists("personal_config.php"))
{ include("personal_config.php"); }
// ----------------------------------------------------------------------
// Make config file backwards compatible (deprecated)
// ----------------------------------------------------------------------
extract($pnconfig, EXTR_OVERWRITE);
?>