Slow Access to MySQL DBMS

[mike08]

Hi,

I've tried to transition an .EAP model from EA (Version 10, Build 1009, Systems Engineering Edition) using 32bit MySQL ODBC 5.1. Driver on a Win 7 client to a remote MySQL (tried both 5.6 and 5.1) server on a Win 2008 R2 Server but ran into the following problem: when transferring the EAP model EA takes *a long* time to complete. For a simple new empty systems engineering model EA needs in the order of 10 min to to the transition. If I then open the model from the DBMS location an browse in the project browser, opening the properties of an element will take seconds, opening diagrams will take minutes.

I've tried to enable logging on the MySQL server and I see the queries arriving at a rate of 1/s during EA opening the model.

Has anyone seen that before? What could I try to find the neck of the bottle?

Best,
Mike

[Geert Bellekens]

Hi Mike,

That is slow indeed. We reach hundreds of queries per second sometimes.
I guess that will either be a network issue, or some kind of configuration on the MySQL server.

Geert