The ALTER TABLE statement is too big!
Statements bigger than 4 KB are not logged to HISTORY. the reaon is that HISTORY is kept in memory. And to avoid memory use 'build up' this limit was introduced (I think with 4.07 or around that time). Statements kan be MB's, GB's in size …
The 4K limit is not configurable.
I feel like to repeat my request that HISTROY is spooled to a file and not kept in memory! <_< . Also a statement like
Code:
ALTER TABLE blabla (abbreviated by SQLyog)
in HISTORY would be nice!
I saved the CREATE statement. It is 3,67 KB. ALTER syntax takes a little more. So I guess you just exceeded the limit!
EDIT: I can add that actually it was some af my data that gave cause for this. I have a database with very big photographs (48 bit TIFF-format – each file is around 35 M:cool:. When inserting a lot of those pics history took all available memory. Next system began to swap and everything became incredible slow!
