View Full Version : Any one else having slow loading mysql problems?
rsilva708
9-28-07, 03:14 PM
It seems like all morning, andy of my pages that need to connect to the database timeout before they can load. My regular html pages load fine.
My main problem site is redhotclix.com it is all php, and needs the database to run. An html page in the same directory redhotclix.com/donation.html is all html and doesn't need the DB loads up just fine.
Wander into the MySQL forums for extensive discussion on DB issues.
rogerklam
10-10-07, 05:02 PM
Hi,
Today it is working fine for my forum (phpBB). I just wonder whether the fix is in or I am just lucky today.
Cheers
Roger
My site hasn't worked properly any day in the past two months since they moved MySQL to the new address. I've complained repeatedly, it hasn't done any good. I keep getting replies from Support saying that they "can't replicate the problem." I can replicate it repeatedly simply by trying to open any page on my site that requires a MySQL connection to serve the content. Pages that don't have MySQL connections load instantly. Pages that do may require 2,3, 4 minutes to load. MySQL is D-E-A-D slow, and has been every day for the past two months.
It didn't use to be this way. MySQL connections used to be lightning fast. Now they either crawl or don't work at all.
And forget about logging in to MySQL through the Ops Control Panel. When I click the "Administer" link on the MySQL page in the Control Panel, it just sits there. The tables NEVER appear. I've only been able to get into the tables ONCE in the past eight weeks, even though I try to use it daily to perform routine maintenance on the data.
I've been using this MySQL database since 2003 with no problems -- that is, until they moved it in August 2007. Ever since then, it is exceedingly slow or non-operational.
YvetteKuhns
10-11-07, 04:10 PM
And forget about logging in to MySQL through the Ops Control Panel. When I click the "Administer" link on the MySQL page in the Control Panel, it just sits there. The tables NEVER appear. I've only been able to get into the tables ONCE in the past eight weeks, even though I try to use it daily to perform routine maintenance on the data.
Have you tried it recently since PowWeb went back to another version of phpmyadmin (http://forum.powweb.com/showthread.php?t=76892)?
I've been using this MySQL database since 2003 with no problems -- that is, until they moved it in August 2007. Ever since then, it is exceedingly slow or non-operational.
Do you have a backup of your website from before August 2007 to compare with a recent one? Did you try to check/repair/optimize the tables in your database since August? Do you use database stored sessions or text stored sessions? You may be able to improve your site from your end, but PowWeb still needs to make changes on their end, too.
rogerklam
10-11-07, 06:54 PM
Hi,
I am also using mysql database since 2003 with no problems until they upgrade the database server. I am also getting the same replies that my problem cannot be duplicated but I keep on telling them until the support finally admit the problem. I thought the problem is the size of data base but I did a fresh installation of my application using a different domain. The problem persist even with a small data base.
To be honest I do not think adding more hardware will solve the problem since my application is very slow during off peak hours (holidays, midnight, early in the morning). The worst part is we do not know what the hack is going on and whether there is a solution. For myself I can't wait indefinitely and I have to implement a backup application on another service provider. Of course my problem is to syn the database but at least I won't be losing any traffic or members in the future.
Cheers
Roger
I have experienced problems of late also. However, it would APPEAR that my problem is not as frequent as it use to be. I have no clue if this is due to actual work on things with powweb, or if my database just happens to be getting smaller traffic since they can see high traffic offenders and shut them down... and not everyone here is on the great grace of God... so those people may not be back :)
rogerklam
10-12-07, 09:58 PM
My site seems working fine today. So I am not switching to my backup forum and I hope it will continue in this way.
Cheers
Roger
Have you tried it recently since PowWeb went back to another version of phpmyadmin (http://forum.powweb.com/showthread.php?t=76892)?
Do you have a backup of your website from before August 2007 to compare with a recent one? Did you try to check/repair/optimize the tables in your database since August? Do you use database stored sessions or text stored sessions? You may be able to improve your site from your end, but PowWeb still needs to make changes on their end, too.
I use MySQL every day -- that is, until August 2007. Now most of the time it is inaccessible through the Control Panel. I insert new rows and delete outdated rows daily, and optimize at least weekly. I don't know the difference between "database stored sessions" and "text stored sessions," so I can't respond to that question. I insert new rows directly into the table via a custom Web form. The largest table has about 34,000 rows presently, which fluctuates up and down as outdated rows are deleted and new data is added. From what I have read, I was led to believe that the size of the table would not cause a significant degradation of service. Is this accurate?
I've contacted PowWeb 14 times in the past 8 weeks by phone, by e-mail, through Ops. I've been on the phone with them more in the past 5 weeks than the past 5 years. Something is NOT RIGHT here, and it happened when they upgraded in August. One of my other sites was right in the middle of their annual festival when it went down, and we couldn't get into the Volunteers table for several days to manage our workforce of 600+ volunteers, all of whom were stored in MySQL.
Prior to August 2007, MySQL connections were downright SPEEDY. I teach computer classes at the University level; my students were amazed when I would explain to them how MySQL works (and when you think about, what it compiles and serves in seconds is pretty impressive, at least when it works correctly).
This is trying my patience considerably. I just wish they would stop saying "we cannot replicate the problem" when I have replicated it numerous times daily for the past 8 weeks -- including TODAY!
Today it took me from 10 a.m. to 11:45 a.m. to add 97 new rows to the table. That's more than ONE MINUTE per row. I think that falls under the category of "excessively slow."
dmacminn
10-12-07, 10:29 PM
hmmmmm ... we don't need to replicate it
But, 95% of the time, by the time the ticket is reviewed, the initial problem has already been cleared ...
If a T1 agent can duplicate the issue, at the time or within moments of your contact (which, might actually be a number of hours from when you actually clicked "send" for an email ), then they can't escalate the ticket for additional handling ....
That's why they always seem to say "I can duplicate" or "we could not duplicate" your issue ...
And, its frustrating ...
since you have a grasp of the mechanics of MySQL ...
You can probably understand how a server under a high load or saturated with connections at a particular point actually starts to suffer a cascade failure in returning the results of queries ... which results in additional connections and repeat queries... and so and so on...
Perhaps you can also understand, that throwing additional CPU or RAM or buss speed might result in race conditions that make the elementary proposition of getting sufficient data throughput to get the %$^%# queries back out of the box ...
hmmm... if you do ... perhaps you can explain it to some of the rest! LOL
Suffice it to say, the Feng Shui of the MySQL system is "out of balance" at the moment ... as I've said before -- we have lots of metrics and diagnostics and great minds at MySQL AB involved ... so, hang tough ... we'll get thru it.
I sincerely appreciate your reply, and I mean that. Now I finally feel as if someone is aware that there really is a problem and is working on it. I didn't feel that way before.
This will give me the patience to persevere until you can fix it. In my mind, it's much better to write back and simply say "we know about this problem and we're working on it" than to say "we can't replicate the problem." To me, the latter implies that there is no problem.
Thanks again!
I sincerely appreciate your reply, and I mean that. Now I finally feel as if someone is aware that there really is a problem and is working on it. I didn't feel that way before.
This will give me the patience to persevere until you can fix it. In my mind, it's much better to write back and simply say "we know about this problem and we're working on it" than to say "we can't replicate the problem." To me, the latter implies that there is no problem.
Thanks again!
My thoughts exactly... I do not like being told things as if I was crazy... I like people I do business with to admit they have issues when they do. That actually helps me maintain my service with them, and the reason I am still with powweb.
YvetteKuhns
10-13-07, 02:27 PM
I agree with RBB's post. We understand that support will assume the problem is on the client side unless/until we/they can prove otherwise. It is frustrating when we are guilty until proven innocent.
It's that "my car makes a funny noise" story again where the car makes a noise when I drive it, but the mechanic never hears the noise when I take it for repairs. Then I get stuck many miles from home on a holiday weekend and can't get a tow! (Yes, this really happened.)
So, I am having loading problems for my Gallery2 installation which uses a MySQL database. Sometimes I can access the gallery, but ususally I get a "The document contains no data". This started recently (ie, within the past two weeks probably). I have seen some comments about optimizing the database, so how does one go about this. I have opened the database from OPS (Administer), but the resulting mysqladmin/phpMyAdmin page is not giving me any clues.
Well, as I now look at the main MySQL forum, I see a pinned note on optimizing. http://forums.powweb.com/showthread.php?t=76604
Thanks for making that note YvetteKuhns! It sped things up for me a lot. I had to repair a lot of my database.
Just to followup:
This morning I inserted 733 new rows into my table in 33 minutes. :cool:
On Friday it took 105 minutes to enter 97 rows. You Do The Math!
I hope this is a permanent fix, because it is truly exciting when you've got a lot of data entry to do and can actually get it done! Thanks for your efforts to get this problem fixed!!
dmacminn
10-14-07, 10:38 AM
Really, Yvette ... even your neighbours tell us your car does make a strange noise ... but they could just be hearing your yelling about the noise they didn't find and fix yet! ... LOL
About two weeks ago, I had this "Aha!" moment of honeymoon bliss, where everything was working as expected. I could get into the database and do searches or look at table data, my site was loading with no problems, etc. That dream was quickly quashed, probably as a result of me making an optimistic posting.
I wonder if PowWeb's new tactic is to rotate speedy blissful problem-free service to everyone, so we all get a little taste of how perfect it could be, in the hopes that we 'hang on' a bit longer.
Why am I still here? I can't get into my database to back it up, and my site load time is so sucky I can't do it from my forum admin board either. It feels like extortion, kind of... they get my money and have my data. And I can't leave until I get my data, which they know. So I'm stuck.
zcomman
10-15-07, 07:56 AM
I have called many, many times about the slowness of our club website which is not very big compared to most of you all. But get complaints from club members who can't get in or takes forever to navigate through the forum. At least 10 times I have talked to customer service who can replacate the issue only to be told by tech support that they can not. Never had this problem before their upgrade.
If you're using a MySql database then you will encounter difficulties - support know this, see a number of the posts by Dwight and others.
YvetteKuhns
10-15-07, 10:30 AM
Octane, I think you and/or someone else asked me how often you need to check/optimize your database. It is like defragmenting your hard drive. How often is it used? The more you use it, the more often you should do this.
Maintain your database or hard drive as you would maintain your car. You check your oil every 3000 miles. That was once a year for me, but almost a month for my dad or my husband!
If you wait until you have a problem, you may need to make repairs and sometimes the repairs can't be done with just a click of the Repair link.
But get complaints from club members who can't get in or takes forever to navigate through the forum.
Is this ALL of the time? Or is this only at peak hours? Of course, if it doesn't work when you want to use it, it doesn't work for you. Knowing if the site NEVER works helps to know if the site has other problems and not just server problems.
I suspect that your forum just gets more than ten people at one time and that is when it is slow. I used to host a forum here and went through the same thing. The forums that do work here don't have too many database connections or forum members at one time.
S-L-O-W today. D-E-A-D S-L-O-W.
What a difference a day makes.
YvetteKuhns
10-16-07, 03:06 PM
OPS is slow, too.
I have found a little fix for my slow vbuletting Forum.
I went into the AdminCP and changed following.
* Nix Server load/limit .
By default it was set to 0 , I have now set it to 5 and low and behold, my forum is so much faster * hope I have not jinxed it now *
I also deleted old messages and only keep messages that are not older then 2 weeks.
I will keep on pruning my Forum, at least I now have a quite fast forum.
Petra
Maintain your database or hard drive
I have never maintained my DB:o , so I would not know how to go about it but want to do it.
Petra
YvetteKuhns
10-19-07, 08:54 AM
I have never maintained my DB , so I would not know how to go about it but want to do it.
Check, repair or optimize your database in phpmyadmin (http://forum.powweb.com/showthread.php?t=76604). Actually view database tables and remove spam or old/unused data. You can remove data through your script admin. You can prevent spam with modules/add-ons for your CMS.
rogerklam
10-19-07, 12:52 PM
Hi,
It has been a very difficult decision for me to switch my forum to the backup. I have been waiting for quite a while but the problem is getting worse. Today I did a switch and if the performance issue is being solved, I will switch back. I am a long term customers with 3 domains with them but I am still keeping the photo gallery here. All the db applications, I will move temporary. For myself I don't mind paying more for a stable services. I thank the Co. for a stable service that I had for the last few years and wish they can maintain the service. The problem I think is not related to the size of your data base since I have a freshly installation of phpBB for one of my domains.
Cheers
Roger
My forum actually got 3 500 error... that was a first, for once, that I did not cause the 500 error to happen (since the times in the past, due to an error in my .htaccess, I caused the 500 err). The strange thing is, it was only the three times, and for once, every other time was NOT slow. Go figure :)
today i made a ticket.
its already 4th time in a few months that the site is verry slow loading.
its takes about 40 and 130 seconds to load. this started after 1novenber,and no change at all.
this becomes verry anoying now, because i dont had this problem before. now i do.
if the problem has not been fixed soon, i will move from powweb.
this issue takes to long for fixing. if i see dates here.:confused: over more than 8months whit the same problem.
regards
and hope this fixed soon. if not ciaoooo powweb.
I have been having SQL probs for the last week with my forum... contacted support and as usual there reply was "everything seems fine when we look at your site".....
Previous to this my forum had been running great for the last month, prior to that was the same old story with slow or not loading SQL problems...
YvetteKuhns
11-6-07, 05:10 PM
The slowness of MySQL isn't just noticeable as we visit sites. One of my clients has experienced a large decline in visits while her search engine ranking has not declined. Last week has been the worst for us on (the server formerly known as) mysql07.
Croc Hunter
11-7-07, 12:10 AM
Exactly Yvette, one site I administer here (which is html with some SSI and a forum) traffic has dropped to less than 1/3rd of what it was back in April. It takes alot of work to build a high ranking popular site. Only to have your host ruin all your efforts just shouldn't ever happen. April was six months ago and the numbers just keep getting worse.
Once again my forums are not responding... www.e30owners.com/forums/
YvetteKuhns
11-7-07, 07:09 PM
traffic has dropped to less than 1/3rd of what it was
I see a big decrease in visitors for the sites that are php/mysql driven. Judy said she noticed the same number you quoted! I couldn't believe it!
Kansai Peter
11-7-07, 10:43 PM
I just launched a discussion board on my site today, using SMF, so in theory things should be fast, but they are slow. (We are thinking of moving our organization's site to Powweb and want to see how bulletin boards work. This is a test.) My question is this, why is my site so slow, but these boards are fast? Apologies for what is possibly a dumb question, I am just wondering.
These boards are not hosted on the customer servers.
Kansai Peter
11-8-07, 01:17 AM
Aha. That would explain things. Thanks. But I did just noticed that the boards on my site are very quick now, so not sure why the change. Perhaps it just depends on the time of day, and it is the middle of the night in America.
It could be that and also PowWeb is making changes to servers. Upgrading drives, I think I read somewhere on the board.
after two days , no respons on my ticket.
hello
i'm just a new client for a few months. and i know there was some issue whit website's are loading verry slow.
but now is this for the 4th time in a few months my website loading verry slow.
this becomes verry annoying, and also for members who working on my site as well.
Whats happening ???
i see also that the sql server is from bizland.net and i hosted by powweb. bizland has the same interface like powweb , just another name and colors. ???
can this sql problem been fixed soon, are will it stay for the next 2 years i host here.?
i like open in january my website, so i hope this problem has been fixed.
regards sanshay
sorry for my bad english.
maybe i should take an account on <<competitor>>:confused:
You won't get a response if the reason for the slowness you're having is the MySql problems. There's nothing you or the first level support can do that isn't being done already.
We don't mention competitor hosting companies on these forums, however, the competitor you named, is part of the same group - so could easily have the same issues.
To aviod slow sites from Europe it is often best to host in Europe if the majority of your audience (or expected audience) is from Europe.
You won't get a response if the reason for the slowness you're having is the MySql problems. There's nothing you or the first level support can do that isn't being done already.
We don't mention competitor hosting companies on these forums, however, the competitor you named, is part of the same group - so could easily have the same issues.
To aviod slow sites from Europe it is often best to host in Europe if the majority of your audience (or expected audience) is from Europe.
its a part of the same group !!! and the sql servers whe host by powweb is from the competitor. so is this problem from the competitor and not powweb !!! so why different company's whit the same group of servers? whe deppending on the status from the competitor and what is the status of powweb ?
site's from europe to host in europe i not agree. has nothing to do about it.
i have 5 different hosting accounts in different country's, the speed loading is the speed of the server and bandwitch from IPS.
i have a 1800-2200kbps down and upstream. also powweb told me before there was no difference.
but next year i starting to buy my own servers, because the price in europe for hosting is to high.
regards
The competitor is part of the same group - but the naming conventions used sometimes mix things up. Powweb is part of a big group - It has it's own servers but, the naming of them sometimes uses names of competitor (same group) internally. Error messages then indicate the competitor name. It's the way it is, I won't justify it.
Empirically, when the US wakes up, access to US sites are slower from the UK than European sites. You can agree or disagree all you want - and Powweb can say what they want, but it's observed frequently enough to be true for me and those in the UK.
Your upstream/downstream speed isn't the only factor in the speed of access to sites. Ask those that live in the US California area if they noticed a difference in speed of Powweb sites when they moved servers to Boston - they did and the complaints in here demonstrate that. Location is important, as is the route that the traffic takes. Who is the provider (in Europe and in the US - for Powweb) also has impact on speed. The speed and load on servers also make a difference.
YvetteKuhns
11-9-07, 10:33 AM
See the PowWeb blog or this thread (http://forum.powweb.com/showthread.php?t=77434) to see announcement about the MySQL problem. Most of the servers are running faster.
vBulletin v3.6.0, Copyright ©2000-2009, Jelsoft Enterprises Ltd.