1
ali44
What's the maximun database for xoops?
  • 2005/3/2 4:50

  • ali44

  • Just popping in

  • Posts: 86

  • Since: 2004/5/24


My website online for 5 months, and the database has grown to staggering 60MB of database because of story and wfsection. With the trend, 3 years later I could end up with 4GB of database? Is this okies? Is there anything I should do because just backup the 60MB database took 20 minutes using myslqdump already. Any expert advice please?
Thank you

2
irmtfan
Re: What's the maximun database for xoops?
  • 2005/3/2 5:50

  • irmtfan

  • Module Developer

  • Posts: 3419

  • Since: 2003/12/7


i think database size is not very important and number of queries is always cause the problem ( over load server and ...)
also for backup your db read this faq:
Can I backup my database and site files automatically

3
rowdie
Re: What's the maximun database for xoops?
  • 2005/3/2 8:59

  • rowdie

  • Just can't stay away

  • Posts: 846

  • Since: 2004/7/21


wfsection has an admin preference called "database restore". Check if this is set to "yes". It stores the whole article in the database everytime you make a change. If you have it turned on, and you make lots of little changes, your database could become huge.

If that is where your problem is, you should have a huge xoopsPrefix_wfs_article_restore table. You can safely empty (not drop!) that table if you don't need to keep old copies of your wfsection articles.

I don't know the "story" module, they might have a similiar system as well.

Login

Who's Online

288 user(s) are online (246 user(s) are browsing Support Forums)


Members: 0


Guests: 288


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Nov 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits