| Danny Stolle 2006-01-02, 8:23 pm |
| 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 ...
check this link: http://dev.mysql.com/doc/refman/4.1/en/news-4-1-8.html
it is quite interesting and i am trying to get this error on my mysql
databases by changing the bufferpool and inserting a lot of data;
Best regards,
Danny
Brittingham, John wrote:
> They are InnoDB and max_write_lock_count
=4294967295.
> The same thing happens when I create a copy of the table.
>
> -----Original Message-----
> From: Danny Stolle [mailto:danny-boy@chello.nl]
> 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 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:
>
>
> the
>
>
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw
|