Welcome to Wopular's coverage of Database. Wopular aggregates news headlines from the top newspapers and news sources. To the right are articles about Database that have been featured on main sections of the site.
Below are topics about Database. (Click on "all" to view all articles related to the topic, including articles NOT about Database.
Click here to search news sites, aggregators, and blogs as well as videos, photos, and websites about Database.
A while back, My ISP told me my backups took half a day to complete, which is too long. If anything goes wrong during that period, the process would have to start all over again, which happened quite often.
The customer rep told me that my server had too many files, and even though they didn’t take up much disk space when added up, the process of copying each one of them takes a lot of time.
The site crashed yesterday morning at around 9am, although it’s hardly noticable until a couple hours later. I didn’t notice it until I started picking stories to feature on the homepage. Whenever i tried to feature an article, it would stop the site from loading up.
From that, I knew that the MySQL database must be checking for corrupt tables. And if it’s doing that, a crash must have occurred. Checking out stats at my ISP confirmed that the server was restarted at 9am.
In my continued efforts to make the site run faster, I’ve set my sights on query caching on MySQL. I think query caching is turned on by default when you install MySQL. At least for me, I didn’t have to do anything. I notice it’s been working because whenever I run a query a second time, it’s always significantly faster.
You may have noticed that Wopular was down for most of Friday. The database crashed and one of the tables was corrupted. It just so happened that it was the most important one. It stored all of the headlines and teasers. Yeah, why did it had to be that table. I tried repairing it, which usually was't too bad, except this time, it was.
Bookmark or Share
