Re: ERROR 1040 (00000): Too many connections
Here is the data that is displayed with SHOW PROCESSLIST when the server gets clogged. I have to shut off both the web and mySQL to get this to free up.
It's all part of the Too Many connections causing the server to be brought to it's knees. Does anyone see what is really causing the 'stuck' in this data below?
17442,root,localhost,mczencart,Query,346,Sending data,"select count(distinct p.products_id) as total from (products p, jeffsearch j, manufacturers m) whe"
17445,root,localhost,mczencart,Query,338,Sending data,"select count(distinct p.products_id) as total from (products p, jeffsearch j, manufacturers m) whe"
17447,root,localhost,mczencart,Query,336,Sending data,"select count(distinct p.products_id) as total from (products p, jeffsearch j, manufacturers m) whe"
17453,root,localhost,mczencart,Query,320,Sending data,"select count(distinct p.products_id) as total from (products p, jeffsearch j, manufacturers m) whe"
17459,root,localhost,mczencart,Query,303,Sending data,"select count(distinct p.products_id) as total from (products p, jeffsearch j, manufacturers m) whe"
17465,root,localhost,mczencart,Query,287,Sending data,"select count(distinct p.products_id) as total from (products p, jeffsearch j, manufacturers m) whe"
17467,root,localhost,mczencart,Query,282,Sending data,"select count(distinct p.products_id) as total from (products p, jeffsearch j, manufacturers m) whe"
17468,root,localhost,mczencart,Query,282,Sending data,"select count(distinct p.products_id) as total from (products p, jeffsearch j, manufacturers m) whe"
17479,root,localhost,mczencart,Query,268,Sending data,"select count(distinct p.products_id) as total from (products p, jeffsearch j, manufacturers m) whe"
17480,root,localhost,mczencart,Query,268,Sending data,"select count(distinct p.products_id) as total from (products p, jeffsearch j, manufacturers m) whe"
17485,root,localhost,mczencart,Query,264,Sending data,"select count(distinct p.products_id) as total from (products p, jeffsearch j, manufacturers m) whe"
17486,root,localhost,mczencart,Query,264,Sending data,"select count(distinct p.products_id) as total from (products p, jeffsearch j, manufacturers m) whe"
17493,root,localhost,mczencart,Query,246,Sending data,"select count(distinct p.products_id) as total from (products p, jeffsearch j, manufacturers m) whe"
17503,root,localhost,mczencart,Query,237,Sending data,"select count(distinct p.products_id) as total from (products p, jeffsearch j, manufacturers m) whe"
17504,root,localhost,mczencart,Query,237,Sending data,"select count(distinct p.products_id) as total from (products p, jeffsearch j, manufacturers m) whe"
17505,root,localhost,mczencart,Query,237,Sending data,"select count(distinct p.products_id) as total from (products p, jeffsearch j, manufacturers m) whe"
17506,root,localhost,mczencart,Query,236,Sending data,"select count(distinct p.products_id) as total from (products p, jeffsearch j, manufacturers m) whe"
17507,root,localhost,mczencart,Query,236,Sending data,"select count(distinct p.products_id) as total from (products p, jeffsearch j, manufacturers m) whe"
17508,root,localhost,mczencart,Query,236,Sending data,"select count(distinct p.products_id) as total from (products p, jeffsearch j, manufacturers m) whe"
17511,root,localhost,mczencart,Query,232,Sending data,"select count(distinct p.products_id) as total from (products p, jeffsearch j, manufacturers m) whe"
17512,root,localhost,mczencart,Query,232,Sending data,"select count(distinct p.products_id) as total from (products p, jeffsearch j, manufacturers m) whe"
17514,root,localhost,mczencart,Query,227,Sending data,"select count(distinct p.products_id) as total from (products p, jeffsearch j, manufacturers m) whe"
17515,root,localhost,mczencart,Query,227,Sending data,"select count(distinct p.products_id) as total from (products p, jeffsearch j, manufacturers m) whe"
17521,root,localhost,mczencart,Query,222,Sending data,"select count(distinct p.products_id) as total from (products p, jeffsearch j, manufacturers m) whe"
17522,root,localhost,mczencart,Query,222,Sending data,"select count(distinct p.products_id) as total from (products p, jeffsearch j, manufacturers m) whe"
17528,root,localhost,mczencart,Query,197,Sending data,"select count(distinct p.products_id) as total from (products p, jeffsearch j, manufacturers m) whe"
17529,root,localhost,mczencart,Query,197,Sending data,"select count(distinct p.products_id) as total from (products p, jeffsearch j, manufacturers m) whe"
17530,root,localhost,mczencart,Query,191,Sending data,"select count(distinct p.products_id) as total from (products p, jeffsearch j, manufacturers m) whe"
17531,root,localhost,mczencart,Query,191,Sending data,"select count(distinct p.products_id) as total from (products p, jeffsearch j, manufacturers m) whe"
17540,root,localhost,mczencart,Query,166,Sending data,"select count(distinct p.products_id) as total from (products p, jeffsearch j, manufacturers m) whe"
17541,root,localhost,mczencart,Query,166,Sending data,"select count(distinct p.products_id) as total from (products p, jeffsearch j, manufacturers m) whe"
17547,root,localhost,mczencart,Query,145,Sending data,"select count(distinct p.products_id) as total from (products p, jeffsearch j, manufacturers m) whe"
17550,root,localhost,mczencart,Query,136,Sending data,"select count(distinct p.products_id) as total from (products p, jeffsearch j, manufacturers m) whe"
17551,root,localhost,mczencart,Query,136,Sending data,"select count(distinct p.products_id) as total from (products p, jeffsearch j, manufacturers m) whe"
17571,root,localhost,mczencart,Query,116,Sending data,"select count(distinct p.products_id) as total from (products p, jeffsearch j, manufacturers m) whe"
17572,root,localhost,mczencart,Query,114,Sending data,"select count(distinct p.products_id) as total from (products p, jeffsearch j, manufacturers m) whe"
17573,root,localhost,mczencart,Query,114,Sending data,"select count(distinct p.products_id) as total from (products p, jeffsearch j, manufacturers m) whe"
17574,root,localhost,mczencart,Query,113,Sending data,"select count(distinct p.products_id) as total from (products p, jeffsearch j, manufacturers m) whe"
17575,root,localhost,mczencart,Query,113,Sending data,"select count(distinct p.products_id) as total from (products p, jeffsearch j, manufacturers m) whe"
17588,root,localhost,mczencart,Query,98,Sending data,"select count(distinct p.products_id) as total from (products p, jeffsearch j, manufacturers m) whe"
17589,root,localhost,mczencart,Query,97,Sending data,"select count(distinct p.products_id) as total from (products p, jeffsearch j, manufacturers m) whe"
17590,root,localhost,mczencart,Query,97,Sending data,"select count(distinct p.products_id) as total from (products p, jeffsearch j, manufacturers m) whe"
17591,root,localhost,mczencart,Query,97,Sending data,"select count(distinct p.products_id) as total from (products p, jeffsearch j, manufacturers m) whe"
17598,root,localhost,mczencart,Query,86,Sending data,"select count(distinct p.products_id) as total from (products p, jeffsearch j, manufacturers m) whe"
17599,root,localhost,mczencart,Query,85,Copying to tmp table,"select p.products_id, p.products_image\r\n from orders_products opa, orders_produc"
17600,root,localhost,mczencart,Query,77,Sending data,"select count(distinct p.products_id) as total from (products p, jeffsearch j, manufacturers m) whe"
17601,root,localhost,mczencart,Query,72,Sending data,"select count(distinct p.products_id) as total from (products p, jeffsearch j, manufacturers m) whe"
17602,root,localhost,mczencart,Query,70,Sending data,"select count(distinct p.products_id) as total from (products p, jeffsearch j, manufacturers m) whe"
17605,root,localhost,mczencart,Query,60,Sending data,"select count(distinct p.products_id) as total from (products p, jeffsearch j, manufacturers m) whe"
17606,root,localhost,mczencart,Query,56,Copying to tmp table,"select p.products_id, p.products_image\r\n from orders_products opa, orders_produc"
17611,root,localhost,mczencart,Query,42,Sending data,"select count(distinct p.products_id) as total from (products p, jeffsearch j, manufacturers m) whe"
17617,root,localhost,mczencart,Query,32,Sending data,"select count(distinct p.products_id) as total from (products p, jeffsearch j, manufacturers m) whe"
17623,root,localhost,mczencart,Query,24,Sending data,"select count(distinct p.products_id) as total from (products p, jeffsearch j, manufacturers m) whe"
17629,root,localhost:63136,,Sleep,11,,
17631,root,localhost:63138,mczencart,Sleep,9,,
17634,root,localhost,mczencart,Query,3,Sending data,"select count(distinct p.products_id) as total from (products p, jeffsearch j, manufacturers m) whe"
17635,root,localhost:63139,mczencart,Sleep,0,,
17636,root,localhost:63140,mczencart,Query,0,,show processlist
Jeff Michaels,
pres of Musical Creations Ltd.
Bookmarks