Re: Table Lock issue on insert

[Danny Stolle]

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