Re: Full Innodb Table Locks deadlocking with AUTO_INC locks.

2007-10-02 Thread Baron Schwartz
--- Original Message 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: Hell

Re: Full Innodb Table Locks deadlocking with AUTO_INC locks.

2007-10-02 Thread William Newton
ssage 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, > &g

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 G

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 this

Re: Too many table-locks

2006-08-21 Thread Dan Buettner
lot and very long locks (30 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

Re: Too many table-locks

2006-08-21 Thread Adrian Bruce
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 can't switch to inno-db in this case. Are there any other

Too many table-locks

2006-08-21 Thread Marco Simon
s (30 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 limite

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 d

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, or

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

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: CRE

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

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. I

Re: bug? - "FLUSH PRIVILEGES" releases table locks

2002-10-17 Thread Donal Diamond
ple. > > You have written the following: > > I've 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

Re: Table Locks...

2002-04-21 Thread Gelu
[EMAIL PROTECTED] - Original 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? A

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, p