Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

Index_event, Index_process, Index_process_event
 
shmk
Sr. Member
 
Total Posts:  297
Joined:  2009-10-28
 

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?

 
Magento Community Magento Community
Magento Community
Magento Community
 
MagentoECG
Magento Team
 
Avatar
Total Posts:  189
Joined:  2011-02-25
Worldwide
 

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>

 
Magento Community Magento Community
Magento Community
Magento Community
 
Bazz78
Sr. Member
 
Avatar
Total Posts:  156
Joined:  2008-06-16
Italy
 

Hi

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

 
Magento Community Magento Community
Magento Community
Magento Community
 
GregC
Sr. Member
 
Avatar
Total Posts:  76
Joined:  2007-11-23
A^2, MI
 

Truncate Yes, Delete No

SET FOREIGN_KEY_CHECKS=0;
TRUNCATE INDEX_PROCESS_EVENT;
TRUNCATE INDEX_EVENT;
SET FOREIGN_KEY_CHECKS=1;
 
Magento Community Magento Community
Magento Community
Magento Community
 
miszymang
Jr. Member
 
Total Posts:  2
Joined:  2013-03-26
 

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

GregC - 08 February 2013 06:11 AM

Truncate Yes, Delete No

SET FOREIGN_KEY_CHECKS=0;
TRUNCATE INDEX_PROCESS_EVENT;
TRUNCATE INDEX_EVENT;
SET FOREIGN_KEY_CHECKS=1;
 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top