I dropped back to trying 1.3.3 because I was having trouble with the session table, but I'm still having problems.
I get phpwiki installed and working with mysql without too much fuss, however, after several pageloads, I start getting database errors. Checking mysqladmin processlist shows a bunch of sleeping processes. And yes, since I have a cheap-o webhost, the number of processes allowed seems to be severely limited. If I kill all the mysql processes, I can use the Wiki a little more, but each pageload adds a sleeping entry to the processlist.
A friend suggested that it is because phpwiki is using persistant database connections and not releasing them properly. I grepped through the code, but the only pconnect reference I could find was in the Pear DB itself. Setting pconnect => false there hasn't helped, can anyone more familiar with the codebase comment on this problem?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I dropped back to trying 1.3.3 because I was having trouble with the session table, but I'm still having problems.
I get phpwiki installed and working with mysql without too much fuss, however, after several pageloads, I start getting database errors. Checking mysqladmin processlist shows a bunch of sleeping processes. And yes, since I have a cheap-o webhost, the number of processes allowed seems to be severely limited. If I kill all the mysql processes, I can use the Wiki a little more, but each pageload adds a sleeping entry to the processlist.
A friend suggested that it is because phpwiki is using persistant database connections and not releasing them properly. I grepped through the code, but the only pconnect reference I could find was in the Pear DB itself. Setting pconnect => false there hasn't helped, can anyone more familiar with the codebase comment on this problem?
Found it:
I changed line 24 of lib\WikiDB\backend\PearDB.php to 'persistent' => false, and everything is working fine now. (phpwiki-1.3.3)