[Opensim-users] database question and issues

[Paul Fishwick]

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:
> 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:
>   
>> I corrected them but, unfortunately, they didn't solve the problem (I posted
>> the mantis report as of this morning)....
>> p
>>
>> Lc wrote:
>>   
>>     
>>> 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 <fishwick at cise.ufl.edu 
>>> <mailto:fishwick at cise.ufl.edu>> 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: fishwick at cise.ufl.edu
>>>     <mailto:fishwick at cise.ufl.edu>
>>>     Dept. of Computer & Info       Phone & FAX: (352) 392-1414
>>>      Science and Engineering       WWW:
>>>     http://www.cise.ufl.edu/~fishwick
>>>     <http://www.cise.ufl.edu/%7Efishwick>
>>>     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
>>>     Opensim-users at lists.berlios.de <mailto:Opensim-users at lists.berlios.de>
>>>     https://lists.berlios.de/mailman/listinfo/opensim-users
>>>
>>>
>>> ------------------------------------------------------------------------
>>>
>>> _______________________________________________
>>> Opensim-users mailing list
>>> Opensim-users at lists.berlios.de
>>> https://lists.berlios.de/mailman/listinfo/opensim-users
>>>   
>>>     
>>>       
>>   
>>     
>
> _______________________________________________
> Opensim-users mailing list
> Opensim-users at lists.berlios.de
> https://lists.berlios.de/mailman/listinfo/opensim-users
>
>   


-- 
Dr. Paul A. Fishwick           E-Mail: fishwick at cise.ufl.edu
Dept. of Computer & Info       Phone & FAX: (352) 392-1414
 Science and Engineering       WWW: http://www.cise.ufl.edu/~fishwick
University of Florida          (PGP Key available at above WWW address)
P. O. Box 116120
332 Bldg. CSE, Gainesville, FL 32611-6120