While running a report on a website I found that it wouldn't return anything but if I set a LIMIT 50 on the SQL query it worked fine.
It turned out that default_socket_timeout was set to 60 and the server was taking longer than this to return the result. Increasing this corrected the issue.
Comments