MySQL Transactional Databases Resources

SHOW INNODB STATUS Walk Through
By: Peter Zaitsev
http://www.mysqlperformanceblog.com/2006/07/17/show-innodb-status-walk-through/

I found Peter’s blog from a StackOverflow question about deadlocking. It’s well documented and looks promoising. Here is the link for the orginal SO question.

http://stackoverflow.com/questions/1851528/mysql-deadlock-explanation-needed

MySQL 5.0 Reference Manual – The InnoDB Transaction Model and Locking
http://dev.mysql.com/doc/refman/5.0/en/innodb-transaction-model.html

Manuals are always good reads.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s