Showing posts with label MySQL. Show all posts
Showing posts with label MySQL. Show all posts

Cb is back in business

Sunday, December 28, 2008

Two weeks ago, I looked into why Cb was failing once more, as Cb was giving MySQL warnings, and the after that I cleaned up the list of active blogs. Several people reported that, for example, the Blue Obelisk RSS feed was down. Today, I found the cause of the lack of updates: the tags table had grown too much in size, and the Postgenomic.com software's SQL queries are not really optimised... So, our host (Dreamhost) renamed the table to fix the massive load on the MySQL server, causing the MySQL warnings, but also the lack of updates. I emptied the tags table, as the tags are not really crucial anyway, making the website show up nicely again, and hopefully making the update script not fail any more, either...

HELP! MySQL optimizations needed

Tuesday, January 15, 2008

Chemical blogspace has been closed down; that is, they seemed to have locked down access to the database. As you might have noticed, I have taken steps to reduce the problems with the database, but these were mere temporary fix ups. The real problem is the database design and, in particular, the SQL queries. These are too slow. Euan, the original author of the software, has already been looking into the problem he himself is encountering too, for postgenomic.com it is. But, I do not have time right now to fix those slow SQL queries :(

Therefore:

    HELP!
The source is available and email me for a dump of the database.

 
Chemical Elements - Made free by Free Blog,SEO Created by Diznews Online
by TNB