Sparx Systems Forum

Enterprise Architect => General Board => Topic started by: ChrisBD on March 26, 2010, 12:43:50 am

Title: EA and MySQL interaction with table t_xref data
Post by: ChrisBD on March 26, 2010, 12:43:50 am
We are having problems with slow queries in our MySQL model database. We are running EA 7.5.848 with ClearCase for version control.
From looking at the slowquery log, we occaisionally see over 120 seconds for for the following query to run:

Code: [Select]
Select t_xref.`Type`, client.Object_ID as ClientID, client.Name as ClientName, client.Object_Type as ClientType, supplier.Object_ID as SupplierID, supplier.Name as SupplierName, supplier.Object_Type as SupplierType from t_xref, t_object client, t_object supplier where t_xref.Client = client.ea_guid and t_xref.Supplier = supplier.ea_guid;
I think that it is triggered whenever someone performs a check-out or GetLatest.
It is probably taking so long as it is searching through 101925 rows of data in order to match up the client.ea_guid and the supplier.ea_guid.

Would the client be EA package and the supplier ClearCase maybe?

Does anyone have any input of what is going on here? I'm wondering if ea_guid isn't indexed.
Title: Re: EA and MySQL interaction with table t_xref dat
Post by: beginner on March 26, 2010, 01:01:40 am
t_xref.Supplier and .Client are both indexed here. Maybe someone removed the index on your server?

b.
Title: Re: EA and MySQL interaction with table t_xref dat
Post by: ChrisBD on March 26, 2010, 01:34:52 am
It makes you wonder, doesn't it.
Unfortunately it's not a server that I have access to which makes it difficult.

I'm currently trying to get either an sqldump output or failing that a backup, but I'm not holding my breath. :-/

Title: Re: EA and MySQL interaction with table t_xref dat
Post by: hd on March 26, 2010, 07:59:55 am
There's an index patch on the website...
http://www.sparxsystems.com/downloads/corp/updates/MySQLScriptUpdatePatch.xml
Title: Re: EA and MySQL interaction with table t_xref dat
Post by: ChrisBD on March 26, 2010, 06:46:22 pm
Ah thank you I shall give that a try.
Title: Re: EA and MySQL interaction with table t_xref dat
Post by: beginner on March 26, 2010, 07:07:24 pm
Quote
There's an index patch on the website...
http://www.sparxsystems.com/downloads/corp/updates/MySQLScriptUpdatePatch.xml
How do you manage to appear as "EA-User" with no stars?

b.