Friday 24 July 2009 2:12:14 am - 3 replies
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 |
---|
You must be logged in to post messages in this topic!
Timing: | Jan 30 2025 10:28:41 |
Script start | |
Timing: | Jan 30 2025 10:28:41 |
Module start 'layout' | |
Timing: | Jan 30 2025 10:28:41 |
Module start 'content' | |
Timing: | Jan 30 2025 10:28:41 |
Module end 'content' | |
Timing: | Jan 30 2025 10:28:41 |
Script end |
Total runtime | 0.0348 sec |
Peak memory usage | 4,096.0000 KB |
Database Queries | 3 |
Checkpoint | Start (sec) | Duration (sec) | Memory at start (KB) | Memory used (KB) |
---|---|---|---|---|
Script start | 0.0000 | 0.0063 | 588.1406 | 151.2109 |
Module start 'layout' | 0.0063 | 0.0057 | 739.3516 | 220.6875 |
Module start 'content' | 0.0120 | 0.0207 | 960.0391 | 1,006.1172 |
Module end 'content' | 0.0326 | 0.0021 | 1,966.1563 | 33.9922 |
Script end | 0.0348 | 2,000.1484 |
Accumulator | Duration (sec) | Duration (%) | Count | Average (sec) |
---|---|---|---|---|
Ini load | ||||
Load cache | 0.0028 | 8.0782 | 14 | 0.0002 |
Check MTime | 0.0011 | 3.1043 | 14 | 0.0001 |
Mysql Total | ||||
Database connection | 0.0018 | 5.2128 | 1 | 0.0018 |
Mysqli_queries | 0.0024 | 6.9408 | 3 | 0.0008 |
Looping result | 0.0000 | 0.0602 | 1 | 0.0000 |
Template Total | 0.0016 | 4.7 | 1 | 0.0016 |
Template load | 0.0012 | 3.4300 | 1 | 0.0012 |
Template processing | 0.0004 | 1.2284 | 1 | 0.0004 |
Override | ||||
Cache load | 0.0007 | 2.1359 | 1 | 0.0007 |
General | ||||
dbfile | 0.0003 | 0.9081 | 8 | 0.0000 |
String conversion | 0.0000 | 0.0260 | 4 | 0.0000 |
Note: percentages do not add up to 100% because some accumulators overlap |
Usage | Requested template | Template | Template loaded | Edit | Override |
---|---|---|---|---|---|
1 | print_pagelayout.tpl | <No override> | extension/community/design/community/templates/print_pagelayout.tpl | ||
Number of times templates used: 1 Number of unique templates used: 1 |
Time used to render debug report: 0.0001 secs