Re: [Phpwiki-talk] sudden, strange wiki slowdown

[Reini U. <ru...@x-...>]

"Geoffrey L. Wright" schrieb:
> But mid-today I started noticing a bit 'o strange lag every time I accessed
> the wiki.  Basicly, page loads now take 3 or 4 seconds, whereas before they
> we quite quick.  If you're interested, you can witness the effect first
> hand at:
> http://www.northernwastes.org
> 
> Here are several useful things to know.
> 
> 1 - I host several other domains on this machine.  Everything else seems
> healthy.
> 
> 2 - I run SquirrelMail (http://squirrelmail.sourceforge.net), and it too
> seems to be functioning properly.  So nothing seems _grossly_ wrong w/my PHP
> setup.
> 
> 3 - I'm using MySQL as the back-end.
> 
> 4 - Neither MySQL, Apache nor PhpWiki are reporting any errors.
> 
> 5 - Upgrading to the most recent nightly snap doesn't change the problem for
> better or worse.  (Although I really dig the OS X theme...)
> 
> 6 - Backing up the wiki, then nuking the database, then rebuilding it
> doesn't change anything.  A brand-spankin' new wiki has the same problem.
> 
> 7 - I'm running Debian/Woody.  apache-ssl, php4, php4-mysql, php4-pear and
> mysql-server are all apt-installed.
> 
> 8 - I've reinstalled the PhpWiki code and reconfigured the index.php file
> several times to make sure I haven't kludged anything there.
> 
> 9 - I can't think of a damned thing that I've changed on the box before the
> problem started to occur.  I don't _think_ I upgraded any related packages.
>  (or any packages at all, for that matter...)
> 
> Any thoughts or constructive advice?

1. either you are using filesystem sessions, a "bad" filesystem (i.e. not
ReiserFS, XFS) such 
as ext2 or ntfs and your temp is quite full (say > 500 files) and your php is
configured to use 
automatic sessions. (--enable-trans-sid). 
fileaccess in such dirs is not solved on simple "linear" filesystems.

2. from time to time on heavy load my mysql begins to crawl also. but mostly
on windows.
maybe when paging starts to occur. i restart mysql then (killall -1
safe_mysqld) and/or 
apache (apachectl graceful)
-- 
Reini Urban
  http://atelier.akbild.ac.at/ (soon)
  http://xarch.tu-graz.ac.at/home/rurban/ (big)
  http://tv.mur.at/ (kulturelles)