HELP! DB Calls BURYING my host's database server

Next topic

Author	Message
Matthew Knell	Wednesday 06 August 2003 8:58:58 am EzPublish's database calls, when used by more than one person at a time, are burying my host's MySQL server - is there any way to help this at all? Are their components that make DB calls that I can take out? Is there any way I can make this run more efficiently? I'm three days from launch, and I can't put this out there like this - it'll completely hose the site! Thanks for your help in advance -
Björn Dieding@xrow.de	Sunday 10 August 2003 2:32:58 pm Some of the calls are nessary... You can try to boost your system by activating the cache and using cached blocks... the phpA helps a lot too Looking for a new job? http://www.xrow.com/xrow-GmbH/Jobs Looking for hosting? http://hostingezpublish.com ----------------------------------------------------------------------------- GMT +01:00 Hannover, Germany Web: http://www.xrow.com/
Tony Wood	Monday 11 August 2003 1:11:12 am Matthew, What version are you using, have you made any specific extension? We have found that mysql accounts for about 3% of the system activity, so it should not cuase this problem. Ask you ISP for statistics as the what exactly is going worng. Some advice 1. Use persistant database connection 2. php accelerators will help, but it depends if your host will let you run then. Are you shared, CoLo, managed? 3. Add indexes to mySQL maybe they are missing I hope this helps Tony Tony Wood : twitter.com/tonywood Vision with Technology Experts in eZ Publish consulting & development Power to the Editor! Free eZ Training : http://www.VisionWT.com/training eZ Future Podcast : http://www.VisionWT.com/eZ-Future

Author

Message

Wednesday 06 August 2003 8:58:58 am

EzPublish's database calls, when used by more than one person at a time, are burying my host's MySQL server - is there any way to help this at all? Are their components that make DB calls that I can take out? Is there any way I can make this run more efficiently? I'm three days from launch, and I can't put this out there like this - it'll completely hose the site!

Thanks for your help in advance -

Björn Dieding@xrow.de

Sunday 10 August 2003 2:32:58 pm

Some of the calls are nessary... You can try to boost your system by activating the cache and using cached blocks... the phpA helps a lot too

Looking for a new job? http://www.xrow.com/xrow-GmbH/Jobs
Looking for hosting? http://hostingezpublish.com
-----------------------------------------------------------------------------
GMT +01:00 Hannover, Germany
Web: http://www.xrow.com/

Tony Wood

Monday 11 August 2003 1:11:12 am

Matthew,

What version are you using, have you made any specific extension?

We have found that mysql accounts for about 3% of the system activity, so it should not cuase this problem. Ask you ISP for statistics as the what exactly is going worng.

Some advice
1. Use persistant database connection
2. php accelerators will help, but it depends if your host will let you run then. Are you shared, CoLo, managed?
3. Add indexes to mySQL maybe they are missing

I hope this helps

Tony

Tony Wood : twitter.com/tonywood
Vision with Technology
Experts in eZ Publish consulting & development

Power to the Editor!

Free eZ Training : http://www.VisionWT.com/training
eZ Future Podcast : http://www.VisionWT.com/eZ-Future

eZ debug

Timing:	Jan 31 2025 01:24:34
Script start
Timing:	Jan 31 2025 01:24:34
Module start 'layout'
Timing:	Jan 31 2025 01:24:34
Module start 'content'
Timing:	Jan 31 2025 01:24:34
Module end 'content'
Timing:	Jan 31 2025 01:24:34
Script end

Main resources:

Total runtime	0.0275 sec
Peak memory usage	6,144.0000 KB
Database Queries	3

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0064	588.3828	151.2422
Module start 'layout'	0.0064	0.0042	739.6250	220.7500
Module start 'content'	0.0106	0.0153	960.3750	997.8672
Module end 'content'	0.0260	0.0015	1,958.2422	33.9922
Script end	0.0274		1,992.2344

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0031	11.1674	14	0.0002
Check MTime	0.0011	3.9501	14	0.0001
Mysql Total
Database connection	0.0013	4.6320	1	0.0013
Mysqli_queries	0.0026	9.4913	3	0.0009
Looping result	0.0000	0.0616	1	0.0000
Template Total	0.0011	3.9	1	0.0011
Template load	0.0008	3.0087	1	0.0008
Template processing	0.0002	0.8806	1	0.0002
Override
Cache load	0.0006	2.0301	1	0.0006
General
dbfile	0.0034	12.3291	8	0.0004
String conversion	0.0000	0.0295	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

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