For the record, I get the errors when I'm nearly the only awake Buffista, and there are no new posts anywhere.
Yeah, but you're an amateur fry cook and I come from a long line of fry cooks that don't live past 25.
Buffy ,'Showtime'
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.
Nilly - Oct 21, 2003 3:58:10 am PDT #5368 of 10000
Swouncing
§ ita § - Oct 21, 2003 4:11:15 am PDT #5369 of 10000
Well not canonically, no, but this is transformative fiction.
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.
Tom Scola - Oct 21, 2003 4:15:09 am PDT #5370 of 10000
Remember that the frontier of the Rebellion is everywhere. And even the smallest act of insurrection pushes our lines forward.
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?
§ ita § - Oct 21, 2003 4:20:49 am PDT #5371 of 10000
Well not canonically, no, but this is transformative fiction.
Nope, Tom.
And being in mysql again gave me the error every time I tried to load a page.
So now I'm out.
Tom Scola - Oct 21, 2003 4:34:00 am PDT #5372 of 10000
Remember that the frontier of the Rebellion is everywhere. And even the smallest act of insurrection pushes our lines forward.
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?
§ ita § - Oct 21, 2003 4:36:27 am PDT #5373 of 10000
Well not canonically, no, but this is transformative fiction.
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.
Tom Scola - Oct 21, 2003 4:37:27 am PDT #5374 of 10000
Remember that the frontier of the Rebellion is everywhere. And even the smallest act of insurrection pushes our lines forward.
OK, cool. That's further evidence that the problem is on their end, not ours.
§ ita § - Oct 21, 2003 4:45:11 am PDT #5375 of 10000
Well not canonically, no, but this is transformative fiction.
When I get home from work, I want to take the board down for a little while and see how many mysql sessions I can set up from the command line when no one's using the code.
Tom Scola - Oct 21, 2003 4:47:29 am PDT #5376 of 10000
Remember that the frontier of the Rebellion is everywhere. And even the smallest act of insurrection pushes our lines forward.
Cereal: Do you know how many pageviews per second b.o averages? From what you say, it looks like the error occurs every time two people hit the site simultaneously.
If that's the case, turning off threadsuck until the issue is resolved might reduce the number of errors.
Wolfram - Oct 21, 2003 7:32:55 am PDT #5377 of 10000
Visilurking
Is there any way to find out if other websites hosted by the same server we use are having similar problems?