From: Geoffrey L. W. <ge...@no...> - 2002-01-22 10:13:20
|
From: Geoffrey L. W. <ge...@no...> - 2002-01-22 10:36:41
|
Ack! Apologies for that last message. Inadvertently hit the send key before the proper time. Not a particularly eloquent first post to the list... Now on to my little issue: I'm a recent convert to PhpWiki. We just set up 1.2.2 at work, and in a few short weeks it's become indispensable. I'm now in process of setting up PhpWiki on my personal domain using 1.3.2. I installed it several nights ago and it went w/out a hitch. Install process was nice, easy and well-documented. 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? Many thanks, //glw |
From: Reini U. <ru...@x-...> - 2002-01-22 23:14:23
|
"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) |
From: Reini U. <ru...@x-...> - 2002-01-23 08:02:47
|
Reini Urban schrieb: > 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) oops, sorry. kill -1 doesn't help at all. this just re-reads the config files. apachectl restart; /etc/init.d/mysqld restart resp. on windows better net stop apache; net stop mysql; net start mysql; net start apache -- Reini Urban http://atelier.akbild.ac.at/ (soon) http://xarch.tu-graz.ac.at/home/rurban/ (big) http://tv.mur.at/ (kulturelles) |