- Windows Server 2012
- PHP 5.3.29 with Wincache
- MySQL 5.6.26
- MODX Revolution 2.1.3-pl (I know)
Server has 8 2.2ghz cores and 12gb RAM. Typical use is 40-50% for both CPU and RAM.
The Manager typically takes 20 seconds to open Resources however occasionaly exceeds the max execution time of 30 seconds.
Other pages eg. Manage Users and Access Controls load in 1 second.
The website was migrated to a new server with nearly identical configuration to the original. The website ran without issue before being moved.
Details that may help identify the issue
PHP error log for timeout contains a number of errors:
[23-Mar-2016 17:11:59 UTC] PHP Fatal error: Maximum execution time of 30 seconds exceeded in C:\net\hosts\domain.co.uk\httpdocs\core\model\modx\modtemplatevar.class.php on line 492
#492 from modtemplatevar.class.php relates to render directories
if (!$file->isReadable() || !$file->isFile()) continue;
[23-Mar-2016 17:11:59 UTC] PHP Fatal error: Maximum execution time of 30 seconds exceeded in C:\net\hosts\domain.co.uk\httpdocs\core\xpdo\om\mysql\xpdoquery.class.php on line 57
#57 from xpdoquery.class.php is
$escape = !preg_match('/\bAS\b/i', $column) && !preg_match('/\./', $column) && !preg_match('/\(/', $column);
I don't think these help identify the issue though.
MySQL does not log any queries taking over 2 seconds to execute.
Does this indicate an issue on the PHP side?
Can anyone advise how to investigate further?