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