mySQL performance

[LongIslandJam]

Is it just me or does it seem that the mySQL performance in past few days has took a nose dive since the upgrade. Static pages work great, but pages off the mySQL database (like my forum), have really taken a nosedive in speed performance.

[mitchind]

There's been a few problems overall here in the last week, but I don't remember mySQL being one of them.

What server are you on? (mysql##.powweb.com)

[B&T]

I don't think it is MySQL. Simple pages that use a lot of MySQL hits but only one include, like prettyworthless.com come up very fast. So MySQL is likely not the cause.

I would tend to think it is more the overly complex code in the cms applications. But why that code would have problems here . . . don't know. I moved the one phpbb forum I had to another environment some time ago (not for any reasons about PowWeb), so I do not experience the issues I see sometimes reported here with cms apps.

All my stuff running here I coded myself, and I have no php or mysql issues When ever those pages are slow, so is the plain html.

Now YOUR MySQL server could have a problem . . .

[LongIslandJam]

Seems like it is going faster now. Earlier this morning it was at a crawl...

And my forum is on mySQL01... and its a VBulletin like this...

[B&T]

Seems like it is going faster now. Earlier this morning it was at a crawl...

And my forum is on mySQL01... and its a VBulletin like this...
Hmmm . . . I also run prettyworthless.com off mysql01 . . . next time you are running slow try http://prettyworthless.com and see how that simple php page with about 30 mysql queries performs. That may tell you if it is the mysql server.

[LongIslandJam]

Ok I'll keep that in mind. Thanks for the tip... :D

[LongIslandJam]

Definitely something funny as my forums can't connect to the database...

Database error in vBulletin :

Link-ID == false, connect failed
mysql error:

mysql error number: 0

[LongIslandJam]

Maybe upgrading VBUlletin script will work, and doing so now...

[LongIslandJam]

Actually i'm on mysql08 (just checked again) and its down...:(

[cinenganos]

Hmmm . . . I also run prettyworthless.com off mysql01 . . . next time you are running slow try http://prettyworthless.com and see how that simple php page with about 30 mysql queries performs. That may tell you if it is the mysql server.

Your site is way toooooooooooo slow, and the same thing (or worse) is found now on MySQL08...

[satis]

I've noticed my site seems to be kinda slow too. I've been building some php/mysql apps, and testing it can be really tedious when page loads take a couple seconds. I'm not so convinced it's a mysql issue, though. May be a PHP parsing thing. I have microtime set on my php pages to clock page generation times, and even on a multi-second load the generation time will be less than a second. I have no clue what that means. :p

Anyway, just thought I'd add. I do use alot of includes....are we still having include issues?