mySQL performance

LongIslandJam · 1-18-05, 11:48 AM

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 · 1-18-05, 11:56 AM

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 · 1-18-05, 12:00 PM

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 · 1-18-05, 12:29 PM

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 · 1-18-05, 12:43 PM

Quote:

Originally Posted by 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...

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 · 1-18-05, 12:52 PM

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

LongIslandJam · 1-18-05, 01:35 PM

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 · 1-18-05, 01:38 PM

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

LongIslandJam · 1-18-05, 02:35 PM

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

1-18-05, 02:49 PM

Quote:

Originally Posted by B&T

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 · 1-19-05, 11:48 AM

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.

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

1-18-05, 11:48 AM	#1
LongIslandJam Join Date: Dec 2001 Location: Long Island, NY Posts: 109 Reputation: 5	mySQL performance 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. __________________ J.A. Ackley

1-18-05, 12:00 PM	#3
B&T Just tryin' to help Join Date: Jan 2003 Location: along the journey Posts: 8,036 Reputation: 125	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 . . . __________________ Enhance your PowWeb experience @ B&T's Tips & Scripts Got some free time? You can find Nothing of Value @ PrettyWorthless.com

1-18-05, 12:29 PM	#4
LongIslandJam Join Date: Dec 2001 Location: Long Island, NY Posts: 109 Reputation: 5	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... __________________ J.A. Ackley

1-18-05, 12:52 PM	#6
LongIslandJam Join Date: Dec 2001 Location: Long Island, NY Posts: 109 Reputation: 5	Ok I'll keep that in mind. Thanks for the tip... __________________ J.A. Ackley

1-18-05, 01:35 PM	#7
LongIslandJam Join Date: Dec 2001 Location: Long Island, NY Posts: 109 Reputation: 5	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 __________________ J.A. Ackley

1-18-05, 11:56 AM	#2
mitchind Older not wiser Join Date: Nov 2003 Location: Calgary, AB Posts: 2,473 Reputation: 205	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)

1-18-05, 01:38 PM	#8
LongIslandJam Join Date: Dec 2001 Location: Long Island, NY Posts: 109 Reputation: 5	Maybe upgrading VBUlletin script will work, and doing so now... __________________ J.A. Ackley

1-18-05, 02:35 PM	#9
LongIslandJam Join Date: Dec 2001 Location: Long Island, NY Posts: 109 Reputation: 5	Actually i'm on mysql08 (just checked again) and its down... __________________ J.A. Ackley

1-19-05, 11:48 AM	#11
satis Join Date: Oct 2002 Location: Dallas Posts: 2,659 Reputation: 204	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. Anyway, just thought I'd add. I do use alot of includes....are we still having include issues? __________________ Satis Clankiller Clankiller.com Forums Clankiller.com PlasmaSky.com

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search