p.1 #1 · OT: Any of you run applications on your website that use mysql
aside from the obvious wordpress?
If so is the performance good? And who is your host?
I'm having terrible performance out of my godaddy account and thinking of moving to different pastures, but would like to make this a ONE TIME move... so I'd rather not be hosting-hopping.
Overall I'm not too dissatisfied with Godaddy's performance in terms of serving pages, but php apps that do (minor but numerous) calls to the mysql database have performance that goes from nearly instantaneous to waiting 10 seconds for a page. Unacceptable.
p.1 #5 · OT: Any of you run applications on your website that use mysql
Are you guys specifically talking about MYSQL performance or just general hosting performance?
Like I said I'm pretty ok with GD's hosting performance... the (significant) bottleneck seems to be related to mysql performance.
I guess step 1 will be to document the performance. I just set up a pingdom check to hit one of my db pages every minute and record the response time. I'll give it a few days and see what I'm seeing (espcially compared to the main site) then I might hit godaddy up for support ( suspect that telling them "the response time was around 15,000 ms for a half hour yesterday starting at 11:26 AM will be more effective than just calling and saying "it seems slow").
I've had a few people recommend hostgator now... and they do seem to have month-to-month accounts... so I could always get a second domain, copy the stuff over and pingdom godaddy and hostgator head-to-head
p.1 #6 · OT: Any of you run applications on your website that use mysql
I've never had any problem with MySQL performance on any host I've used. I would argue that GoDaddy is the exception here. On my current host I have one table with the state's sales tax rates with over a million rows and have no problems querying it (averages about 0.08 seconds).
p.1 #7 · OT: Any of you run applications on your website that use mysql
Well it's NOT Looking good.
I've had pingdom monitoring a mysql app page for an hour now and I've already gotten three alerts from pingdom that the page was down (definition of down = didn't finish loading within 30 seconds).
On the other hand in about 36 minutes out of the test the page loaded in under 1 second.
