<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Cange to 2147483 thais is tha max permited not 10000000<br>
<br>
Ideia Boa<br>
<br>
<br>
<br>
Paul Fishwick wrote:
<blockquote cite="mid:49246EAF.6010903@cise.ufl.edu" type="cite">
<pre wrap="">That is what we tried, but it didn't seem to
work. Here is the section of the revised
my.ini :
#
# Fine Tuning for OpenSim
#
key_buffer = 16M
max_allowed_packet = 16M
thread_stack = 128K
thread_cache_size = 16
thread_concurrency = 10
interactive_timeout = 10000000
wait_timeout = 10000000
query_cache_limit = 1M
query_cache_size = 16M
expire_logs_days = 10
max_binlog_size = 100M
skip-bdb
that was posted here:
<a class="moz-txt-link-freetext" href="http://opensimulator.org/mantis/view.php?id=2605">http://opensimulator.org/mantis/view.php?id=2605</a>
-
Ideia Boa wrote:
</pre>
<blockquote type="cite">
<pre wrap="">You solve your problem changing the MySql's "wait timeout" to the max
time (2,147,483)
Ideia Boa
Paul Fishwick wrote:
</pre>
<blockquote type="cite">
<pre wrap="">I am going to venture a guess (could be wrong, but will test it) that
the situation
arises only for regions or grids that literally have no continuous
activity that would require
DB access during the extended down period. This is a common situation
when one
begins terraforming or testing a new space. For example, on my grid, I
haven't
really built anything yet, and have a few prims, sculpty's and megaprims
but nothing
that contains an LSL or C# script using timer(). We'll see if that
solves the
problem.
-p
matt raffel wrote:
</pre>
<blockquote type="cite">
<pre wrap="">I have seen this problem myself. Same config: XP and MySql. I have
had cases where the connection is not lost and everything works in the
next am. I have had cases where the connection is lost and I have restart.
Matt
Paul Fishwick wrote:
</pre>
<blockquote type="cite">
<pre wrap="">I corrected them but, unfortunately, they didn't solve the problem (I posted
the mantis report as of this morning)....
p
Lc wrote:
</pre>
<blockquote type="cite">
<pre wrap="">the default mysql config's file is not correct for opensim.
There are few mantis with some corrects settings.
Sm
On Wed, Nov 19, 2008 at 3:20 PM, Paul Fishwick <<a class="moz-txt-link-abbreviated" href="mailto:fishwick@cise.ufl.edu">fishwick@cise.ufl.edu</a>
<a class="moz-txt-link-rfc2396E" href="mailto:fishwick@cise.ufl.edu"><mailto:fishwick@cise.ufl.edu></a>> wrote:
Some questions on databases for OpenSim:
(1) Does anyone have any statistics or insight on the relative
efficiency
of MySQL vs. SQLite ? I am using both but do not have enough
assets
to see a difference. I would guess that SQLite might be less
efficient
when assets reach a certain level, but I have no idea what
that level
might be.
(2) Has anyone experienced problems on Windows XP or Vista with MySQL
timing out if left unused overnight? I have been reporting MySQL
exceptions that occur only after the database has not been
access
in a few
hours---the database seems to go to sleep and OpenSim has
problems
reconnecting.
(3) Given (2), is there a convenient workaround, perhaps, where I
engage the
access to the DB, and would be reflected in the server console
windows?
Perhaps, an LSL script that changes a prim attribute every 30
seconds...hmm...
maybe this is a worth a test later tonight. If this keeps
the SQL
engine busy,
this might be a quick solution.
Problem (2) is so serious that, for my installation, it makes
using MySQL on
Windows unusable. It works fine with there is periodic activity, but
then leave
it alone for several hours, and reconnecting is a critical problem.
-paul
--
Dr. Paul A. Fishwick E-Mail: <a class="moz-txt-link-abbreviated" href="mailto:fishwick@cise.ufl.edu">fishwick@cise.ufl.edu</a>
<a class="moz-txt-link-rfc2396E" href="mailto:fishwick@cise.ufl.edu"><mailto:fishwick@cise.ufl.edu></a>
Dept. of Computer & Info Phone & FAX: (352) 392-1414
Science and Engineering WWW:
<a class="moz-txt-link-freetext" href="http://www.cise.ufl.edu/~fishwick">http://www.cise.ufl.edu/~fishwick</a>
<a class="moz-txt-link-rfc2396E" href="http://www.cise.ufl.edu/%7Efishwick"><http://www.cise.ufl.edu/%7Efishwick></a>
University of Florida (PGP Key available at above WWW
address)
P. O. Box 116120
332 Bldg. CSE, Gainesville, FL 32611-6120
_______________________________________________
Opensim-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Opensim-users@lists.berlios.de">Opensim-users@lists.berlios.de</a> <a class="moz-txt-link-rfc2396E" href="mailto:Opensim-users@lists.berlios.de"><mailto:Opensim-users@lists.berlios.de></a>
<a class="moz-txt-link-freetext" href="https://lists.berlios.de/mailman/listinfo/opensim-users">https://lists.berlios.de/mailman/listinfo/opensim-users</a>
------------------------------------------------------------------------
_______________________________________________
Opensim-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Opensim-users@lists.berlios.de">Opensim-users@lists.berlios.de</a>
<a class="moz-txt-link-freetext" href="https://lists.berlios.de/mailman/listinfo/opensim-users">https://lists.berlios.de/mailman/listinfo/opensim-users</a>
</pre>
</blockquote>
<pre wrap="">
</pre>
</blockquote>
<pre wrap="">_______________________________________________
Opensim-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Opensim-users@lists.berlios.de">Opensim-users@lists.berlios.de</a>
<a class="moz-txt-link-freetext" href="https://lists.berlios.de/mailman/listinfo/opensim-users">https://lists.berlios.de/mailman/listinfo/opensim-users</a>
</pre>
</blockquote>
<pre wrap="">
</pre>
</blockquote>
<pre wrap="">--
Best regards,
Ideia Boa
OpenSimPT
Join the new 3D world revolution : <a class="moz-txt-link-freetext" href="http://www.opensimpt.com/">http://www.opensimpt.com/</a>
------------------------------------------------------------------------
_______________________________________________
Opensim-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Opensim-users@lists.berlios.de">Opensim-users@lists.berlios.de</a>
<a class="moz-txt-link-freetext" href="https://lists.berlios.de/mailman/listinfo/opensim-users">https://lists.berlios.de/mailman/listinfo/opensim-users</a>
</pre>
</blockquote>
<pre wrap=""><!---->
</pre>
</blockquote>
<br>
<div class="moz-signature">-- <br>
Best regards,<br>
Ideia Boa<br>
OpenSimPT<br>
<br>
Join the new 3D world revolution : <a class="moz-txt-link-freetext" href="http://www.opensimpt.com/">http://www.opensimpt.com/</a></div>
</body>
</html>