Hello,
I'm having issues where once every 24-36 hours a replication slave
locks up and I have to kill -9 the process and restart it. I'm using
mysql 5.1.26 and centos 5 (kernel 2.6.18-92.el5) but it's been
occurring since I simultaneously upgraded to 5x and started using the
slave in production (i
Sent: Monday, January 02, 2006 9:31 PM
Subject: Re: Table Lock issue on insert
Hi John,
I have looked around a bit and you might be interested in this part:
InnoDB: Do not intentionally crash mysqld if the buffer pool is
exhausted by the lock table; return error 1206 instead ...
Message-
From: Danny Stolle [mailto:[EMAIL PROTECTED]
Sent: Saturday, December 31, 2005 2:59 AM
To: Brittingham, John; mysql@lists.mysql.com
Subject: Re: Table Lock issue on insert
Hi John,
What kind of engine are you using on your table? MyIsam or InnoDB or are
you using merged tables?
If you
tolle [mailto:[EMAIL PROTECTED]
Sent: Saturday, December 31, 2005 2:59 AM
To: Brittingham, John; mysql@lists.mysql.com
Subject: Re: Table Lock issue on insert
Hi John,
What kind of engine are you using on your table? MyIsam or InnoDB or are
you using merged tables?
If you query your system vari
Hi John,
What kind of engine are you using on your table? MyIsam or InnoDB or are
you using merged tables?
If you query your system variables what is your max_write_lock_count?
If you create a copy of the table: mysql>create table cp1 like
USERS_PER_HOUR; and you try the insert again; is the
I am having trouble with table lock.
The query is as follows:
INSERT INTO USERS_PER_HOUR SELECT count( DISTINCT (
CUID
) ),`TV_LOG_DATE`,`TV_LOG_TIME`, INTERFACE_ID
FROM `TV_LOG_ALL`
group by 2,3;
I keep getting this error: #1206 - The total number of locks exceeds the
lock table size
Justin,
- Alkuperäinen viesti -
Lähettäjä: "Justin Swanhart" <[EMAIL PROTECTED]>
Vastaanottaja: "Sasha Pachev" <[EMAIL PROTECTED]>
Kopio: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Lähetetty: Friday, May 14, 2004 9:22 PM
Aihe: Re: unexpecte
--- Sasha Pachev <[EMAIL PROTECTED]> wrote:
> Very possibly a bug. INNODB deadlocks itself during
> the operation, then detects
> the deadlock and aborts the transaction. If this is
> indeed a bug, I am sure
> Heikki would like to fix it ASAP.
There actually was a "create index" that was being
Hi!
- Original Message -
From: "Sasha Pachev" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, May 13, 2004 3:01 AM
Subject: Re: unexpected create table as lock issue
> [EMAIL PROTECTED] wrote:
[EMAIL PROTECTED] wrote:
I have a table called web_master which has as a
primary key column called web_id.
When I try to create another table as a select, I get
the following error message [note, that group_id is
indexed]:
mysql> create table sort_test as select * from
web_master where group_id = 6
I have a table called web_master which has as a
primary key column called web_id.
When I try to create another table as a select, I get
the following error message [note, that group_id is
indexed]:
mysql> create table sort_test as select * from
web_master where group_id = 69;
ERROR 1205: Lock w
Can anyone help me with monitoring locks?
mysql, sql, query
___
Alvaro Online Mail (c) 2001
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.my
12 matches
Mail list logo
