[Opensim-users] database question and issues

[Paul Fishwick]

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:

http://opensimulator.org/mantis/view.php?id=2605
-

Ideia Boa wrote:
> 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/
> ------------------------------------------------------------------------
>
> _______________________________________________
> 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