View Full Version : Love that MySql Upgrade - Signs of Improvement
Just wanted to say that since my database was upgraded to MySql 5.o it's fast..not, not just fast, but super fast...no not super fast...lightning fast..anyway, it's fast.. Thanks for the upgrade.:p
I'm assuming this isn't a poke at the slowness.... Hopefully everyone who has had slowness will feel the same as ginns soon.
raveguideuk
9-5-07, 03:34 PM
me too im on mysql12 check out how fast it is... http://pictures.raveguide.co.uk/main.php?g2_view=core.ShowItem&g2_itemId=7
i going to start recommending you again cos powweb is the best! :D
Well, I just checked it out - it was slow to load!
YvetteKuhns
9-5-07, 06:43 PM
Slow? It won't load at all now. Someone posted a thumbs up and jinxed the servers again.
See, this is exactly what's happening to my web site. For instance, today in the morning
was good..... an hour later didn't even load; later worked OK again; two hours later
down again, and so on .............
They said that is the MySQL upgrade ??? I thought that was done .....
Very disapointed. I'm sorry.
YvetteKuhns
9-6-07, 10:35 AM
Saw the Rave pictures load quickly this time. No hot guys, just a bunch of drunken party kids. Kinda looks like what was left standing at my wedding reception. :D
It's been slower for me. I've got a WordPress-based site that was quite slow yesterday and this morning won't load at all. Is MySQL down?
YvetteKuhns
9-6-07, 01:26 PM
Log into phpmyadmin and check your tables to see if there is any overhead. Optimize your tables. Do not optimize tables that are currently in use. If you check tables first, you will know if they are.
I am having issues with Zen Cart (on another host) where some features aren't working that are related to the tables with overhead. It may be a coincidence. That host still uses php4 and mysql4, but they are offering upgrades.
Okay, 13 tables have overhead (total 413K). But, they're almost certainly going to be in use unless I take the site offline, which I don't really want to do. I guess if I have to, I will though.
How do I optimize one (or more) tables?
Update: I asked too soon. I seem to have to click into each table and select the Optimize Table command.
YvetteKuhns
9-6-07, 02:56 PM
You can Check All to optimize all of the tables when offline. Sometimes I just do one at a time when I am troubleshooting. ;)
Just wanted to say that since my database was upgraded to MySql 5.o it's fast..not, not just fast, but super fast...no not super fast...lightning fast..anyway, it's fast.. Thanks for the upgrade.:p
How is your database lately?
doorstopper2000
9-9-07, 04:37 AM
still loads of stuff not working as good
i did not ask for the so called upgrade
i put the blaim on powweb
Just wanted to let you know my site is still super fast. I did my monthly report last week, and that is usually a painful process because the site would just bog down as I went from post to post. This time it flew from page to page. I'll let you know if anything changes.:D
YvetteKuhns
9-12-07, 02:36 PM
All of my websites, upgraded or not, are still loading quickly. Maybe the abusers are finally disabled or moved?! If that pagination problem gets resolved, I will only have the email filtering topic for (my own) rants. ;) Unless, of course, I decide to install a forum, blog or open source e-commerce website. :D
We will have to fix that, Yvette. That's just so wrong. :D
Well guess some are lucky and others are completely hosed. My site lags badly all day long, one moment it runs fine and the next nothing. Always seems to work great when doing a tech call they never seem to find anything wrong but as I am chatting with them the site starts to lag once again. I am getting complaints every day from the members of our club and nothing or no one seems to want to step up and fix it.
Well guess some are lucky and others are completely hosed. My site lags badly all day long, one moment it runs fine and the next nothing.
No, it has nothing to do with luck, after 3 mins of attempted loading the page failed. The sarcasm, and facetious remarks are obviously in ridicule of the reality. In fact I would probably go as far as to assume the level of true anger & frustration crossed the line into a rage that has given ginns a psychotic break down, turning a once proud individual into a blathering idiot.
My sympathies are with you ginns/all.
I think this summer Powweb has slipped from like the #4 host to something in double digits.
Jim Zim
10-12-07, 02:53 PM
I noticed this post on October 1st from Joshuamc of the PowWeb staff:
MySQL Updated
We have just made an upgrade to one of the MySQL machines that we believe will greatly reduce any latency that some customers may have been experiencing.
Our plan is to test the upgrade for at least a week so that we can ensure that this is the best solution for increasing the speed of our MySQL platform. If everything goes well, we will be begin to roll out the additional hardware upgrades to all MySQL servers over the new few weeks.
We ask that any customers experiencing issues related to the speed of MySQL please contact support.
As always, thank you for your patience as work towards improving our platform.
Over the last 24 hours, I've noticed that the phpbb forum on my web site has started to work quite well. At most, it has taken a few seconds to load. Only once in the last 24 hours did I get a critical error. Prior to yesterday, it would sometimes take several minutes for a forum page to load... and critical errors were happening frequently.
I have to assume that PowWeb has started to roll out the upgrade to the mySQL machines that Joshua mentioned in his post. Yet, no one from PowWeb has posted any further information publicly... at least that I've seen. (These guys are truly HORRIBLE at public relations!)
Does anyone have any additional information on this? Are you all noticing that things involving mySQL are working better for you, too?
God, I hope I don't jinx it by stating publicly that PowWeb may have actually gotten it right this time!
What will really jinx it is not the posting but the digs at PowWeb! :) j/k
Also thanks for the larger font and color. It helps us older folks by not making us search for our reading glasses.
I noticed this post on October 1st from Joshuamc of the PowWeb staff:
MySQL Updated
We have just made an upgrade to one of the MySQL machines that we believe will greatly reduce any latency that some customers may have been experiencing.
Our plan is to test the upgrade for at least a week so that we can ensure that this is the best solution for increasing the speed of our MySQL platform. If everything goes well, we will be begin to roll out the additional hardware upgrades to all MySQL servers over the new few weeks.
We ask that any customers experiencing issues related to the speed of MySQL please contact support.
As always, thank you for your patience as work towards improving our platform.
Over the last 24 hours, I've noticed that the phpbb forum on my web site has started to work quite well. At most, it has taken a few seconds to load. Only once in the last 24 hours did I get a critical error. Prior to yesterday, it would sometimes take several minutes for a forum page to load... and critical errors were happening frequently.
I have to assume that PowWeb has started to roll out the upgrade to the mySQL machines that Joshua mentioned in his post. Yet, no one from PowWeb has posted any further information publicly... at least that I've seen. (These guys are truly HORRIBLE at public relations!)
Does anyone have any additional information on this? Are you all noticing that things involving mySQL are working better for you, too?
God, I hope I don't jinx it by stating publicly that PowWeb may have actually gotten it right this time!
WOW, I just posted, like two days ago, about me noticing what I thought could have been a change. Oh dear, by replying to your post, am I added a double jinx? :D
YvetteKuhns
10-15-07, 01:06 PM
I have to assume that PowWeb has started to roll out the upgrade to the mySQL machines that Joshua mentioned in his post. Yet, no one from PowWeb has posted any further information publicly... at least that I've seen. (These guys are truly HORRIBLE at public relations!)
Maybe PowWeb didn't want to make a post saying they fixed it, then jinx it or discover that the fix wasn't a permanent one.
zcomman
10-15-07, 09:03 PM
No, it has nothing to do with luck, after 3 mins of attempted loading the page failed. The sarcasm, and facetious remarks are obviously in ridicule of the reality. In fact I would probably go as far as to assume the level of true anger & frustration crossed the line into a rage that has given ginns a psychotic break down, turning a once proud individual into a blathering idiot.
My sympathies are with you ginns/all.
I think this summer Powweb has slipped from like the #4 host to something in double digits.
And slipping even further, it is just getting worse trying to get into our forum. We only have about 119 members and only a few of them online at one time. Right now taking at least 10 minutes to navigate through a couple of pages. This is just agravating.
If it's the site listed in his profile, it loaded very rapidly for me and all the links worked quickly.
ginns seems satisfied with the way his site is responding. Why insult them?
fifthgearonline
10-15-07, 10:45 PM
im on mysql 12 and my speed has TANKED. its starting to piss me off
and just to clarify, my main website loads super fast, but my zen photo gallery (which was kind of slow to begin with) hardly loads these days. It takes a good 5-7mins for it to come up.
Update: I just did a "Check table" on my tables and it said i needed to update them by runnign repair. So i did that and at least my photo albums load now....but it is still taking for ever
well, and the fact that, I think yesterday, someone using my forum said there was some massive "connection reset by peer (104 error)" going on, so it is not *really* fixed yet :D
it could have been one of those streches... which means, *maybe* they have done some work... like fixing 4 of 10 roads to release some strain for rush hour...
:shrugs:
To all,
I have come from the Psychotic work of geekdom and entered again, the real world to find that YES! my web site is still lightning fast after the MySql upgrade that occurred this summer. YES! I am a satisfied customer and YES! I like Powweb.
YES, YES and YES ...and by the way, I'm not being sarcastic here, I really am satisfied with the upgrade.
Yayster
10-20-07, 04:56 PM
My forum has been running horribly for months - however, the last few days it's been lightning fast and back to normal! I have no idea what's caused it but I hope it stays this way! *knocks wood*
It is what we all hope for :D
Just wondering, when it seems to actually go down, to confirm, are you also getting a 104 error? (connection reset by peer)
Croc Hunter
10-21-07, 03:01 AM
If you are experiencing fast or slow MySQL it will help if you can find and post your custsql-pow14 number. You can find it in MySQL MyAdmin.
I'm on custsql-pow01. I'm performing continious monitoring on it. It was really the hell on this server. It is now quite fast for about four days , although there are still some slowdown but only about once a day. Furthermore, these slowdowns are until now quite short.
At least, now the value for money ratio is acceptable for me.
My two cents.
Croc Hunter
10-21-07, 11:10 PM
The stuff I check most is on custsql-pow14. Not monitoring it or anything but it's been fast for about a week now whenever I hit it.
I added a dynamic graph to my database performance check script. It puts the data generated over the past month into perspective. It shows a 7 day graph by default. You can view between 1 and 30 days.
The graph caps the time to 10 seconds - I don't have the patience to wait more than 10 seconds for a page to display.
http://www.67knots.com/67KNOTS/log/dbcheck.php (http://www.67knots.com/67KNOTS/log/dbcheck.php)
With the continuous problems we had with outgoing email in the recent past, I moved all my email to google apps. No trouble all all. Now I've started to move my website contents elsewhere. The reason I had bought hosting service is that I hate online advertisements, and I would pay to keep my personal blog and related sites ad-free.
Now, I'm not sure if I can invest any more time in powweb or any other reasonably priced hosting service. The administration headaches are never ending and then there's these email troubles and the mysql troubles and what not. I'll wait on the sidelines until the hosting world thinks better of their paying customers.
For now, I have moved my blog to blogger.com, and am in the process of moving the picture gallery to picassa. This moving business is slow and time consuming, but I cannot wait for things to get fixed here, especially in the absense of any timeframe.
Croc Hunter
10-22-07, 09:35 AM
Wow poddu.. that is the most eloquent post I have read here for some time. And as a Powweb Moderator It saddens me to totally agree with you, but I must. Moving MySQL driven apps until Powweb 'fixes' email/mysql should not be a chore you are forced to do. I myself am very dismayed at the appauling slowness of a suitable timeline response let alone a fix to these issues. We have all screamed "fix it please", I guess we don't rank to high in the model. It's very self defeating.
troycawley
10-22-07, 03:02 PM
Wow poddu.. that is the most eloquent post I have read here for some time. And as a Powweb Moderator It saddens me to totally agree with you, but I must. Moving MySQL driven apps until Powweb 'fixes' email/mysql should not be a chore you are forced to do. I myself am very dismayed at the appauling slowness of a suitable timeline response let alone a fix to these issues. We have all screamed "fix it please", I guess we don't rank to high in the model. It's very self defeating.For what it's worth, I have recently had a similar experience with another host. No CMS installed, even. we have a few scripts running on their server. Each script only opens one connection and explicitly closes it at script end. Last night, the client got a "too many open connections" error. I thought it would be nice to be hosted on a shared server that was not so burdened with "plug-n-play' CMS monsters, etc. But apparently, the "Wordpress" phenomenon is plaguing shared servers everywhere.
I'm not leting powweb off the hook here, mind you. I'm still a paying customer and expect problems to be fixed (MySQL slowness is an admitted problem (http://forum.powweb.com/showthread.php?t=77086)).
rogerklam
10-22-07, 08:31 PM
Hi poddu,
My phpBB forum is also on server12. This is what powweb should do - a bench mark on each on their DB server. I have moved to another service provider but I do keep my accounts here. Their FTP is quite fast. Basically I can't rely on a single service provider and I need my forum running 24 hours 7 days up. I am hoping powweb can resolve the problem within the next 3 months, else I will completely move to another service provider. In a nutshell I do need a backup service provider.
Cheers
Roger
Well, again today I ran across a 104 error... however the site itself is otherwise working as it does, and does not seem slow except for that one time about... 1-2 hours ago.
custsql-pow04
I got this PM today:
The last two days have been the best in weeks, so all the PowWeb apologists are crowing that the problem has been fixed. Like, on other days it was so frightful it could not be used.
PS: as per forum policy, I cannot reveal the identity of sender, this is only one relevant line from the PM, and I have duly notified the sender of this post
The graph does show relatively good performane for Oct-20 and Oct-21. Unfortunately, the graph for 7 days does not show that the performance for these 2 days is a repetitive feature - I could call it "weekend bonanza". If you go back to the script (http://www.67knots.com/67KNOTS/log/dbcheck.php) and view the graph for 30 days, and take a step away from your screen when you look at it, you'll see a clear trend - the performance on weekends is way better compared to weekdays.
So I can say for sure that there has been no significant improvement, and there is definitely no signs of the problem having been fixed. The performance still remains frightful.
Maybe I can up this big bold notice on the top of my websites:
Do come back on a weekend for a better viewing experience!
Wow poddu.. that is the most eloquent post I have read here for some time. And as a Powweb Moderator It saddens me to totally agree with you, but I must. Moving MySQL driven apps until Powweb 'fixes' email/mysql should not be a chore you are forced to do. I myself am very dismayed at the appauling slowness of a suitable timeline response let alone a fix to these issues. We have all screamed "fix it please", I guess we don't rank to high in the model. It's very self defeating.
I completely agree with. And moreover, I feel bad for the countless other people I have referred here over the years, they too are having to live through this hell. My main concern at this point is not for those of us who know the reality and yet choose to stay, but for new clients who are lured in and then get caught with this nightmare.
*sigh*
OK, this started out as a "my site is working good" thread. If your site is working good, post here. If not, there are plenty of other threads for posting problems.
There is a noticeable improvement in the mysql performance on mysql12. I have been able to user my own mysql based websites without the frustration I have had to suppress for most of the last 3 months.
My database script also shows a tremendous improvement over the past day and a half (29-Oct 10am till 30-Oct 10pm).
(http://www.67knots.com/67KNOTS/log/dbcheck.php)
Whatever powweb engineers are doing, I hope they get this feedback, and keep up the good work.
bausman
10-31-07, 06:23 PM
poddu are you willing to share your script and how you went about it. I am on a different mysql but would like to be able to track the data like you do via the graph or table. I am not a noob but no expert either. Just curious.
BRAD
poddu are you willing to share your script and how you went about it. I am on a different mysql but would like to be able to track the data like you do via the graph or table. I am not a noob but no expert either. Just curious.
BRAD
You can download the files here: http://www.67knots.com/67KNOTS/log/dbcheck.tar
You will have to make changes in the file dbcheck.php - the log filename, the database parameters (mine are read from a config file), path to the graph script.
After weeks of pathetic performance, all four of my database websites are loading just great. I had almost given up on Powweb. I just hope it stays this way:)
Poddu thanks for the files I am starting to tweak them now.
poddu,
I have had to comment out the lines
/*if (!$result)
{
print "got into the !$result loop that will error out on line 169<br><br>";
mysqlerror($query);
print "got past the if result on line 169 <BR>";
} */
and then I think I have things working can you explain it or direct me to resource that may offer some guidance. If that that is great and I thank you for your script.
It is working at http://www.journeyseekers.com/templogs/dbcheck.php
Just wanted to update on my situation - my site has been wonderful for a couple of weeks now :D Things are great! I hope it stays this way as I was close to giving up too.
poddu,
I have had to comment out the lines
/*if (!$result)
{
You can remove the lines, I had them in there for debug.
And if you want the script to monitor the performance automatically, you will have to add it as a cronjob (from OPS). I have it running every 15 minutes.
Thanks for the help, this is giving me piece of mind and may help me track down some issues with powweb techs when I call to complain and assure them of the poor service.
Bravo to PowWeb for finally solving the mySQL problem!
If you haven't read the news, it's in the PowWeb blog. Click here (http://blog.powweb.com/2007/11/05/the-state-of-mysql-address/) to read it.
If you're still experiencing mySQL problems... hang in there. They're rolling out the fix one server at a time. They must have done the server that hosts my phpbb forum about a week ago... because ever since then, my forum has worked absolutely perfectly.
My forum hasn't worked well for most of this year... the worst problems occurred over the last few months... but for the last week my forum has worked absolutely perfectly, with almost instant response to every command. My forum members have been commenting all week about how well the forum works now.
I know that all of us PowWeb customers have the expectation that things should just work. PowWeb offers hosting services, they advertise 99% uptime, and mySQL services are all part of the package. We pay our money, and we expect it to work. For most of the year, a lot of us have been very disappointed with the service. Finally, however, it appears that happy days are here again and that the expectation that things will "just work" is being met.
As I said, if you're still experiencing mySQL slowness... hang in there. They haven't upgraded all the servers yet, but they're getting there. I think you will be happy with the results once they complete the upgrade across the entire platform.
My plans to switch to a different hosting company are now officially dead. Thank you PowWeb. :)
YvetteKuhns
11-9-07, 10:31 AM
I checked the websites I manage here and they all loaded very quickly. I see improvements. I also checked websites for people I have helped in the forum. After optimizing tables (and repairing if necessary), their databases ran better.
The 99% uptime was removed from the advertising a while back.
The 99% uptime was removed from the advertising a while back.
Maybe they don't claim "uptime" anymore, but they do claim "99.9% infrastructure availability".
If you don't believe me, take a look at the right side of this PowWeb page (http://www.powweb.com/powweb/overview.bml).
With mySQL working properly now, I've got no problem with them claiming the 99.9% thing. But I did have a real problem with it during the last few months when my site was, at times, taking more than a minute to fulfill a mySQL task.
But hey, that's all in the past. Things are working great now, at least on the server that my site is on.
And there have been threads regarding that statement and the way those computations are made.
But as long as things are working and customers are once again happy, it's Miller time. :D
If you haven't read the news, it's in the PowWeb blog. Click here (http://blog.powweb.com/2007/11/05/the-state-of-mysql-address/) to read it.
I see that the official powweb blog used the graph off my script (http://www.67knots.com/67KNOTS/log/dbcheck.php) to make the point about the performance before and after the HDD upgrades. I'm happy they did so, although just an acknowledgement of the same would have been much appreciated. But in contributing to the greater good, all's well that ends well.
YvetteKuhns
11-12-07, 11:12 AM
We will acknowledge you. Thanks! ;)
Be glad that they took your data seriously and acted on the information. Some web hosts don't understand or care.
Yup, acknowledged with reputation points. :D
YvetteKuhns
11-12-07, 11:46 AM
I also gave you rep points (19 of them)! :cool:
I did the same, but I'm only worth 5 points. I feel ashamed. :D
YvetteKuhns
11-12-07, 12:48 PM
Doc, you are worth more to me, but I have to spread points before giving you any more. Same with some others here. ;)
Wow - moved up in the world has poddu - last I looked it was 51
Poddu is going to pass me up soon. See what a little bit of helping can do? :D
Maybe, Doc, you should help more then :D
YvetteKuhns
11-12-07, 03:51 PM
You have to impress the people with the big reps or it will take a while. Some people have zero rep and try to give me points. I get none, but they do add thank you comments. Some have a rep of 5 and I get 1 point. They can add up after a while, I guess. Of course, poddu's rep climbed much faster.
I know I mentioned from the start that I don't like the rep points being used on forums, because it is a poor indicator of how helpful someone may be. Even the number of posts don't mean much. You really need to read the contents and make up your own mind. Anyone who contributes in a positive manner deserves praise.
Are we still on topic? Oops, we did it again.
You're right, Ian. Let me see. Would you like fries with that? There. That's some help. Where are my points? :D
Oh and my sites seem to be running fast due to the upgrade too.
joshuamc
11-12-07, 04:32 PM
I see that the official powweb blog used the graph off my script (http://www.67knots.com/67KNOTS/log/dbcheck.php) to make the point about the performance before and after the HDD upgrades. I'm happy they did so, although just an acknowledgement of the same would have been much appreciated. But in contributing to the greater good, all's well that ends well.
I added acknowledgement to the blog post along with some rep. points. ;)
YvetteKuhns
11-12-07, 05:12 PM
Joshua, you must remember your footnotes or your teacher will make you sit in the principal's office. :D
I'm just happy that mysql performance is now within acceptable limits.
I've worked in system software for 7 years, mostly with ADSL and FTTU platforms for one of the biggest telecom companies in Europe and I know how difficult it can be to diagnose a large and complex system involving complex proprietary exchange networking hardware and hundreds of thousands of lines of code, and then end up with something as mundane as the hard disc. Much appreciation to those at powweb who figured out the problem area.
I have now halted all my efforts at moving my blog and picture gallery to [removed]. Although I've already moved my entire blog to [removed] and had started moving my picture gallery to [removed], I can use the time in a much better way now. I have already removed the redirection from my blog to [removed] and back to my mysql based blog here.
I was hosting websites for 2 NGOs on my account. They have already decided to move away from here. One of them is already hosted on another service, and the other is slated to move later this month. Unfortunately, I am not in a position to even persuade them to reconsider, since they have found another donor for their new service. Hosting for the NGOs was my "good deed", and this is the only significant loss I have suffered due to the mysql performance issues. Fortunately, there are many avenues to make up for this loss.
And I appreciate the acknowledgement from those on the forum, and from powweb.
I left my performance tool (http://www.67knots.com/67KNOTS/log/dbcheck.php) running all this while. In the past 2 months, there's been relatively acceptable performance, queries returning in 1 to 2 seconds. Lately however, there's been an increase in the query response times.
The database performance graphs for the last week:
http://download.poddu.com/images/dbcheck.1week.png
And for the last month:
http://download.poddu.com/images/dbcheck.1month.png
vBulletin v3.6.0, Copyright ©2000-2009, Jelsoft Enterprises Ltd.