[Opensim-users] OpenSim Mesh Testing, LOD and MySQL max_allowed_packet

[Ai Austin]

I was able to adjust the viewer debug setting RenderVolumeLODFactor 
and adjust it from the default 1.0 to 4.0 and the vehicle renders 
reasonably now as the view distance gets progressively greater.

Some guidance on LOD settings and rendering can be seen at 
http://blog.nalates.net/2011/05/24/revised-sl-mesh-arriving/

  But relatively large sub meshes were dropping out at far too short 
a distance, and meshes uploaded in an earlier 2.7.2 viewer looked 
fine.. so something has altered.

I appreciate this thread might be better reported under LL/Second 
Life viewer forums and JIRA.  But if anyone else has thoughts or 
observations here on the OpenSim list, please add your notes.


  At 10:58 21/07/2011, Ai Austin wrote:
>I have been doing some more testing of meshes into OpenSim (r/16234 
>from a day or two ago, so quite recent on the server side).
>
>I have been using various viewers for upload, and for viewing the 
>meshes in my tests.
>
>With some large Collada meshes, I noticed some errors saying that 
>the asset was not benign stored due to the limit on 
>max_allowed_packet.. which it seems by default for the server side 
>is 1MB in MySQL. Funnily though the meshes that said they failed to 
>store did seem to persist in world and in inventory, and could be 
>rezzed out of inventory even afyer the OpenSim.exe error was 
>indicated.  A bit odd I thought.  I upped the max_allowed_packet to 
>16MB and the meshes were stored fine.  The answer is to add 
>max_allowed_packet=16M into the [mysqld] section of your MySQL 
>config .ini file.
>
>[mysqld]
>max_allowed_packet
>
>See this for information, where it explicitly indicates that the 
>server size is set low at 1MB and you may need to increase it if you 
>work with large BLOBS, which I assume Collada content is stored in...
>
>      http://dev.mysql.com/doc/refman/5.5/en/packet-too-large.html
>
>The other thing I have noticed is that there is a change in the 
>rendering in world of my complex meshes between LL 2.7.2 and 2.7.4 
>viewers.  For ones UPLOADED in 2.7.2 (or Kirstens S21 RC1) on 
>OpenSim r/16234 they render fine in both 2.7.2 and 2.7.4 viewers 
>with LOD handled well as you zoom out.  BUT, for ones uploaded in LL 
>2.7.4 (exactly the same model, and exactly the same OpenASim.exe 
>server), the LOD is handled poorly, and soe quite large parts of the 
>meshes disappear even when only zooming out 30-60 metres.  It looks 
>bad.  See the three progressively more zoomed out examples here for 
>the LL 2.7.4 uploaded mesh, whereeas the vehicle looks the same with 
>all parts intact at all three zoom distances with a LL 2.7.2 viewer 
>uploaded mesh
>
>http://www.aiai.ed.ac.uk/~bat/EXPORT/3D/SC-Images-2011-07-19/Supercar-Mesh-Test-Zoom-1.jpg
>http://www.aiai.ed.ac.uk/~bat/EXPORT/3D/SC-Images-2011-07-19/Supercar-Mesh-Test-Zoom-2.jpg
>http://www.aiai.ed.ac.uk/~bat/EXPORT/3D/SC-Images-2011-07-19/Supercar-Mesh-Test-Zoom-3.jpg
>
>Anyone else have any experience to report on mesh testing on OpenSim 
>0.7.2 dev?