Forums / Discussions / Tuning MySQL for eZ Publish

Friday 24 July 2009 2:12:14 am - 3 replies

» Read full tutorial

Introduction

This article explains how to tune a MySQL database for use with eZ Publish. MySQL is a database engine used by eZ Publish to store content. While other databases are supported by eZ Publish (such as PostgreSQL and Oracle), for performance reasons we recommend MySQL

Author Message

Jason Hen

Monday 22 February 2010 10:11:24 pm

Useful information,thanks!

Everybody may got some problems in daily life, like loan problems,
how to lose weight fast?which is the best travel agency? and baby care problems?
Google can help you to find out the answers.

kimi king

Friday 13 August 2010 6:32:43 am

Tiffany jewellery and super-quality service.
Both high quality jewelry and more discounted prices can assure you
<a href="http://www.ustiffanyshop.com">tiffany sale</a>
<a href="http://www.ustiffanyshop.com">cheap tiffany </a>
<a href="http://www.ustiffanyshop.com/shopping-tiffany-earrings-5.html">Tiffany Earrings</a>
<a href="http://www.ustiffanyshop.com/shopping-tiffany-necklaces-1.html">Tiffany Necklaces</a>
<a href="http://www.ustiffanyshop.com/shopping-tiffany-bracelets-3.html">Tiffany Bracelets</a>
<a href="http://www.ustiffanyshop.com/shopping-tiffany-rings-2.html">Tiffany Rings</a>
tiffany bangles, bracelets, earrings, necklaces, pendants, rings and accessories
<a href="http://www.jewelry2sale.com/">cartier jewelry</a>
<a href="http://www.jewelry2sale.com/">cartier jewellery</a>
<a href="http://www.jewelry2sale.com/">cartier jewelry sale</a>

kimi king

Friday 13 August 2010 6:33:19 am

Tiffany jewellery and super-quality service. Both high quality jewelry and more discounted prices can assure you [url=http://www.ustiffanyshop.com]tiffany sale[/url][url=http://www.ustiffanyshop.com]cheap tiffany [/url] [url=http://www.ustiffanyshop.com/shopping-tiffany-earrings-5.html]Tiffany Earrings[/url][url=http://www.ustiffanyshop.com/shopping-tiffany-necklaces-1.html]Tiffany Necklaces[/url][url=http://www.ustiffanyshop.com/shopping-tiffany-bracelets-3.html]Tiffany Bracelets[/url][url=http://www.ustiffanyshop.com/shopping-tiffany-rings-2.html]Tiffany Rings[/url]tiffany bangles, bracelets, earrings, necklaces, pendants, rings and accessories[url=http://www.jewelry2sale.com/]cartier jewelry[/url][url=http://www.jewelry2sale.com/]cartier jewellery[/url][url=http://www.jewelry2sale.com/]cartier jewelry sale[/url]

You must be logged in to post messages in this topic!

eZ debug

Timing: Jan 29 2025 23:50:35
Script start
Timing: Jan 29 2025 23:50:35
Module start 'content'
Timing: Jan 29 2025 23:50:35
Module end 'content'
Timing: Jan 29 2025 23:50:35
Script end

Main resources:

Total runtime0.1471 sec
Peak memory usage2,048.0000 KB
Database Queries141

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0052 587.9297180.8359
Module start 'content' 0.00520.0055 768.7656102.1563
Module end 'content' 0.01070.1363 870.9219519.6172
Script end 0.1471  1,390.5391 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00332.2632200.0002
Check MTime0.00130.8881200.0001
Mysql Total
Database connection0.00070.450010.0007
Mysqli_queries0.102469.56641410.0007
Looping result0.00120.79881390.0000
Template Total0.136092.410.1360
Template load0.00090.613110.0009
Template processing0.135191.804510.1351
Override
Cache load0.00060.418710.0006
Sytem overhead
Fetch class attribute can translate value0.00110.742710.0011
XML
Image XML parsing0.00030.203210.0003
General
dbfile0.00583.9633200.0003
String conversion0.00000.002630.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
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/pagelayout.tplEdit templateOverride template
 Number of times templates used: 1
 Number of unique templates used: 1

Time used to render debug report: 0.0001 secs