Symfony 2 Doctrine memory usage

Question

I'm creating a query with an entity repository and it seems to have memory leaks.

In my Entity repository class:

echo 'mem 1 : ' . (memory_get_usage()/1024/1024) . "<br />\n";
$query = $this->createQueryBuilder('a')->select('a','b','c','...');
echo 'mem 2 : ' . (memory_get_usage()/1024/1024) . "<br />\n";
$r = $query->getQuery()->getResult();
echo 'mem 3 : ' . (memory_get_usage()/1024/1024) . "<br />\n";
$this->clear(true);
$query->getQuery()->free(true);
unset($r);
echo 'mem 4 : ' . (memory_get_usage()/1024/1024) . "<br />\n";

Output:

mem 1 : 5.0805282592773
mem 2 : 5.0998611450195
mem 3 : 91.49528503418
mem 4 : 77.939567565918

Why is the memory not back to the initial size (5 MB) after freeing the memory?

And only pass from 91 to 77.

Just added unset($query) next to the other unset : $this->clear(true); $query->getQuery()->free(true); unset($query); unset($r); but it's the same : mem 4 : 77.849983215332 — Seb33300
– Seb33300, Commented Mar 6, 2013 at 12:27
I think it has something to do with sqllogger enabled in debug mode stackoverflow.com/a/10913115/842075 — Molecular Man
– Molecular Man, Commented Mar 6, 2013 at 14:03

james_t · Accepted Answer · 2013-03-06 16:25:48Z

5

Doctrine caches certain aspects of Entities it has loaded. Use

$em->clear();

to detach all objects from the current entity manager.

answered Mar 6, 2013 at 16:25

james_t

2,7331 gold badge18 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Seb33300 Over a year ago

With this, the memory is down to 66 mb (mem 4).

james_t Over a year ago

The additional memory is the result of the $r variable. unset() does not guarantee immediate garbage collection, so the process will retain that memory until the garbage collector has freed it or the process has terminated. See stackoverflow.com/questions/584960/… for more detail.

Collectives™ on Stack Overflow

Symfony 2 Doctrine memory usage

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related