innodb « mysql « Java Database Q&A

1. what are the difference between InnoDB and MyISAM    stackoverflow.com

what are the difference between InnoDB and MyISAM. Which one I can go for? any areas where one provides and other doesnot provide? IS there any technological limitations in any of the both types? Please ...

2. MySQL InnoDB hangs on waiting for table-level locks    stackoverflow.com

I have a big production web-application (Glassfish 3.1 + MySQL 5.5). All tables are InnoDB. Once per several days application totally hangs. SHOW FULL PROCESSLIST shows many simple insert or update ...

3. Error when changing DB engine from MyIsam to innoDB    stackoverflow.com

I've changed my DB engine of my Java webapplication to innoDB from MyIsam. I'm using a MySql DB. For some reason I now get an error on the creation of my ...

4. MySQL JDBC: Is there an option for automatic retry after InnoDB deadlock?    stackoverflow.com

I am Working around MySQL error “Deadlock found when trying to get lock; try restarting transaction” I found out that the transaction can be safely reattempted

Deadlocks are not ...

5. ACID Problems in a Multithreaded Environment    stackoverflow.com

I have a multi-threaded java application which executes a lot of parallel CRUD operations on an MySQL Database. As read in MySQL manuals, InnoDB table structure should ensure, that the transactions ...

6. Search on MySQL InnoDB    coderanch.com