My web page is loading very slow. Its taking like 3 minutes to load. I thought it must be because of slow database query. But I could not found anything in the mysql process list. Then I checked php5-fpm slow query log and found following entries:
[30-Jun-2015 15:27:49] [pool www] pid 15717 script_filename = /var/www/sandbox/prateek/web/app.php [0x00007f5956872a78] createEntity() /var /www/sandbox/prateek/vendor/doctrine/lib/Doctrine/ORM/UnitOfWork.php:2081 [0x00007f5956871110] createEntity() /var /www/sandbox/prateek/vendor/doctrine/lib/Doctrine/ORM/Internal/Hydration/ SimpleObjectHydrator.php:129 [0x00007f5956870da8] _hydrateRow() /var /www/sandbox/prateek/vendor/doctrine/lib/Doctrine/ORM/Internal/Hydration/ SimpleObjectHydrator.php:43 [0x00007f5956870b38] _hydrateAll() /var /www/sandbox/prateek/vendor/doctrine/lib/Doctrine/ORM/Internal/Hydration/ AbstractHydrator.php:99 [0x00007f59568704e0] hydrateAll() /var /www/sandbox/prateek/vendor/doctrine/lib/Doctrine/ORM/Persisters/ BasicEntityPersister.php:705 [0x00007f59568702a0] loadAll() /var/www/sandbox/prateek/vendor/doctrine/lib/ Doctrine/ORM/EntityRepository.php:170 [0x00007f5956870180] findBy() /var/www/sandbox/prateek/vendor/doctrine/lib/ Doctrine/ORM/EntityRepository.php:156 [0x00007f595686fc88] findAll() /var/www/sandbox/prateek/vendor/symfony/src/ Symfony/Bridge/Doctrine/Form/ChoiceList/EntityChoiceList.php:148 [0x00007f595686fb20] load() /var/www/sandbox/prateek/vendor/symfony/src/ Symfony/Component/Form/Extension/Core/ChoiceList/ArrayChoiceList.php:46 [0x00007f595686f400] getChoices() /var /www/sandbox/prateek/vendor/symfony/src/Symfony/Component/Form/Extension/ Core/Type/ChoiceType.php:112 [0x00007f595686e9b0] buildView() /var /www/sandbox/prateek/vendor/symfony/src/Symfony/Component/Form/Form.php:917 [0x00007f595686df68] createView() /var /www/sandbox/prateek/vendor/symfony/src/Symfony/Component/Form/Form.php:927 [0x00007f595686d520] createView() /var /www/sandbox/prateek/vendor/symfony/src/Symfony/Component/Form/Form.php:927 [0x00007f595686c928] createView() /var/www/sandbox/prateek/src/PrintVenue/ OrderItemsBundle/Controller/OrderItemsAdminController.php:146 [0x00007fff9f779080] listAction() unknown:0 [0x00007f595686bbe8] call_user_func_array() /var /www/sandbox/prateek/vendor/symfony/src/Symfony/Component/HttpKernel/ HttpKernel.php:117 [0x00007f595686b9e0] handleRaw() /var /www/sandbox/prateek/vendor/symfony/src/Symfony/Component/HttpKernel/ HttpKernel.php:71 [0x00007f595686b5b8] handle() /var/www/sandbox/prateek/vendor/symfony/src/ Symfony/Bundle/FrameworkBundle/HttpKernel.php:47 [0x00007f595686b368] handle() /var /www/sandbox/prateek/app/bootstrap.php.cache:552 [0x00007f595686a068] handle() /var/www/sandbox/prateek/web/app.php:63 [30-Jun-2015 15:27:56] [pool www] pid 15718 script_filename = /var/www/sandbox/prateek/web/app.php [0x00007f5956872a70] createFromFormat() /var /www/sandbox/prateek/vendor/doctrine-dbal/lib/Doctrine/DBAL/Types/ DateTimeType.php:53 [0x00007f5956871110] convertToPHPValue() /var /www/sandbox/prateek/vendor/doctrine/lib/Doctrine/ORM/Internal/Hydration/ SimpleObjectHydrator.php:85 [0x00007f5956870da8] _hydrateRow() /var /www/sandbox/prateek/vendor/doctrine/lib/Doctrine/ORM/Internal/Hydration/ SimpleObjectHydrator.php:43 [0x00007f5956870b38] _hydrateAll() /var /www/sandbox/prateek/vendor/doctrine/lib/Doctrine/ORM/Internal/Hydration/ AbstractHydrator.php:99 [0x00007f59568704e0] hydrateAll() /var /www/sandbox/prateek/vendor/doctrine/lib/Doctrine/ORM/Persisters/ BasicEntityPersister.php:705 [0x00007f59568702a0] loadAll() /var/www/sandbox/prateek/vendor/doctrine/lib/ Doctrine/ORM/EntityRepository.php:170 [0x00007f5956870180] findBy() /var/www/sandbox/prateek/vendor/doctrine/lib/ Doctrine/ORM/EntityRepository.php:156 [0x00007f595686fc88] findAll() /var/www/sandbox/prateek/vendor/symfony/src/ Symfony/Bridge/Doctrine/Form/ChoiceList/EntityChoiceList.php:148 [0x00007f595686fb20] load() /var/www/sandbox/prateek/vendor/symfony/src/ Symfony/Component/Form/Extension/Core/ChoiceList/ArrayChoiceList.php:46 [0x00007f595686f400] getChoices() /var /www/sandbox/prateek/vendor/symfony/src/Symfony/Component/Form/Extension/ Core/Type/ChoiceType.php:112 [0x00007f595686e9b0] buildView() /var /www/sandbox/prateek/vendor/symfony/src/Symfony/Component/Form/Form.php:917 [0x00007f595686df68] createView() /var /www/sandbox/prateek/vendor/symfony/src/Symfony/Component/Form/Form.php:927 [0x00007f595686d520] createView() /var /www/sandbox/prateek/vendor/symfony/src/Symfony/Component/Form/Form.php:927 [0x00007f595686c928] createView() /var/www/sandbox/prateek/src/PrintVenue/ OrderItemsBundle/Controller/OrderItemsAdminController.php:146 [0x00007fff9f779080] listAction() unknown:0 [0x00007f595686bbe8] call_user_func_array() /var /www/sandbox/prateek/vendor/symfony/src/Symfony/Component/HttpKernel/ HttpKernel.php:117 [0x00007f595686b9e0] handleRaw() /var /www/sandbox/prateek/vendor/symfony/src/Symfony/Component/HttpKernel/ HttpKernel.php:71 [0x00007f595686b5b8] handle() /var/www/sandbox/prateek/vendor/symfony/src/ Symfony/Bundle/FrameworkBundle/HttpKernel.php:47 [0x00007f595686b368] handle() /var /www/sandbox/prateek/app/bootstrap.php.cache:552 [0x00007f595686a068] handle() /var/www/sandbox/prateek/web/app.php:63 While the php5-fpm log had following related entry: [30-Jun-2015 15:27:49] WARNING: [pool www] child 15717, script '/var/www/sandbox/prateek/web/app.php' (request: "GET /app.php") executing too slow (12.454455 sec), logging [30-Jun-2015 15:27:49] NOTICE: child 15717 stopped for tracing [30-Jun-2015 15:27:49] NOTICE: about to trace 15717 [30-Jun-2015 15:27:49] NOTICE: finished trace of 15717 [30-Jun-2015 15:27:56] WARNING: [pool www] child 15718, script '/var/www/sandbox/prateek/web/app.php' (request: "GET /app.php") executing too slow (12.867911 sec), logging [30-Jun-2015 15:27:56] NOTICE: child 15718 stopped for tracing [30-Jun-2015 15:27:56] NOTICE: about to trace 15718 [30-Jun-2015 15:27:56] NOTICE: finished trace of 15718 I don't get why events such as createEntity are taking so much time to execute. -- You received this message because you are subscribed to the Google Groups "doctrine-user" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/doctrine-user. For more options, visit https://groups.google.com/d/optout.
