You might want to check the execution time/cpu limits for both MySQL and the operating system on the production server. I don't delve deeply into MySQL and don't know what OS you're running, but this would be a good place to start. Even if it's not the problem, you should be aware of what these values are.