Re: MySQL does not release locks

2003-09-05 Thread Heikki Tuuri
/ - Original Message - From: "Teemu Kuulasmaa" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Friday, September 05, 2003 12:53 AM Subject: Re: MySQL does not release locks > Heikki, > > There is not concunrrently running ANY queries on the table I am > ALTE

Re: MySQL does not release locks

2003-09-04 Thread Teemu Kuulasmaa
for MySQL Order MySQL support from http://www.mysql.com/support/index.html ........... Subject: Re: MySQL does not release locks From: Teemu Kuulasmaa Date: Thu, 04 Sep 2003 14:54:56 +0300 Hi, Unfortunately, nobody responded my mail. I am still trying to solve the problem I described in my e

Re: MySQL does not release locks

2003-09-04 Thread Heikki Tuuri
QL support from http://www.mysql.com/support/index.html ... Subject: Re: MySQL does not release locks From: Teemu Kuulasmaa Date: Thu, 04 Sep 2003 14:54:56 +0300 Hi, Unfortunately, nobody responded my mail. I am still trying to solve the problem I described in my earlier mail (qu

Re: MySQL does not release locks

2003-09-04 Thread Teemu Kuulasmaa
Hi, Unfortunately, nobody responded my mail. I am still trying to solve the problem I described in my earlier mail (quoted below). I am mailing again because I have some new information about the issue. I converted all my tables to InnoDB (MyISAM -> InnoDB) and this solved the problem. With In

MySQL does not release locks

2003-08-27 Thread Teemu Kuulasmaa
Hi I have problems with mysql (4.0.6-4.0.14b) on windows 2000 SP3. MySQL locks tables when I alter table structure or execute update queries. I know that this is the exactly what database engine is supposed to do but the engine doesn't release the locks at all. This happens frequently but not