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
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
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
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
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
. 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
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
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
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
-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
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
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
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.
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
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
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,
16 matches
Mail list logo