mysql error: The total number of locks exceeds the lock table size

[tembil]

Hi,

can anyone plz help me, I'm trying to insert data into a table from another table and I'm getting this error:
The total number of locks exceeds the lock table size, how can I fix this.
thanx

[debasisdas]

This link might be useful.