MySQL ODBC Connector - Re: Table Lock issue on insert

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Re: Table Lock issue on insert

Danny Stolle

2006-01-01, 7:23 am

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

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw

Sponsored Links