MySql timeout when loading large region

[SamKr]

When loading a large region, a MySql command timeout may occur. In case of the Universal Campus, which can take up to 40 min, this prevents OpenSim from loading the first region oar.

I found a workaround:

Have XEngine temporarily disabled in OpenSim.ini (this is a speed fix)

and the important part:

Add the following to the config-include/MyWorld.ini connection string:

Default Command Timeout=3600;

The settings need to be reverted after loading, especially XEngine. Perhaps you could add a MySql timeout option in Configure.exe?

The system used was Ubuntu Server12.04 with Diva OpenSim r20232, using MySql 5.5.27 with an Intel i5-2410M processor and 4GB memory.

[diva]

Yes, loading heavy oars is known to be problematic, and the fix is exactly what you did -- turn off XEngine for loading the oar, then turn it on after.

[SamKr]

Just a note that the mysql modifications were crucial, shutting down XEngine alone wasn't enough. However I should add that this happened in a vmware virtual machine.