Re: ERROR 1206 The total number of locks exceeds the lock table size

[John Rocha]

Hello Rick,

Thanks for the suggestion, I'll give that a try.

I found another workaround that is the following:


Create target table that has the new column

For each parition in the source table
....Create a matching partition in the target table
....For each event type
........Find all entries for the event type in the partition
........and insert them into the source table, setting the
........event type during the insertion (using insert select)
....Drop the source parition
Drop the source table

Rename the target table to the source table.

This works, but I want to see if your method will work faster!

Thanks for the suggestion.