A plea for help: can someone poke around on my site a little bit? It’s probably going to take for-freakin’-ever, but it ought to come up eventually.
Let me know if it does take forever, and if you get any error messages on the page. OS and browser would help too.
I’m trying to eliminate the path as a source of the problem. I think there’s something wrong w/ the mysql server and/or database, but it could just be the path my little packets are taking.
That said, this’ll be the second time that gallery has really irritated me, and it seems to be spreading to wordpress. Like I said, I think it’s mysql.
Links to start with:
https://robandjen.com/jen/
https://robandjen.com/jen/category/gaming/
http://www.robandjen.com/gallery/
I’ll love you forever!!
alice_curiouser
I didn’t get any error messages, but HOLY CRAP it was slow. XD
Safari on Mac OSX 10.4.8.
geodyne
They were horribly slow. They did take forever. But they all came up without any errors.
Lovely ice shots, btw.
geodyne
I”m tired and not reading for comprehension. Worked fine on both firefox and IE on XP.
jenbooks
Heh – that’s cool. I’m totally convinced it’s nothing to do w/ browsers, or, really, the page itself. Thanks much for hitting it!
kapuhi
WinXP, FF 2
It’s that gallery.
* Gallery
WordPress database error: [Lost connection to MySQL server during query]
SELECT * FROM jen_posts WHERE post_status = ‘static’ ORDER BY menu_order ASC
It’s taking too long to query the DB. Too many requests, or else too many existing connections (see this). I suspect the first, though.
Do you run phpMyAdmin?
jenbooks
Actually, that error is from a navigation snippet – it’s talking to the WORDPRESS database. Though connecting to gallery is also slow, again… the freakin’ mysql database, although I’m fairly sure it’s a different database.
Hell, for all I know, it isn’t, it’s all part of some huge conglomerate.
DAMMIT. I don’t want to call tech support. They’ll just blame me.
Pages that don’t have anything to do w/ wordpress or gallery still come up slow, but not that slow.
EDIT – FUCKING Livejournal:
God I hate computers.
jenbooks
And, to answer your question, short answer is I use phpMyAdmin 2.7.0-pl2 – but I don’t run it. I’m on GoDaddy – they provide this crap. Downside is, I don’t have that much control over it, so I’m not really sure exactly how everything is set up. Sorta.
kapuhi
Do you have a command anywhere in phpMyAdmin that says ‘show processes’? It’s typically top level before you go into a database, so if you start by default AT your DB, you might not have it. It tells you what-all is going on with connections in real time. Best I got for you right now…
jenbooks
Yeah, tried that. It was less than enlightening. ;)
Bah. <whine>I dun’ wanna call them!!</whine>
Oh well. :)
orbie
Yup, it loaded slow as molasses. Maybe slower, meaning I had time to go to the bathroom and stop off at the kitchen for a soda, and still sit and wait for it to finish loading. Looking at the errors in the navigation (under Gallery and Calendar), I’d say it’s an SQL problem, but not anything you did. I used to have this happen sometimes with my last host, and there wasn’t anything much I could do about it. Their SQL servers just sucked, or they limited the number of queries that could be made at one time. I never figured out what it was, I just left that host.
And yeah, probably not OS/browser based, but anyway OSX and Firefox.
jenbooks
Slower. Seriously, two and a half minutes??? And, cool, the calendar snippet screwed up? Awesome.
Sigh.
Thanks for the clicks!