[Opensim-users] database question and issues

Wed Nov 19 20:07:07 UTC 2008

Ok, I'll try, although I thought that when MySQL processed this on startup,
it gave me a message to the effect that it changed the timeout to the
max value you suggest. I'll double check.
-p

Ideia Boa wrote:
> Cange to 2147483 thais is tha max permited not 10000000
>
> Ideia Boa
>
>
>
> Paul Fishwick wrote:
>> 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
>>>   
>>>     
>>
>>
>>   
>
> -- 
> 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