index_event table has been truncated

[t_christensen]

We had an incident with our clients Magnto 1.9 shop this friday.

Somehow product index failed and products vanished from the shop.

My question is ... how is it possible for table index_event to become truncated ... all data missing?

Can Magento empty/truncate this table by itself?

[Tom Robertshaw · Accepted solution]

I've never come across this table being truncated automatically. It's commonly a table that is truncated manually to clean up database space though by developers/sys admins. 

index_events table being empty shouldn't be stopping products from being indexed though. Have you managed to find out any more info on this since you posted?

I recommend setting up indexing based on cron (manual update rather than update on save) to cover your bases here.