Shawn, you're way too bored.
'Serenity'
Buffistas Building a Better Board
Do you have problems, concerns or recommendations about the technical side of the Phoenix? Air them here. Compliments also welcome.
Quit trying to distract us from the TRUTH!
When you connect to MySQL from the command-line, are you using the same username that you use when you connect from PHP?
I haven't had an error that I can remember, and I've been online since a bit after 3:30am (12:30 board time). Just thought I'd mention it. Of course it doesn't look like many others were here for most of that time, but I've gotten errors in the obscene hours, before.
eta...
I spoke too soon. I just got my first one, trying to threadsuck about 375 posts from Bitches.
Timestamp: October 21, 2003, 4:37 am
For the record, I get the errors when I'm nearly the only awake Buffista, and there are no new posts anywhere.
When you connect to MySQL from the command-line, are you using the same username that you use when you connect from PHP?
Yup, using the same db.
WTF? They're limiting our mysql usage, but they're not giving us any means of monitoring it?
ETA: Does the query "SHOW FULL PROCESSLIST" show anything different?
Nope, Tom.
And being in mysql again gave me the error every time I tried to load a page.
So now I'm out.
OK, we should definitely be submitting this as a bug to the ISP. We specifically need to say that connecting to mysql from the command line will lock out the web site, and that show processlist only shows one connection. If they try to push back again, we need to press them and get them to provide us evidence that we're actually exceeding our allotment of mysql connects, because otherwise, we can't debug the problem.
As a further test, if you connect to mysql from the command line, what happens when you try to connect a second time from the command line, and try to do a show processlist?
As a further test, if you connect to mysql from the command line, what happens when you try to connect a second time from the command line, and try to do a show processlist?
Can't connect the second time. I get the max_connections error at the command line when I try and type in the password.