[Apc-aa-coders] Fwd: MySQL Culprit

[Mitra <mi...@mi...>]

It looks like aa is leaving losts of processes around.

What I can't figure out, is whether these are a normal part of 
caching, or a symptom of a problem with the AA code.

If its the latter, then I'm wondering if we need a standard cleanup 
process that closes down all AA DB threads at the end of each of the 
main programs (view.php3, slice.php3 etc).

- Mitra


>Date: Mon, 04 Oct 2004 20:39:56 +0530
>From: Ram Prasad <ra...@me...>
>X-Accept-Language: en-us, en
>To: Mitra <mi...@mi...>
>Subject: MySQL Culprit
>Status:  
>
>Looks like AA is the culprit. Check out the processlist.
>
>- Ram
>
>
>Received: from path.net (localhost.localdomain [127.0.0.1])
>	by pandora.sf.ca.us (8.13.0/8.12.9) with ESMTP id i94F7DYV004676;
>	Mon, 4 Oct 2004 08:07:13 -0700
>Received: (from root@localhost)
>	by path.net (8.13.0/8.12.9/Submit) id i94F7D8B004675;
>	Mon, 4 Oct 2004 08:07:13 -0700
>Date: Mon, 4 Oct 2004 08:07:13 -0700
>Message-Id: <200...@pa...>
>From: mys...@pa...
>To: apa...@pa...
>CC: ra...@gm...
>X-Spam-Checker-Version: SpamAssassin 3.0.0 (2004-09-13) on pandora.path.net
>X-Spam-Level:
>X-Spam-Status: No, score=-3.5 required=5.0 tests=ALL_TRUSTED,AWL,BAYES_00,
>	MISSING_SUBJECT,NO_REAL_NAME,UNIQUE_WORDS autolearn=no version=3.0.0
>
>MySQL is running too many processes. Here is the list
>Id	User	Host	db	Command	Time	State	Info
>34	aadbkm	localhost	aadbkm	Sleep	242365		NULL
>35	aadbuser	localhost	aadb	Sleep	66405		NULL
>36	aadbkm	localhost	aadbkm	Sleep	65146		NULL
>37	aadbkm	localhost	aadbkm	Sleep	115478		NULL
>38	aadbuser	localhost	aadb	Sleep	195		NULL
>39	aadbkm	localhost	NULL	Sleep	242337		NULL
>40	aadbuser	localhost	aadb	Sleep	235701		NULL
>42	aadbuser	localhost	aadb	Sleep	65938		NULL
>44	aadbuser	localhost	aadb	Sleep	115668		NULL
>46	aadbuser	localhost	aadb	Sleep	114098		NULL
>47	aadbuser	localhost	aadb	Sleep	135391		NULL
>48	aadbuser	localhost	aadb	Sleep	183		NULL
>59	aadbkm	localhost	aadbkm	Sleep	4762		NULL
>60	aadbkm	localhost	NULL	Sleep	241463		NULL
>76	aadbkm	localhost	aadbkm	Sleep	134369		NULL
>86	aadbkm	localhost	NULL	Sleep	239591		NULL
>101	aadbkm	localhost	aadbkm	Sleep	113672		NULL
>109	aadbkm	localhost	NULL	Sleep	237972		NULL
>119	aadbkm	localhost	NULL	Sleep	237072		NULL
>128	aadbkm	localhost	aadbkm	Sleep	235157		NULL
>136	aadbkm	localhost	aadbkm	Sleep	64260		NULL
>139	aadbkm	localhost	NULL	Sleep	235023		NULL
>140	aadbkm	localhost	NULL	Sleep	235023		NULL
>141	aadbkm	localhost	NULL	Sleep	235022		NULL
>155	aadbkm	localhost	aadbkm	Sleep	213577		NULL
>164	aadbuser	localhost	aadb	Sleep	214242		NULL
>167	aadbkm	localhost	NULL	Sleep	232469		NULL
>174	aadbkm	localhost	NULL	Sleep	231671		NULL
>187	aadbkm	localhost	NULL	Sleep	230405		NULL
>195	aadbuser	localhost	aadb	Sleep	200831		NULL
>216	aadbkm	localhost	NULL	Sleep	228072		NULL
>231	aadbkm	localhost	NULL	Sleep	226272		NULL
>239	aadbkm	localhost	aadbkm	Sleep	159574		NULL
>241	aadbkm	localhost	NULL	Sleep	225267		NULL
>264	aadbkm	localhost	aadbkm	Sleep	201868		NULL
>317	aadbuser	localhost	aadb	Sleep	159772		NULL
>326	aadbkm	localhost	NULL	Sleep	214465		NULL
>334	aadbkm	localhost	NULL	Sleep	213516		NULL
>354	aadbkm	localhost	aadbkm	Sleep	197375		NULL
>359	aadbuser	localhost	aadb	Sleep	197901		NULL
>421	aadbkm	localhost	NULL	Sleep	203772		NULL
>431	aadbkm	localhost	NULL	Sleep	202873		NULL
>450	aadbkm	localhost	NULL	Sleep	201073		NULL
>466	aadbkm	localhost	NULL	Sleep	199175		NULL
>481	aadbkm	localhost	NULL	Sleep	197351		NULL
>486	aadbuser	localhost	aadb	Sleep	41522		NULL
>492	aadbkm	localhost	NULL	Sleep	196478		NULL
>505	aadbkm	localhost	NULL	Sleep	195477		NULL
>519	aadbkm	localhost	NULL	Sleep	194408		NULL
>536	aadbkm	localhost	NULL	Sleep	192970		NULL
>545	aadbkm	localhost	NULL	Sleep	191936		NULL
>553	aadbkm	localhost	NULL	Sleep	191172		NULL
>556	aadbkm	localhost	NULL	Sleep	190893		NULL
>563	aadbkm	localhost	NULL	Sleep	190272		NULL
>567	aadbuser	localhost	aadb	Sleep	173227		NULL
>580	aadbkm	localhost	NULL	Sleep	188472		NULL
>581	aadbkm	localhost	aadbkm	Sleep	174869		NULL
>623	aadbkm	localhost	NULL	Sleep	184760		NULL
>636	aadbkm	localhost	NULL	Sleep	183073		NULL
>651	aadbkm	localhost	NULL	Sleep	181272		NULL
>660	aadbkm	localhost	NULL	Sleep	180268		NULL
>696	aadbkm	localhost	NULL	Sleep	175873		NULL
>715	aadbkm	localhost	NULL	Sleep	174071		NULL
>724	aadbkm	localhost	NULL	Sleep	173011		NULL
>742	aadbkm	localhost	NULL	Sleep	171372		NULL
>754	aadbkm	localhost	NULL	Sleep	170471		NULL
>784	aadbkm	localhost	aadbkm	Sleep	43505		NULL
>787	aadbuser	localhost	aadb	Sleep	156520		NULL
>788	aadbuser	localhost	aadb	Sleep	63540		NULL
>799	aadbkm	localhost	aadbkm	Sleep	158673		NULL
>827	aadbkm	localhost	aadbkm	Sleep	64993		NULL
>842	aadbkm	localhost	NULL	Sleep	161379		NULL
>865	aadbuser	localhost	aadb	Sleep	65724		NULL
>870	aadbuser	localhost	aadb	Sleep	70		NULL
>874	aadbuser	localhost	aadb	Sleep	41897		NULL
>878	aadbkm	localhost	aadbkm	Sleep	41663		NULL
>901	aadbkm	localhost	aadbkm	Sleep	2064		NULL
>913	aadbkm	localhost	NULL	Sleep	155172		NULL
>914	aadbkm	localhost	aadbkm	Sleep	65026		NULL
>930	aadbkm	localhost	NULL	Sleep	153272		NULL
>937	aadbkm	localhost	NULL	Sleep	152379		NULL
>953	aadbkm	localhost	NULL	Sleep	150672		NULL
>1003	aadbkm	localhost	NULL	Sleep	145272		NULL
>1030	aadbkm	localhost	NULL	Sleep	142470		NULL
>1064	aadbkm	localhost	NULL	Sleep	138867		NULL
>1093	aadbkm	localhost	NULL	Sleep	135372		NULL
>1102	aadbkm	localhost	NULL	Sleep	134338		NULL
>1142	aadbkm	localhost	NULL	Sleep	130613		NULL
>1148	aadbkm	localhost	NULL	Sleep	129973		NULL
>1164	aadbkm	localhost	NULL	Sleep	128173		NULL
>1186	aadbkm	localhost	NULL	Sleep	126255		NULL
>1220	aadbkm	localhost	NULL	Sleep	122650		NULL
>1282	aadbkm	localhost	NULL	Sleep	116472		NULL
>1303	aadbuser	localhost	aadb	Sleep	108631		NULL
>1316	aadbkm	localhost	NULL	Sleep	112872		NULL
>1331	aadbkm	localhost	NULL	Sleep	111746		NULL
>1355	aadbkm	localhost	NULL	Sleep	109271		NULL
>1363	aadbkm	localhost	aadbkm	Sleep	108270		NULL
>1394	aadbkm	localhost	NULL	Sleep	104771		NULL
>1462	aadbkm	localhost	NULL	Sleep	97571		NULL
>1537	aadbkm	localhost	NULL	Sleep	91272		NULL
>1577	aadbkm	localhost	NULL	Sleep	87568		NULL
>1586	aadbkm	localhost	NULL	Sleep	86640		NULL
>1596	aadbuser	localhost	aadb	Sleep	172		NULL
>1614	aadbkm	localhost	aadbkm	Sleep	100		NULL
>1616	aadbkm	localhost	NULL	Sleep	83958		NULL
>1624	aadbkm	localhost	NULL	Sleep	83173		NULL
>1639	aadbkm	localhost	NULL	Sleep	82272		NULL
>1647	aadbkm	localhost	NULL	Sleep	81273		NULL
>1664	aadbkm	localhost	NULL	Sleep	79573		NULL
>1689	aadbkm	localhost	NULL	Sleep	76872		NULL
>1707	aadbkm	localhost	NULL	Sleep	74975		NULL
>1740	aadbkm	localhost	NULL	Sleep	72373		NULL
>1774	aadbkm	localhost	aadbkm	Sleep	2946		NULL
>1779	aadbuser	localhost	aadb	Sleep	817		NULL
>1786	aadbkm	localhost	NULL	Sleep	68453		NULL
>1826	aadbkm	localhost	NULL	Sleep	65456		NULL
>1827	aadbkm	localhost	NULL	Sleep	65456		NULL
>1828	aadbkm	localhost	NULL	Sleep	65455		NULL
>1829	aadbkm	localhost	NULL	Sleep	65288		NULL
>1830	aadbkm	localhost	NULL	Sleep	65282		NULL
>1831	aadbkm	localhost	NULL	Sleep	65279		NULL
>1832	aadbkm	localhost	NULL	Sleep	65278		NULL
>1833	aadbkm	localhost	NULL	Sleep	65275		NULL
>1834	aadbkm	localhost	NULL	Sleep	65273		NULL
>1835	aadbkm	localhost	NULL	Sleep	65270		NULL
>1837	aadbkm	localhost	NULL	Sleep	65266		NULL
>1839	aadbkm	localhost	NULL	Sleep	65259		NULL
>1841	aadbkm	localhost	NULL	Sleep	65252		NULL
>1842	aadbkm	localhost	NULL	Sleep	65244		NULL
>1843	aadbkm	localhost	NULL	Sleep	65238		NULL
>1845	aadbkm	localhost	NULL	Sleep	65219		NULL
>1846	aadbkm	localhost	NULL	Sleep	65213		NULL
>1847	aadbkm	localhost	NULL	Sleep	65207		NULL
>1848	aadbkm	localhost	NULL	Sleep	65201		NULL
>1849	aadbkm	localhost	NULL	Sleep	65195		NULL
>1850	aadbkm	localhost	NULL	Sleep	65183		NULL
>1852	aadbkm	localhost	NULL	Sleep	65159		NULL
>1853	aadbkm	localhost	NULL	Sleep	65167		NULL
>1854	aadbkm	localhost	NULL	Sleep	65160		NULL
>1856	aadbkm	localhost	NULL	Sleep	65145		NULL
>1869	aadbkm	localhost	NULL	Sleep	64272		NULL
>1880	aadbuser	localhost	aadb	Sleep	16050		NULL
>1885	aadbkm	localhost	aadbkm	Sleep	17352		NULL
>1886	aadbkm	localhost	aadbkm	Sleep	4742		NULL
>1887	aadbuser	localhost	aadb	Sleep	40333		NULL
>1899	aadbkm	localhost	NULL	Sleep	62472		NULL
>1900	aadbkm	localhost	aadbkm	Sleep	40762		NULL
>1915	aadbkm	localhost	NULL	Sleep	61241		NULL
>1942	aadbkm	localhost	NULL	Sleep	58872		NULL
>1943	aadbuser	localhost	aadb	Sleep	241		NULL
>1966	aadbkm	localhost	NULL	Sleep	57838		NULL
>1984	aadbkm	localhost	NULL	Sleep	56172		NULL
>2000	aadbkm	localhost	NULL	Sleep	55273		NULL
>2046	aadbkm	localhost	NULL	Sleep	51671		NULL
>2062	aadbkm	localhost	NULL	Sleep	49873		NULL
>2106	aadbkm	localhost	NULL	Sleep	45372		NULL
>2117	aadbkm	localhost	NULL	Sleep	44473		NULL
>2156	aadbkm	localhost	NULL	Sleep	40762		NULL
>2208	aadbkm	localhost	NULL	Sleep	36372		NULL
>2211	aadbkm	localhost	NULL	Sleep	36083		NULL
>2235	aadbkm	localhost	NULL	Sleep	33574		NULL
>2289	aadbkm	localhost	NULL	Sleep	28153		NULL
>2325	aadbkm	localhost	NULL	Sleep	24672		NULL
>2334	aadbkm	localhost	NULL	Sleep	23773		NULL
>2339	aadbuser	localhost	aadb	Sleep	3055		NULL
>2350	aadbkm	localhost	aadbkm	Sleep	1972		NULL
>2358	aadbkm	localhost	NULL	Sleep	21974		NULL
>2414	aadbkm	localhost	NULL	Sleep	20951		NULL
>2456	aadbkm	localhost	NULL	Sleep	19274		NULL
>2485	aadbuser	localhost	aadb	Sleep	310		NULL
>2490	aadbuser	localhost	aadb	Sleep	510		NULL
>2492	aadbkm	localhost	aadbkm	Sleep	342		NULL
>2493	aadbkm	localhost	NULL	Sleep	15556		NULL
>2506	aadbkm	localhost	NULL	Sleep	14771		NULL
>2514	aadbkm	localhost	NULL	Sleep	14527		NULL
>2521	aadbkm	localhost	NULL	Sleep	13873		NULL
>2535	aadbkm	localhost	aadbkm	Sleep	2964		NULL
>2572	aadbkm	localhost	NULL	Sleep	9267		NULL
>2583	aadbkm	localhost	NULL	Sleep	8357		NULL
>2590	aadbkm	localhost	NULL	Sleep	7572		NULL
>2594	aadbkm	localhost	NULL	Sleep	7311		NULL
>2618	aadbuser	localhost	aadb	Sleep	396		NULL
>2637	aadbkm	localhost	NULL	Sleep	3973		NULL
>2648	aadbkm	localhost	NULL	Sleep	2946		NULL
>2662	aadbkm	localhost	NULL	Sleep	1271		NULL
>2676	aadbkm	localhost	NULL	Sleep	370		NULL
>2677	aadbkm	localhost	NULL	Sleep	342		NULL
>2681	aadbkm	localhost	NULL	Sleep	2		NULL
>2683	root	localhost	NULL	Query	0	NULL	show 
>processlist


-- 
Mitra Ardron: home/office +61-2-6684-8096  mobile +61-414-648-722 
mi...@mi...
Natural Innovation: www.naturalinnovation.org
Personal site: www.mitra.biz
My new blog is at: blog.mitra.biz
Skype: mitra_earth

Life is a Mystery to be Lived, not a Problem to be Solved