Author Topic: EA and MySQL interaction with table t_xref data  (Read 2240 times)

ChrisBD

  • EA User
  • **
  • Posts: 60
  • Karma: +0/-0
    • View Profile
EA and MySQL interaction with table t_xref data
« 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.

beginner

  • Guest
Re: EA and MySQL interaction with table t_xref dat
« Reply #1 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.

ChrisBD

  • EA User
  • **
  • Posts: 60
  • Karma: +0/-0
    • View Profile
Re: EA and MySQL interaction with table t_xref dat
« Reply #2 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. :-/


hd

  • EA Administrator
  • EA User
  • *****
  • Posts: 312
  • Karma: +0/-0
    • View Profile
Re: EA and MySQL interaction with table t_xref dat
« Reply #3 on: March 26, 2010, 07:59:55 am »

ChrisBD

  • EA User
  • **
  • Posts: 60
  • Karma: +0/-0
    • View Profile
Re: EA and MySQL interaction with table t_xref dat
« Reply #4 on: March 26, 2010, 06:46:22 pm »
Ah thank you I shall give that a try.

beginner

  • Guest
Re: EA and MySQL interaction with table t_xref dat
« Reply #5 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.