Database Large

By QBlog in Blog News

My Database is large. Too large for my host. That's why it was shut down over the last couple of days. It's been restored but I will have to do some things to be sure it doesn't bloat again and to reduce its current size.

Thanks for your patience.

UPDATE: Tracked down the source of the large DataBase problem with the help of my friend from Canada. Here's what happened, in a nutshell.

There are around 15,000 comments on all my blogs with nearly 14,000 on the Quixtar BLOG. That in itself isn't an issue. It creates a large DataBase but nothing unmanageable. However, Movable Type 3.2 (which is what I use to power this blog) has a "junk" folder where most of my spam comments are automatically dumped. The spam comments stay in the "junk" folder for a period of time and then are automatically deleted.

The "junk" folder had nearly 22,000 spam comments all accumulated over the past 45 days. That is what beefed up my DataBase. After removing the spam comments the DataBase was reduced by nearly one third its original size.

Some other optimization was done but mainly the junk comments were the problem. Now I have them deleted after five days instead of 45.

Comments (10) TrackBack (0)

Comments

So much for Tony's claim that this blog would die without his rantings!

Posted by: bruce | January 11, 2006 9:31 PM

It may be his comments going in spam making Database large :o

Posted by: Imran | January 11, 2006 10:28 PM

I wish my database was too large for my host ;)

Posted by: ex-dd | January 12, 2006 4:19 AM

Ex-DD,

you may wish that now but it's not a fun thing to be honest. One issue with a large database is that I'm pretty much unable to host with the cheapies. No $4.95 per month hosting for me. As traffic increases, so do server needs. I essentially got... uh... asked to leave my old host because the traffic was too much of a strain. The migration lasted almost a month and was not fun. It was Imran saved my rear on that.

Anyway, I'm not complaining at all. Just saying that it's sometimes a major headache.

Posted by: Eric J | January 12, 2006 5:05 AM

Hey Q,
I understand and definately appreciate teh site you have. It is a great outlet for me.
I was really throwing a sexual inuendo there.
Keep up the good work.

Posted by: ex-dd | January 12, 2006 2:38 PM

ex-dd, I got it. You killed me :D I love IT related inuendos ;)

Posted by: Imran | January 12, 2006 3:56 PM

It would appear that ex-dd has database envy.

Posted by: Scott N | January 12, 2006 5:00 PM

do they make viagra for a hard drive?

Posted by: ex-dd | January 12, 2006 10:17 PM

No, viagra is for 3.25" floppies.

Posted by: Scott N | January 12, 2006 11:44 PM

LMAO at the floppies

Posted by: ex-dd | January 13, 2006 3:24 AM