Extreme memory consumption of Sugar CRM

[Sukale]

Hi,

We currently run SugarCRM community edition in the latest stable release. The memory_limit in my php.ini is currently set to 360MB (standard is 16MB). But we continue to get errors like this:

PHP Fatal error: Out of memory (allocated 786432) (tried to allocate
24576 bytes) in ...CRM\include\utils\mvc_utils.php(48) : eval()'d code on line 1

How many memory is needed to get rid of this error messages? Are there any experiences? We are using the system currently with only 3 persons...

Is this a general problem of SugarCRM or is it maybe just a problem of the community edition?

Thanks for any support in advance

Lars

[mipapage]

We're using the pro edition and getting memory errors on calls. We have 40 users running with 128M and they get them. I upped the calls module to 192M and they would still get them. Frustrating? Yes. When this happens the system is unusable and makes me wish we used another CRM. We have 16G of ram to allocate, but with 5 dedicated to mySQL we can only give users so much. I'm surprised and saddened to hear that you have it with 360M.

I've posted tickets in our case tracker - as we are pro - and those tickets seem to have baffled the support people as they've gone well outside of their time to respond - by a week. Grr...

Judging by their silence, I could guess that its a general problem for Sugar. I cannot believe you are getting it with 3 users...

[kuske]

Which Operating System and which Webserver do you use?
There is a known problem of apache on 32 bit machines running Windows and apache web server.

[clint]

I haven't heard of this problem before.

What version of Sugar are you running?

What version of web server and php are you using?

How much RAM do you have on the machine?

Are the web server and the db server on the same machine?

[mipapage]

This isn't my thread (so please don't handle my issue), but I'll provide our data if it helps:
Sugar: 5.0b
Apache: 2.0
PHP: 5.25
mySQL: 5.0
64-bit OS with 16Gig ram
Dual quad core Xeon
We're running xcache, but this seems to be unrelated to the issue.
mySQL and Sugar on the same machine. mySQL has 5gigs for itself, leaving roughly 11 for the web server.
40 Users, about 500,000 calls in an innoDB table. We don't use teams, so rows examined can get pretty large at this point in a given query.

[Sukale]

Thanks everybody for the fast replys!

Here are the data you have requested:

SugarCRM Version 5.0.0b (Build 3150)
PHP 5.2.2
Apache 2.2.4 (Win32) mod_ssl/2.2.4
MySQL 5.0.41

Host:
Windows 2000 Prof / SP4
Pentium 4, 3.2 GHz
780 MB RAM

Webserver and DB are on the same machine.

Apache.exe currently uses about 2MB of RAM (in normal state).

Regards

Lars

[clint]

At this point we start getting into discussion about how your Apache server is configured. The number of servers that can be spawned at any given time governs both the perceived performance by the end user as well as the amount of memory consumed. Your Apache configuration could be part of the problem.

Here is a Wiki article that suggest a common configuration for your Apache server. However we are getting out of my depth. I will have one of our engineers who knows more about this topic chime in.

[mipapage]

At this point we start getting into discussion about how your Apache server is configured.

For the record our apache config, together with the overhead for other server processes and max PHP use does not max out our ram. We have had one of our tickets responded to and we're trying something, I'll post back here if it works.

[Sukale]

Hi everybody,

are there any news about the problem?

Regards

Lars

[mipapage]

We have no news, but I have found that in some cases we have upped our memory use to the point that the max_execution_time (php) gets reached before memory allocation becomes an issue, so we up either until some of the issues go away.

This doesn't handle all of the issues and at the moment we're running 768M on reports and a 60 second exec time and still get errors.

We now run 120M per user on PHP, and consume roughly 13.5G of ram to get Sugar to perform decently (I say decent not counting the white screen errors).