EzPublish DB : 100 mo

Author Message

Nabil Alimi

Thursday 04 August 2005 4:03:02 am

Hi,

While performing a backup, I've noticed that the database of my site was 100 MBytes large. Is that "normal" ? The biggest part of it is the table <b>ezsearch_object_word_link</b> which is 85 MB large.

Is there a way to reduce it without disturbing Ezpublish functions ?

My blog : http://www.starnab.com/ezpublish / http://www.starnab.com/ / http://www.assiki-consulting.com
eZ Publish Freelance developper. Feel free to contact me +33 674 367 057
nabil at assiki d0t fr

Gabriel Ambuehl

Thursday 04 August 2005 5:14:27 am

ezsearch_object_word_link is only used for the search function. I think you could skip the data in that table if you're content with regenarating your search indexes after a reinstall of the backups.

However, try compressing your MySQL dump. It will likely be muuuch smaller after that. SQL statements can be compressed very well.

Visit http://triligon.org

Nabil Alimi

Friday 05 August 2005 3:58:56 am

But I can I freely truncate this table ? Won't it damage my installation ? I'd like to just to light my database.

My blog : http://www.starnab.com/ezpublish / http://www.starnab.com/ / http://www.assiki-consulting.com
eZ Publish Freelance developper. Feel free to contact me +33 674 367 057
nabil at assiki d0t fr

Gabriel Ambuehl

Friday 05 August 2005 4:50:24 am

Well if you truncate it, searching won't work until you regenerate search index.

Visit http://triligon.org

Xavier Dutoit

Friday 05 August 2005 7:03:01 am

Search indexes take a lot of space.

You can disable the search feature if you want to save space or try an external search engine (ez has plugs in). However, that's likely that it's going to take space too, but into another storage than your DB.

You can safely not backup this table, and in the case you have to restore, regenerate the index.

This being said, don't trust anyone on backup issues and you'd be wise to pratice restore before you really need it.

The last sentence is a definitive proof that I'm not wise, in case anyone wonders ;)

http://www.sydesy.com

Powered by eZ Publish™ CMS Open Source Web Content Management. Copyright © 1999-2014 eZ Systems AS (except where otherwise noted). All rights reserved.