We have a java-based webapp that talks to MySQL 5.1 INNODB in READ_COMMITTED.
We use Hibernate and optimistic concurrency, so periodically concurrent write
attempts cause app-level Exceptions that trigger rollbacks (and then we retry
tx). We've added app-level caching and turned down our tomcat
Hi,
I'd really appreciate help with reading this db deadlock notice.
Essentially, I'd like to understand:
-what holds the lock that TX2 is waiting on index `token` of table
`eviltwin/user_sessions`? I thought it'd be TX1 (hence deadlock ?), yet
it appears that TX1 holds no locks
-if the an
Hi,
Is it possible to rename a DB schema? if so how? Using mysql 5.0, innodb
engine.
-nikita
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
D]
On Sep 8, 2006, at 12:27 PM, Nikita Tovstoles wrote:
Hi,
I'm diffing two versions of a schema produced using mysqldump and
would like to know if there's a way to make mysqldump sort entries
inside CREATE statements (say alphabetically or in some other way)?
Currently some of the
Hi,
I'm diffing two versions of a schema produced using mysqldump and would
like to know if there's a way to make mysqldump sort entries inside
CREATE statements (say alphabetically or in some other way)? Currently
some of the column declarations are juxtaposed between the versions and
thus p
I'm new to MySQL mailing lists. Is there a more appropriate list for
this type of question?
thanks
-nikita
Nikita Tovstoles wrote:
Hi,
I'm running into lost of DB deadlocks would really appreciate answers
to the questions below which will help me diagnose the problem. I am
runni
Hi,
I'm running into lost of DB deadlocks would really appreciate answers to
the questions below which will help me diagnose the problem. I am
running MySQL 5 InnoDB, SERIALIZABLE mode.
Let's say we have:
1.TX1 START //assume autocommit is off
2.TX1 read on TableA
3.TX1 update on TableA
4.TX
