Sparx Systems Forum

Enterprise Architect => General Board => Topic started by: K N on May 23, 2013, 12:07:56 am

Title: MySQL server configuration
Post by: K N on May 23, 2013, 12:07:56 am

Hi

I have setup EA repository with multiple projects.
Just want to know what Sparxsystem recommends the MySQL server configuration should be in terms of memory, power, storage etc for optimum performance.

Thanks
KN

Title: Re: MySQL server configuration
Post by: Geert Bellekens on May 23, 2013, 04:09:36 pm

KN,

We have a rather large EA model on SQL Server (80.000 elements)
When I transfer that model to a .eap file it ends up as a 400 MB file.
In SQL Server I have a total size of 4 GB consisting of 1 GB of rows data, and 3 GB of log file.
That should give you an idea about the order magnitude of the size of EA models.

As for the other parameters, just know that EA generally executes thousands of small queries a minute rather then a few large queries, so you should optimize for such a usage.

Geert

Title: Re: MySQL server configuration
Post by: K N on May 30, 2013, 11:48:18 pm

Thanks Geert!! I will have to check it with my DB Admin for this.

Title: Re: MySQL server configuration
Post by: K N on May 31, 2013, 01:41:15 am

@Geert - This is what I received from the DB admin about the Server Configuration:

              DiskSpace 8.2G (2.9G Used)
              CPU Information 1 CPU E5502
              RAM: 1GB

Do you think this is optimum?

Thanks
KN

Title: Re: MySQL server configuration
Post by: Geert Bellekens on May 31, 2013, 03:48:33 pm

I wouldn't know.
I have no idea about the hardware specifications of our servers.

Amount of RAM seems a bit on the low side though (my workstation has 8GB, and I'm guessing our servers have a couple of times that).

What you also should look at is the network. In some configurations that might be the bottleneck.

Geert