From: Date: December 31 2005 3:09am
Subject: Table Lock issue on insert
List-Archive: http://lists.mysql.com/mysql/193379
Message-Id: <B142CF551708F24DBBF12A80BE522A60E094CC@WA-MSG16-BTH.wireless.attws.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----_=_NextPart_001_01C60DAF.4D880F9A"

------_=_NextPart_001_01C60DAF.4D880F9A
Content-Type: text/plain;
	charset="US-ASCII"
Content-Transfer-Encoding: quoted-printable

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;

=20

I keep getting this error: #1206 - The total number of locks exceeds the
lock table size

=20

How do I fix this?

=20


------_=_NextPart_001_01C60DAF.4D880F9A--