Magento

What is the function of these 3 tables?

Index_event,
Index_process,
Index_process_event

Because I have “Index_process_event” increasing his size and now it has over 34000 rows inside.

While Index_event is my biggest table in MB.

Is it a normal behavior? Can I do something to solve it?

Hi shmk,

This tables are related to magento indexing system.
Table `index_event` contains data about events that occured in magento. The event is occured when entity is changing it’s state (for example product is saving, stock item is deleting, etc.)
Table `index_process` contains information about indexers that declared in magento.
Table `index_process_event` contain status for certain event and process that processed this event,

I have “Index_process_event” increasing his size and now it has over 34000 rows inside.

It\’s normal, because new events are occuring in magento so `index_event` and `index_process_event` are increasing.

<Om>

Hi

I have a question.... Can I delete these tables safely?

Truncate Yes, Delete No

could someone from the MAGENTO Team confirm that it is safe to run this query?

GregC - 08 February 2013 07:11 AM

Truncate Yes, Delete No

SET FOREIGN_KEY_CHECKS=0;
TRUNCATE INDEX_PROCESS_EVENT;
TRUNCATE INDEX_EVENT;
SET FOREIGN_KEY_CHECKS=1;