Full Innodb Table Locks deadlocking with AUTO_INC locks.

2007-10-02 Thread William Newton
Hello List, I discovered an unusual problem with the way Innodb handles the AUTO_INC lock with a full table lock. I was wondering if this is a known issue, or I'm doing something completely wrong. I'm working with MYSQL Server version: 5.0.42-debug-log on Gentoo Linux. So lets say I have

Re: Full Innodb Table Locks deadlocking with AUTO_INC locks.

2007-10-02 Thread Baron Schwartz
Hi William, William Newton wrote: Hello List, I discovered an unusual problem with the way Innodb handles the AUTO_INC lock with a full table lock. I was wondering if this is a known issue, or I'm doing something completely wrong. I'm working with MYSQL Server version: 5.0.42-debug-log on

Re: Full Innodb Table Locks deadlocking with AUTO_INC locks.

2007-10-02 Thread William Newton
From: Baron Schwartz [EMAIL PROTECTED] To: William Newton [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent: Tuesday, October 2, 2007 12:05:41 PM Subject: Re: Full Innodb Table Locks deadlocking with AUTO_INC locks. Hi William, William Newton wrote: Hello List, I discovered an unusual problem

Re: Full Innodb Table Locks deadlocking with AUTO_INC locks.

2007-10-02 Thread Baron Schwartz
From: Baron Schwartz [EMAIL PROTECTED] To: William Newton [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent: Tuesday, October 2, 2007 12:05:41 PM Subject: Re: Full Innodb Table Locks deadlocking with AUTO_INC locks. Hi William, William Newton wrote: Hello List, I discovered an unusual problem

Too many table-locks

2006-08-21 Thread Marco Simon
sec and more) on the table which is holding the user's posts. There are aprox. 3.3 Mio records in that table which consumes a size of 1.5 GB. The table-format is myisam. So far switching to innodb mostly soluted my problems with table locks. But because of the table size and the limited Memory I

Re: Too many table-locks

2006-08-21 Thread Adrian Bruce
. 3.3 Mio records in that table which consumes a size of 1.5 GB. The table-format is myisam. So far switching to innodb mostly soluted my problems with table locks. But because of the table size and the limited Memory I can't switch to inno-db in this case. Are there any other conceptional

Re: Too many table-locks

2006-08-21 Thread Dan Buettner
sec and more) on the table which is holding the user's posts. There are aprox. 3.3 Mio records in that table which consumes a size of 1.5 GB. The table-format is myisam. So far switching to innodb mostly soluted my problems with table locks. But because of the table size and the limited Memory I

Re: Why do these transactions show table locks?

2006-02-27 Thread Heikki Tuuri
Robert, - Original Message - From: Robert DiFalco [EMAIL PROTECTED] Newsgroups: mailing.database.myodbc Sent: Sunday, February 26, 2006 8:27 PM Subject: RE: Why do these transactions show table locks? It might be important to note that I have a delete trigger on the ELEMS table

Why do these transactions show table locks?

2006-02-26 Thread Robert DiFalco
My understanding is that innodb should not be using table locks for insert, update, or delete. However, the following transactions are showing table locks. What's up? R. ---TRANSACTION 0 4573, ACTIVE 1 sec, OS thread id 3112 setting table lock mysql tables in use 1, locked 0 LOCK WAIT 2 lock

RE: Why do these transactions show table locks?

2006-02-26 Thread Robert DiFalco
-Original Message- From: Robert DiFalco [mailto:[EMAIL PROTECTED] Sent: Sunday, February 26, 2006 9:33 AM To: mysql@lists.mysql.com; [EMAIL PROTECTED] Subject: Why do these transactions show table locks? My understanding is that innodb should not be using table locks for insert, update

Re: MySQL 4 goes to sleep with table locks?

2004-02-07 Thread Alfredo Cole
El Sáb 07 Feb 2004 02:28, escribió: Mr. Alfredo Pls, will you give the complete structure as 'create query' of your database? that will help us to solve your problem. Pradap This is the structure of the table that holds the sequential numbers for various documents that need them: CREATE

MySQL 4 goes to sleep with table locks?

2004-02-06 Thread Alfredo Cole
I am using Mandrake 9.1 and MySQL 4.0.11 from the LM CD's. In my application, I have a table that stores the sequential numbers of invoices prepared by several stores. Every time a salesman prepares an invoice for a customer, the system goes to this table, locks it with lock tables table write

query re: Innodb Table Locks

2003-03-05 Thread Erik DeBattista
to whom it may concern, I need some help regarding transactions using innodb tables. I am running MySQL 3.23.51-Max as database server and developing a web front-end using ASP. Many of the tables used are of innodb format since it is imperative for me to use transactions in most of my scripts.

Re: bug? - FLUSH PRIVILEGES releases table locks

2002-10-17 Thread Donal Diamond
come across some weird behavior with active table locks and flushing privileges - is this a bug? If you lock any table using LOCK TABLES test.locktest READ and later issue a FLUSH PRIVILEGES in the same client, then the lock is released. If you use FLUSH TABLES WITH READ LOCK problem does

Re: Table Locks...

2002-04-21 Thread Gelu
Message - From: Sukhdev Sethi [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, April 20, 2002 9:44 PM Subject: Table Locks... Hi, Lets say that I am the admin on mysql server, how can i know which tables currently are locked? And if they are locked by someone else, how to do I

Table Locks...

2002-04-20 Thread Sukhdev Sethi
Hi, Lets say that I am the admin on mysql server, how can i know which tables currently are locked? And if they are locked by someone else, how to do I remove the locks. Thank you. Rajan. __ Do You Yahoo!? Yahoo! Games - play chess, backgammon,