[Opensim-users] MySQL on seperate server?

Thu Feb 18 11:02:27 UTC 2010

I'm using a Quad Core Q6600 @ 2.40 GHz with 3 GB of RAM and two 372 GB HDs
for Condensation Land. Condensation runs two Opensim instances (8 and 3 sims
respectively)
in a serverless grid configuration AND the MySQL database. I have the OS in
one HD and MySQL
and Opensim in the other HD, and my startup times are < 2 mins even if I
have
sims with > 10000 prims. When I log in with 512 m draw distance, I
experience some lag
for 15 seconds or so (on a 10 Mb ADSL line) while everything is downloaded,
then no lag. Tried it with four avatars, no lag.

Defragmenting the HDs every so often does *a lot* to improve performance.

ymmv

  /Zonja

On Thu, Feb 18, 2010 at 11:26 AM, Impalah Shenzhou <impalah at gmail.com>wrote:

> I arrive late, as usual :-)
>
> When a region has around 12000 primitives, with a db server on the same
> machine you will have hell on earth or something like that.
>
> Boot up time is around 10 minutes and is impossible to do anything but
> using zoom. Impossible to move.
>
> I have tested this with 3 machines (4Gb ram, 500Gb hd RAID, Intel Core Duo
> 1,73, Intel Core duo 2,3 and amd64) running windows XP, Vista and Windows
> 7-64 bits.
>
> I was using grid mode (grid server on separate computer... no ROBUST or
> UGAIM, it uses a PHP ugaim system).
>
> Separating Mysql to another machine on the same local network (100 Mbps nc)
> I could move, build, and even another avatar could enter.
>
> Exporting db and running it on separate server with Linux (ubuntu server
> 9.04) I could fill the region with 5000 more prims and 2 avatars could work
> smooth.
>
> Running opensim on Linux (amd64, 4gb ram, ubuntu server 9.04 64 bits) and
> db on separate linux server 2 avatars could work smoothly and filling the
> region with 25000 prims (no simple prims, but different sizes, texturized
> and scripted).
>
> Anyway, that were my "home" experiences... My conclusion: separate db,
> don't use windows.
>
> Greetings
>
>
>
> 2010/2/16 Steve <steveamigauk at yahoo.co.uk>
>
>  Thank you, although this doesn't tie in to my bandwidth usage reports :/
>>
>> I have 60Gig peak, 240 Gig off peak allowance with my provider download.
>> No limit upload. I have had the sim up and running for a week 24/7 (one
>> region  only - and 24/7 apart from a OpenSimulator version upgrade and the
>> odd restart), using my net connection as normal on my main PC.
>>
>> My usage for 1 - 15 Feb is 11.78 Gig D/L (which includes 3 Gig HD vid from
>> BBC iPlayer) and 2 Gig upload.
>>
>> I was interested in the OP question because I have a SQL server sat on my
>> web hosts servers doing nada, but it looks like I will gain neither
>> performance nor speed by trying to use it, nor will I save any bandwidth.
>>
>> This is a real learning experience.
>>
>> Steve
>>
>>
>> On 16/02/2010 8:15 PM, John Mieske wrote:
>>
>> Oh I might add, that is 20 - 40KBytes Upload one way and 20 - 80 KB
>> download one way. I thought I would meantion that.
>> John
>>
>> On Tue, Feb 16, 2010 at 3:14 PM, John Mieske <johnmieske at gmail.com>wrote:
>>
>>> here is an example of what happened to me on a few Grids I have tested.
>>> Per AV I am uploading / downloading roughly 40KBytes a second. Not kBits.
>>> That is full load with everything going on. So I am giving the most I have
>>> seen in this case. That is roughly 320 KBit upload and download just for one
>>> avatar. So in theory, you should be able to push less then 40K IF your
>>> avatars are not really doing all of what they want them to. Example : Voice.
>>>
>>>
>>>  So with a 1 Meg upload, your looking at around 3 Avatars smoothly. If
>>> your going to go with 2 Meg Upload which some of us have, then your could go
>>> to about 7 Avatars smoothly. Again, this is all dependant on what your USERS
>>> are doing. If all are building and in Voice all at once, then 1 Meg = 3
>>> Avatars smoothly.
>>>
>>>  Keep in mind, this is a test I did myself on 5 Grids I have tested.
>>> Each with different ISPs. So if your going to run a Grid you also have to
>>> account that the region that ties into your main region ALSO has to
>>> accomodate for the extra communication between each region that is not on
>>> the same computer / ISP. AND they are constantly 24 / 7 communicating. So if
>>> you have a bandwidth limit, you could be in trouble. At a Previous version
>>> of Sim world, we had 500 Megabytes transfer for about a weeks worth of time.
>>> And that is with only 8 regions and VERY little activity. The limit ?  1
>>> Terribyte. So in one week, we ate up half our bandwidth limit. ( Thats all
>>> the HOST allowed at the time )
>>>
>>>  Bottom line, you MUST do the math to see if this is even possible to
>>> keep running before spending a lot of money.
>>>
>>>  John
>>>
>>>
>>> On Tue, Feb 16, 2010 at 2:41 PM, Steve <steveamigauk at yahoo.co.uk> wrote:
>>>
>>>>  So out of interest, what are the upload limits per avatar for example.
>>>> I have just shy of 1 Mb upload speed, and have happily accommodated 8
>>>> Avatars (after one in particular who was throwing up masses of errors left).
>>>> How far could I, in theory, push it?
>>>>
>>>> Steve
>>>>
>>>>
>>>> On 15/02/2010 11:00 PM, Ken G. wrote:
>>>>
>>>> Alright, thanks Daz for answering my question and thanks to John and
>>>> Master_Mirage for the input. I am just a hobby user of opensim, connected to
>>>> OSGrid, hoping that maybe there was a way to improve my mediocre connection
>>>> :)
>>>>
>>>> Ken aka Key
>>>>
>>>>
>>>> On Mon, Feb 15, 2010 at 3:00 PM, John Mieske <johnmieske at gmail.com>wrote:
>>>>
>>>>> I have to agree with Darren here. If your doing this at home, you might
>>>>> as well have both on the same computer. Your internet in general will
>>>>> dictate what you can do. So if your running this at home, hang up the idea
>>>>> of two computer region serving because no one will see a difference when
>>>>> they already bogg down from a slow internet connection to your region. I
>>>>> have seen some Regions who run them at home with the best of intentions only
>>>>> shut down days later because they realize their internet only allowed 2
>>>>> avatars to run smoothly. When they got to 3, their sim started to crash. It
>>>>> is all about your upload speed. However, if you got a FAT PIPE ( not to
>>>>> smoke hahaha ) then yea you definitely might want to try the way I
>>>>> suggested. Again everything in OpenSim is based on HOW you run your Grid /
>>>>> Regions. Nothing is 100% set one way. I only offered a suggestion to those
>>>>> who could use this benefit. And there are already some servers that has been
>>>>> setup this way and they are smooth.
>>>>>
>>>>>  John
>>>>>
>>>>>   On Mon, Feb 15, 2010 at 3:39 PM, Darren Williams <
>>>>> darren at dmmhosting.co.uk> wrote:
>>>>>
>>>>>>   Ken G asked:
>>>>>>
>>>>>>
>>>>>>
>>>>>> Dumb question from a casual opensim user who is not fully clued in on
>>>>>> it's workings, that popped into my head after reading John Mieske's Space
>>>>>> Grid Station post:
>>>>>>
>>>>>> Is it feasible and sensible while running opensim on a home PC
>>>>>> connection to be able to use a MySQL database on a shared web hosting
>>>>>> server, such as Hostgator for example? If possible, would this type of setup
>>>>>> improve performance of a lightly used standalone or grid-connected sim?
>>>>>> I haven't put much thought into this idea, just wanted to blurt it out
>>>>>> and see if it's worth pursuing.
>>>>>>
>>>>>>
>>>>>>
>>>>>> Ken,
>>>>>>
>>>>>>
>>>>>>
>>>>>> You shouldn’t receive any benefit at all doing the above. In fact it
>>>>>> will probably make things worse.
>>>>>>
>>>>>>
>>>>>>
>>>>>> If I’m reading this right then the region server which you have
>>>>>> running locally would then be pulling/pushing the data from across the net
>>>>>> on the mysql server, back to your machine. It would probably run worse.
>>>>>>
>>>>>>
>>>>>>
>>>>>> Daz
>>>>>>
>>>>>>  _______________________________________________
>>>>>> Opensim-users mailing list
>>>>>> Opensim-users at lists.berlios.de
>>>>>> https://lists.berlios.de/mailman/listinfo/opensim-users
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> John Mieske / Winword Exonar
>>>>> http://johnmieske.org
>>>>> Space Grid Station
>>>>>
>>>>> _______________________________________________
>>>>> Opensim-users mailing list
>>>>> Opensim-users at lists.berlios.de
>>>>> https://lists.berlios.de/mailman/listinfo/opensim-users
>>>>>
>>>>>
>>>> _______________________________________________
>>>> Opensim-users mailing listOpensim-users at lists.berlios.dehttps://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
>>>>
>>>>
>>>
>>>
>>> --
>>> John Mieske / Winword Exonar
>>> http://johnmieske.org
>>> Space Grid Station
>>>
>>
>>
>>
>> --
>> John Mieske / Winword Exonar
>> http://johnmieske.org
>> Space Grid Station
>>
>> _______________________________________________
>> Opensim-users mailing listOpensim-users at lists.berlios.dehttps://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
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://opensimulator.org/pipermail/opensim-users/attachments/20100218/a7867437/attachment.html>