[Opensim-users] database question and issues

[Ideia Boa]

You solve your problem changing the MySql's "wait timeout" to the max 
time (2,147,483)

Ideia Boa



Paul Fishwick wrote:
> 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
>>
>>   
>>     
>
>
>   

-- 
Best regards,
Ideia Boa
OpenSimPT

Join the new 3D world revolution : http://www.opensimpt.com/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://opensimulator.org/pipermail/opensim-users/attachments/20081119/22865f2f/attachment.html>