ERROR 1040 (00000): Too many connections

[Website Rob]

Zen Cart not using persistent connections is something I should have mentioned as that is clearly shown in both config files. Trouble is, other scripts / processes could use mySQL and by disabling persistent connections Server wide, is the only sure way to eliminate it as a problem area.

[DrByte]

Trouble is, other scripts / processes could use mySQL and by disabling persistent connections Server wide, is the only sure way to eliminate it as a problem area.

Yes, good point.

I believe Jeff manages his own server, and I think it's only Zen Cart that's running on it.


Wondering if it might be useful to switch to *only* using persistent connections, instead of the other way around ... for this server?

[Website Rob]

That is a viable option but then other tweaking / modifing to the 'my.cnf' file would need to be done. That would also include testing plus trial & error to see what works best for that particular Server.

Mind you, that's not say with persistent connections turned OFF you don't have to worry. Tweaking plus trial & error still needs to be done, only not as much.

[jeffmic]

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

[DrByte]

Seems like it's clogging up on your custom search queries.

[macclick]

Going through the thread I have some issues with the same error.

This may not be your issue but it was mine.

the Sql Database got huge which is my fault for not running maintenance scripts on a cron job or a timely manner. this created my hard drive to overload.

It got down to 1 MB of available space.

Fixed by deleting archived files I had on the system giving me some space.
Then ran a repair and maint on the My sql and all where safe.

pain so now its on a cron job and I have set aside an hour a month in ical to email me to check the server.

The server has been running for years with out an outage so I tend to take it for granted that it will work.

Suggest you check the hard drive available space and it will work a lot better with a couple of GB of ram