I'm running Mediawiki (version 1.6.8) and yesterday I killed a "sleep" process initiated by the MediaWiki software in the MyphpAdmin which had been running for 8 hours. Today I just caught another one (see below) about 3 hours old (approx 10,000 seconds). Any idea whats causing this? I havent been able to get any information on this on the internet, as no one seems to be having this problem.
thanks Erik
Copy paste from "Show processes" in MyPHPAdmin:
Kill 9438726 user100 localhost wikidb Sleep 9698
--------------------------------- How low will we go? Check out Yahoo! Messengers low PC-to-Phone call rates.
Hello Erik,
I'm running Mediawiki (version 1.6.8) and yesterday I killed a "sleep" process initiated by the MediaWiki software in the MyphpAdmin which had been running for 8 hours.
It is sleeping child, probably hanging apache/php thread, so MySQL does not close the connection. You may want to set wait_timeout to lower values (say, 600). On the other hand, you may want to find out why is it still connected (lsof, gdb, bt ;-)
mediawiki-l@lists.wikimedia.org