From: Date: December 31 2005 11:58am
Subject: Re: Table Lock issue on insert
List-Archive: http://lists.mysql.com/mysql/193386
Message-Id: <43B66473.20107@chello.nl>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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 error gone?

Danny



Brittingham, John wrote:
> 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
> 
>  
> 
> How do I fix this?
> 
>  
> 
>