[Opensim-users] database question and issues

[matt raffel]

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
>>   
>>     
>
>
>