MySQL server configuration

[K N]

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

[Geert Bellekens]

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

[K N]

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

[K N]

@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

[Geert Bellekens]

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