mysql ssl support

2004-09-30 Thread Andy Wong
Hi All, I'm confused by seemingly conflicting information between the mysql doc, the high performance mysql book, and a mysql press release (http://www.mysql.com/news-and-events/press-release/release_2003_05.html) regarding mysql's SSL support. What's the difference between mysql 4.0's SSL suppor

Re: Updates locking out inserts in transactions for no apparent reason

2004-06-14 Thread Andy Wong
Dear Marko, It does look like the result of a gap lock, but notice that I used both primary keys in the where clause of my update query, therefore it should only match (and update) 1 row. From my understanding (correct me if I'm wrong, my knowledge of how mysql works is gleaned from the mysql docs

Updates locking out inserts in transactions for no apparent reason

2004-06-10 Thread Andy Wong
Hi all, This is my first time on the mysql mailing list, I appreciate if someone can help me with a major problem I encountered with mysql. I have this weird problem with 1 transaction locking out another for no apparent reason and in an inconsistent fashion. I'm using mysql 4.0.18 with innodb ta