by I realize the past couple of weeks have heavily dealt with blog entries here about technical issues that concern my web hosting move from LunarPages to Network Solutions.
Forgive me for another entry in that vein, but I need to share an update with you about the slow database interaction between this blog and Network Solution’s implementation of MySQL (pronounced “My S-Q-L” and not “My Sequel” — “Sequel” is the name of an IBM database — so we shouldn’t confuse the two even though hardcore engineers love to slang it up with the “Sequel” mispronunciation; just because it’s convenient doesn’t mean it’s correct.
It is important to preserve the record of what has been happening here and that is why I have written so much about Network Solutions over the past two weeks. I gave them a star-making blog Category entry all their own and you can find it in my sidebar. Now you have a one-click way to easily read all my Network Solutions articles.
I was told my Network Solutions Site Confirm Seal post yesterday was widely read by folks at Network Solutions. Today is my two week hosting anniversary with Network Solutions and yesterday I received an email from Vinny Lee, Network Solutions Director of Product Development, who, in a friendly and wide-ranging email, specifically said this about our continued database problems:
I thought we should let you know as well that we are aware of the current MySQL performance and do not feel it is meeting our level of expectation as well. As a result, we have already begun work to increase MySQL capacity over the next 2 months. In the meantime, as a user of WordPress, I’ve heard of good results from a program called WP-Cache 2. I am not sure it will help with the admin side but if you think your site is not responding as quickly as it could, you might want to give it a try.
A friend previously suggested WP-Cache 2 on October 10, 2005 in a comment here, but I didn’t install it then because I wanted Network Solutions to see just how awful the load times were for this blog without any artificial caching solutions on my end.
After receiving Mr. Lee’s kind confessional yesterday, I decided to install the cache software but it made this blog even slower by a factor of two with my current web hosting setup, so I uninstalled the cache and decided to live with the pain of forever page loads for the next two months.
I don’t know why it will take two months for Network Solutions to solve their MySQL database problem, but at least they are now aware of the issue on a high level, and I no longer have to dread getting a daily morning email from Network Solutions engineering telling me my database issue is resolved when it is not and never was.
Please bear with me here as things slowly get fixed over the next couple of months. I have faith in Vinny and his determined promise to get MySQL working up to the standards we all expect. If this blog gets slow and unresponsive for you — yesterday I had to wait 71.238 seconds for a page to load — come back in five minutes and things should be a little better. In the meantime, we’ll start ramping up again familiar blog topics about the horehounds of humanity and the crises of living a moral life as we try to take our minds off how much slower our semiotic world is spinning.
I can see a series now
Coming next fall to ABC…
The next great drama…
One man… against the Internet.
You won’t believe his incredible saga.
Don’t miss “My So-Called Web Site”
Any night at any time we need to plug something in.
Hee 😀
I’m most surprised that wp-cache slowed the site. In theory, it will create a static copy of each page on the site on its first access (that might be slow) but then on following accesses it should be a lot faster. Hence, the first testing run whilst amassing static data in the cache may be a little slower.
How long was it running before it slowed everything up?
-Fruey
yes, your blog has been slow. more during the day than at night. i sure hope they improve it for you. if they don’t will you move to another host?
Hi David
Sorry I took a while to come back, but I’m quite busy right now as readers of my blog will no doubt know!
If indeed the cache refreshes after each comment – which would make sense – then it could be quite slow but the fact it was very slow indeed is interesting. I haven’t looked into it, maybe there are possible tweaks but I don’t know.
As far as hosts are concerned, I only really know the French hosting market but I think it’s often a tough call. My recent move has caused what appears to be slowdown from my perspective, but I am not sure. Best bet – budget permitting – is to rent a dedicated server. Then you can really get things to fly. I did a project setting up a dedicated server for a friend and super optimised his MySQL and PHP setup, and he runs a very popular forum on PHPBB which is notorious for a lot of DB calls. It seems to run very nicely, but it took some time to find the “sweet spot” with the MySQL DB. Some of that tuning I mentioned in a previous post, and particularly important were the following
– InnoDB tables (v. important) memory tuning for MySQL
– TurckMM cache for PHP
– Removing all unneeded apache modules
Hopefully this info might help you in your search for good webhosts or improvement from NetSol at least. I’m sorry to say that the site is painfully slow right now as I’m surfing.
-Fruey
Hi there,
Stumbled across your Blog while rsearching slowness issues with my implementation of PHPBB (www.phpbb.com) on a NetSol hosted site. Cutomer support had commented that it was a know issue to me when I called in which was a good sign. Honesty about the issue that reaches the front line support folks is always good. That aside, it does not seem any better. Did you have an update to this saga?
Thanks!