[Opensim-users] database question and issues

[Ideia Boa]

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/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://opensimulator.org/pipermail/opensim-users/attachments/20081119/da2fca35/attachment.html>