BUG: Performance Issue MySQL DB using v7.0.816

[xcentricdave]

Following upgrade to v7.0.816 we now have a performance problem when adding elements to diagrams.

- Open Diagram
- Drag on element
- Fill in details
- Click OK
= *** Wait 20 seconds ***
- Element added.

The same operation was near instantaneous in v6.5.804.

Configuration: PC clients running on LAN to local MySQL (v5) DB.

[bug reported to Sparx: 06 Sept 2007 07:48 AM (GMT+2)]

[«Midnight»]

Yes Paolo,

This seems to have only recently popped up, and has previously been reported in MySql. I suggested the original 'reporter' submit the bug (since I don't have the appropriate configuration, and could not work effectively with Sparx). I've seen nothing to suggest the bug report was submitted.

Thanks for doing so.

David

[xcentricdave]

Does that mean the bug I reported via the Sparx website hasn't been logged, or were you refering to the person in the past who report MySQL problems...

I have an autorespond email from Sparx saying my bug had been received.  

Is there a 'Sticky' post explaining for EA forum newbs how bugs should be reported? I'm hoping that I've got it right:

- Search websites and FAQs, RTFM.
- Ask on forum if anyone else has a solution
- If not then report a bug to Sparx and create a message on the forum that a bug as been raised. (Standard format for forum message?)

cheers,
Dave

[xcentricdave]

Been checking all the MySQL server parameters and improved the config somewhat. But the element insert is still +/- 20sec. Have turned on log-slow-queries, and the offending query is:

Code: [Select]


/usr/sbin/mysqld, Version: 5.0.18-log. started with:
Tcp port: 3306  Unix socket: /var/lib/mysql/mysql.sock
Time                 Id Command    Argument
# Time: 070907 11:51:23
# User@Host: Name[Name] @  [IPAddr]
# Query_time: 16  Lock_time: 0  Rows_sent: 0  Rows_examined: 19753
use eav7test;
Select t_operationparams.OperationID from t_connector, t_connectortag, t_operationtag, t_operationparams where t_connector.Connector_ID=t_connectortag.ElementID  and t_operationparams.OperationID=t_operationtag.ElementID and t_connectortag.Property='operation_guid' and t_connectortag.VALUE= t_operationtag.VALUE and t_operationtag.Property='ea_guid' and t_operationparams.Classifier='117872' UNION  Select t_operation.OperationID from t_connector, t_connectortag, t_operationtag, t_operation where t_connector.Connector_ID=t_connectortag.ElementID  and t_connectortag.Property='operation_guid' and t_connectortag.VALUE= t_operationtag.VALUE and t_operationtag.Property='ea_guid' and t_operationtag.ElementID=t_operation.OperationID and t_operation.Classifier='117872';


Does that help whomever is looking at this issue? Does this get to the support/bug people?

cheers,
Dave

[«Midnight»]

Does that mean the bug I reported via the Sparx website hasn't been logged, or were you refering to the person in the past who report MySQL problems...

I have an autorespond email from Sparx saying my bug had been received.  

Is there a 'Sticky' post explaining for EA forum newbs how bugs should be reported? I'm hoping that I've got it right:

- Search websites and FAQs, RTFM.
- Ask on forum if anyone else has a solution
- If not then report a bug to Sparx and create a message on the forum that a bug as been raised. (Standard format for forum message?)

cheers,
Dave

Dave,

You've done this correctly, by reporting the bug to Sparx.

Unfortunately there is no such sticky post, or FAQ section in the forum - at least not as yet.

Let's hope that this gets some attention soon. In past situations such as this have usually been resolved very quickly. I know this particular bug has been reported by another source as well.

With luck Sparx might be able to get a resolution into build 817.

David

[xcentricdave]

Thanks to the nice people at Sparx!

Adding the following indexes to the repository has cured the problem!

Code: [Select]


create index `Property` on `t_connectortag`(`Property`);
create index `VALUE` on `t_connectortag`(`VALUE`);
create index `Classifier` on `t_operation`(`Classifier`);
create index `Classifier` on `t_operationparams`(`Classifier`);


[KP]

Is there a 'Sticky' post explaining for EA forum newbs how bugs should be reported?

Good idea - I'll have a go at writing one...

[«Midnight»]

Good idea - I'll have a go at writing one...

Thanks Neil,

While you're at it, please include feature requests as well. With the exception of our (neither official nor scientific) voting it is pretty much the same process.

David