Great info, Ai - it sounds like meshes can be extremely large assets.
I'm guessing the asset you uploaded probably still worked because it was put in
the local server asset cache.
Unfortunately, it sounds like lifting this mysql might have to be common advice, short of providing an option which
persists assets in the filesystem rather than as blobs in the database.
There is a patch from kcozens which did some work on this topic (http://opensimulator.org/mantis/view.php?id=5429) but
this has not progressed much yet.
On 21/07/11 10:58, 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?
_______________________________________________
Opensim-users mailing list
[email protected]
https://lists.berlios.de/mailman/listinfo/opensim-users
--
Justin Clark-Casey (justincc)
http://justincc.org/blog
http://twitter.com/justincc
_______________________________________________
Opensim-users mailing list
[email protected]
https://lists.berlios.de/mailman/listinfo/opensim-users
