Re: Poor performance vs. MSSQL with JDBC
David Wynter wrote:
> Correction, it is a display limit per line in the
> Query browser. The reason it does not execute the
> multiple statements is that it, like the cmd line
> tool, uses ';' to execute, so everything after the
> first one is just a part of a syntax error as far
> as it is concerned.
>
> Without decent diagnstics it is not going to be
> possible for me to use MySQL. I still do not see
> how I can determine why some of my queries to the
> child table (in my parent, child, grandchild
> scenario described previously) take over 500ms
> when the transaction is isolated from queries on
> the tables at the other end of both its foreign
> keys. In MS SQL the Enterprise Manager tells me at
> runtime precisely which transaction is locking
> another, anything similar?
David,
InnoDB has pretty decent diagnostics (just not graphically represented yet). You might have more luck posting your problem to the
mysql@lists.mysql mailing list, since the InnoDB developers, as well as many more users hang out there.
-Mark
Mark Matthews
Consulting Member Technical Staff - MySQL Enterprise Tools
Oracle
http://www.mysql.com/products/enterprise/monitor.html