[TYPO3-english] Re: Website slow when logging in - sleeping mysql the cause?
niels at pdonijmegen.nl
Sat Mar 2 21:52:22 CET 2013
Seems this is not caused by MySQL, I can change this with the PHP5-FPM settings:
I had this:
pm.max_children = 9
pm.start_servers = 3
pm.min_spare_servers = 2
pm.max_spare_servers = 3
pm.max_requests = 500
When I upped pm.max_children, the mysql queries in the processlist would also be at 21, instead of 10. So it seems that, when logging in to the backend (even with failed credentials) that the PHP session is not properly being closed afterwards. It stays open and simply holds the connection busy (even though it's not doing anything) until PHP times out.
I would like confirmation that this is expected behavior or not, so I know whether this is normal in Typo3 (and I can mark it as a bug) or whether something is wrong in my Typo3 config. Other pages (like running an apachebench against the typo3 main page) work fine even under high load. The same goes for the other CMSs I have tested on this system (Joomla/Wordpress/Drupal/Magento). Just typo3 that is giving some issues with the timeouts and not closing the PHP sessions properly after login attempts on the backend.
More information about the TYPO3-english