I just saw my space usage on the host go from 4GB to over 11GB in a matter of days. I am not that prolific, so I asked my host so reported this:
"There are 6.6 GB of data on franchis_aafd DB most of them on table: mt_plugindata, I'm not sure what is that is about, but this is HUGE table size and you need to check this out and delete/empty it if not really needed."
I looked at the DB and it appears to be full of entries from MT Feeds Lite - the whole table appears to be full of these entries.
Should they be there? How do I get rid of them safely?
Running 5.04
Reported on Movable Type 5
Hi Michael,
On which project are you getting this issue?
It looks like you've played with the FeedsLite plugin and it is adding lots of content to your movable type installation.
I could check it for you and provide more advice.
Cheers,
Mihai
----------------------------------
Daily Movable Type Consultant
Web Development
Movable Type Consulting
Six Apart Partner
http://www.pro-it-service.com/
----------------------------------
Movable Type Demo
http://www.movabletypedemo.org/
----------------------------------
Open Melody Demo
http://www.openmelodydemo.org/
Mihai;
It is the franchise-info.ca site.
I do use plugin a great deal, we have a lot of rss feeds on the site. But, I haven't done anything to the plugin itself.
It looks to me that the plugin's cache is not being erased - is that possible?
Yes. We could suspect that!
And could we say that this issues started after you've upgraded that installation to v5.04?
Yes, that it happened at the same time. But, I also noticed that one of the websites may have also dumped several years of posts into their rss.
Using myphpadmin, could I simply delete all the cached entries in the db table? Or would this blow up something?
That's unlikely. However, you'll face two problems:
1) The delete statement will take a long time to selectively purge ~ 7GB of junk.
2) It may just reload all of that information the next time it updates (I don't know how feedslite works, but that would be a concern of mine).
Probably right - any other ideas about who to contact?
I believe Tim Appnel is the one who wrote it. He's on both the MTOS-dev and Melody mailing lists.
Thanks Mike, I will contact him about his problem. Might even upgrade to the full product.
Just as a follow-up, both Tim and Jun replied on the MTOS dev list.
They were in agreement that I should delete most of the entries in the db, gave me an sql command to try - which I will use after I back-up the db!
Ok, an update on this problem.
Backed up the db.
Deleted the table, 70,000 records
Crashed the db server, host really annoyed.
db corrupted due to either growth or deletion.
Site down for 3-4 hours, just when traffic from
an NBC documentary was to arrive.
Not good.
Jun, on MTOS dev list, suggested another idea, which
I will try over the weekend.
Host was great - 2m Hosting very accommodating.
MTOS dev list was great.
Just a really bad outcome!
(Site is up, with a number of plugins disabled.)
Here is how this ended:
Exported all the pages/entries on the blog using the export
function.
Created a new MT mysql db.
Imported the entries into the new db.
Looks like it worked.
This is a great example of the power of static publishing. The original db table was not working. Since the pages/entries/templates had already been published, I could export them. Then I could import them into a brand new db. I don't believe that this could have been done if the db was publishing dynamically.