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.