Forums / Install & configuration / EzPublish DB : 100 mo

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

eZ debug

Timing: Jan 19 2025 09:01:33
Script start
Timing: Jan 19 2025 09:01:33
Module start 'content'
Timing: Jan 19 2025 09:01:34
Module end 'content'
Timing: Jan 19 2025 09:01:34
Script end

Main resources:

Total runtime0.8926 sec
Peak memory usage4,096.0000 KB
Database Queries202

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0067 588.9531180.8359
Module start 'content' 0.00670.7510 769.7891597.7109
Module end 'content' 0.75770.1347 1,367.5000337.4063
Script end 0.8925  1,704.9063 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00480.5406210.0002
Check MTime0.00210.2399210.0001
Mysql Total
Database connection0.00080.090510.0008
Mysqli_queries0.805790.26722020.0040
Looping result0.00240.27362000.0000
Template Total0.858596.220.4292
Template load0.00340.382620.0017
Template processing0.855095.790920.4275
Template load and register function0.00010.016710.0001
states
state_id_array0.00150.164810.0015
state_identifier_array0.00140.161120.0007
Override
Cache load0.00300.3385220.0001
Sytem overhead
Fetch class attribute can translate value0.00120.136940.0003
Fetch class attribute name0.00120.135770.0002
XML
Image XML parsing0.00130.147640.0003
class_abstraction
Instantiating content class attribute0.00000.001780.0000
General
dbfile0.01121.2545330.0003
String conversion0.00000.000730.0000
Note: percentages do not add up to 100% because some accumulators overlap

CSS/JS files loaded with "ezjscPacker" during request:

CacheTypePacklevelSourceFiles
CSS0extension/community/design/community/stylesheets/ext/jquery.autocomplete.css
extension/community_design/design/suncana/stylesheets/scrollbars.css
extension/community_design/design/suncana/stylesheets/tabs.css
extension/community_design/design/suncana/stylesheets/roadmap.css
extension/community_design/design/suncana/stylesheets/content.css
extension/community_design/design/suncana/stylesheets/star-rating.css
extension/community_design/design/suncana/stylesheets/syntax_and_custom_tags.css
extension/community_design/design/suncana/stylesheets/buttons.css
extension/community_design/design/suncana/stylesheets/tweetbox.css
extension/community_design/design/suncana/stylesheets/jquery.fancybox-1.3.4.css
extension/bcsmoothgallery/design/standard/stylesheets/magnific-popup.css
extension/sevenx/design/simple/stylesheets/star_rating.css
extension/sevenx/design/simple/stylesheets/libs/fontawesome/css/all.min.css
extension/sevenx/design/simple/stylesheets/main.v02.css
extension/sevenx/design/simple/stylesheets/main.v02.res.css
JS0extension/ezjscore/design/standard/lib/yui/3.17.2/build/yui/yui-min.js
extension/ezjscore/design/standard/javascript/jquery-3.7.0.min.js
extension/community_design/design/suncana/javascript/jquery.ui.core.min.js
extension/community_design/design/suncana/javascript/jquery.ui.widget.min.js
extension/community_design/design/suncana/javascript/jquery.easing.1.3.js
extension/community_design/design/suncana/javascript/jquery.ui.tabs.js
extension/community_design/design/suncana/javascript/jquery.hoverIntent.min.js
extension/community_design/design/suncana/javascript/jquery.popmenu.js
extension/community_design/design/suncana/javascript/jScrollPane.js
extension/community_design/design/suncana/javascript/jquery.mousewheel.js
extension/community_design/design/suncana/javascript/jquery.cycle.all.js
extension/sevenx/design/simple/javascript/jquery.scrollTo.js
extension/community_design/design/suncana/javascript/jquery.cookie.js
extension/community_design/design/suncana/javascript/ezstarrating_jquery.js
extension/community_design/design/suncana/javascript/jquery.initboxes.js
extension/community_design/design/suncana/javascript/app.js
extension/community_design/design/suncana/javascript/twitterwidget.js
extension/community_design/design/suncana/javascript/community.js
extension/community_design/design/suncana/javascript/roadmap.js
extension/community_design/design/suncana/javascript/ez.js
extension/community_design/design/suncana/javascript/ezshareevents.js
extension/sevenx/design/simple/javascript/main.js

Templates used to render the page:

UsageRequested templateTemplateTemplate loadedEditOverride
1node/view/full.tplfull/forum_topic.tplextension/sevenx/design/simple/override/templates/full/forum_topic.tplEdit templateOverride template
3content/datatype/view/ezimage.tpl<No override>extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tplEdit templateOverride template
5content/datatype/view/ezxmltext.tpl<No override>extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tplEdit templateOverride template
5content/datatype/view/ezxmltags/paragraph.tpl<No override>extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tplEdit templateOverride template
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/pagelayout.tplEdit templateOverride template
 Number of times templates used: 15
 Number of unique templates used: 5

Time used to render debug report: 0.0002 secs